class mysqlclient_connection
	{
		private $status;
		private $handle;
		private $server;
		private $database;
		private $username;
		private $password;
		public function __construct($server,$database,$username,$password)
		{
			$status = "closed";
			$handle = 0;
			$thi-->server = $server;
			$this->database = $database;
			$this->username = $username;
			$this->password = $password;
		}
		
		public function open()
		{
			$this->handle = mysql_connect($this->server,$this->username,$this->password) or die("connect mysql faild.");
			if($this->handle != 0)
			{
				//echo "$this->database";
				mysql_select_db($this->database,$this->handle) or ("database ".$database." is not exists or reject visited");
			}
			else
			{
				die("handle == 0");
			}
			$this->status = "open";
			return true;
		}
		
		public function close()
		{
			if($this->status == "open")
			{
				mysql_close($this->handle) or die("falid close this connection");
				$this->status = "closed";
				return true;
			}
			else
			{
				die("this connection is closed");
			}
		}
		
		public function getHandle()
		{
			return $this->handle;
		}
		
		public function __destruct()
		{
			if($this->status == "open")
			{
				mysql_close($this->handle) or die("faild close this connection");
				$this->status = "closed";
				//return true;
			}
		}
	}
	
	class mysqlclient_command
	{
		private $commandString;
		private $activeConnection;
		
		public function __construct($commandString)
		{
			$this->commandString = $commandString;
		}
		
		public function  setActiveConnection($connection)
		{
			$this->activeConnection = $connection;
		}
		
		public function executeDataReader()
		{
			if($this->activeConnection->getHandle() == 0)
			{
				die("this command does not have a active connection");
			}
			//mysql_select_db("mxb",$this->activeConnection->getHandle()) or die("selected faild again");
			$result = mysql_query($this->commandString,$this->activeConnection->getHandle()) or die($this->commandString . $this->activeConnection->getHandle().mysql_error());
			return $result;
		}
		
		public function __destruct()
		{
			//
		}
	}
	
	class mysqlclient_dataReader
	{
		private $result;
		private $rowsCount;
		private $fieldsCount;
		private static $currentPos;
		public function __construct()
		{
			mysqlclient_dataReader::$currentPos = 0;
		}
		
		public function setResult($result)
		{
			$this->result = $result;
			$this->rowsCount = mysql_num_rows($this->result);
			$this->fieldsCount = mysql_num_fields($this->result);
		}
		
		public function nextRecord()
		{
			if(mysqlclient_dataReader::$currentPos < $this->rowsCount)
			{
				$tempRow = mysql_fetch_array($this->result);
				mysqlclient_dataReader::$currentPos++;
				
				return $tempRow;
			}
			else
			{
				return false;
			}
		}
		
		public function getFieldsRow()
		{
			for($i=0;$i<$this->fieldsCount;$i++)
			{
				$field = mysql_fetch_field($this->result,$i);
				$fieldsRow[] = $field;
				
				return $fieldsRow; 
			}
		}
		
		public function __destruct()
		{
			//
		}
	}

			$connection = new mysqlclient_connection(SERVER,DATABASE,USERNAME,PASSWORD);
			$command = new mysqlclient_command("select * from user");
			//$comman-->activeConnection = $connection;
			$command->setActiveConnection($connection);
			
			$connection->open();
			$result = $command->executeDataReader();
			$reader = new mysqlclient_dataReader();
			$reader->setResult($result);
			while($row = $reader->nextRecord())
			{
				echo "
".$row["id"]." : ".$row["name"];
			} 
			
			$connection->close();
		?>