PHP5面向对象查询数据的demo

file 3:DBSql.php

<?
include "config.php";
class DBSql{
     private $con="";
  private $UserName=UserName;
  private $Pass=PassWord;
  private $DBName=DBName;
  private $ServerName=ServerName;
  public $Dao;
  private $number;
  private $Result;
 

  function __construct($DBName='')
 {

   if(!empty($DBName))
   {
           $this->DBName=$DBName;
   }

   $dbase=$this->DBName;

   $connect=@mysql_connect($this->ServerName,$this->UserName,$this->Pass);

   if(!$connect)
  {
    print "<p>Server connection error</p>";
    exit();
  }

  $db=@mysql_select_db($dbase,$connect);

  if(!$db)
  {
   print ("<p>".$dbase." Database Connection Error </p>");
   exit ();
  }

  $this->con=$connect;
  return true;
  }

  function Query($sql)
 {
      if(empty($sql)) return false;
   if(empty($this->con)) return false;
   $results=mysql_query($sql,$this->con);
   if((!$results) or empty($results))
  {
    mysql_free_result($results);
    print "Error".mysql_error();
    return false;
  }

   return $results;
   
 }

 function Num($sql)
 {
  return mysql_num_rows($this->Query($sql));
 }

 function Fetch_row($sql)
 {
  $results=$this->Query($sql);
  $data=mysql_fetch_array($results);
  return $data;
 }

 function Fetch_array($query)
 {
  $data = @mysql_fetch_array($query);
  return $data;
 }

 function Insert_Id($sql)
 {
  $results = $this -> Query ($sql);
  $id = @mysql_insert_id ();
  return $id;
 }
 
 function executeSql($sql)
 {
  $this->Result=$this->Query($sql);
  $this->position=0;
  $this->number=$this->Num($sql);
   if($this->number>0)
  {
   $this->abDao();
   $this->DaoVariables();
  }
  return true;
 }

  
 function abDao()
 {
  $this->Dao=null;
  if($this->position<$this->number)
  {
   $field=$this->Fetch_array($this->Result);
   $this->Dao[$this->position]=$field;
  
  }
 }

   function Select($sql)
 {
    $results=$this->Query($sql);
    $count=0;
    $data=array();
    while($row=mysql_fetch_array($this->results))
  {
     $data[$count]=$row;
     $count++;
  }
  mysql_free_result($results);
  return $data;
 }

  function DaoVariables()
 {
 }

 function __set($name,$value)
 {
  $this->$name=$value;
 }

 function __get($name)
 {
  print "The method does not exist <br>";
 }
 
 function closed()
    {

     mysql_close($this->con);

 }
 }
 

?>

file 4:admin.php

<?
class Admin extends DBSql{
 public $id;
 public $name;
 public $type;
 public $login;
 public $password;

    function __construct()
 {
  parent::__construct();
 }

 function DaoVariables()
 {
  $this->id=$this->Dao[$this->position]["id"];
  $this->name=$this->Dao[$this->position]["name"];
  $this->type=$this->Dao[$this->position]["type"];
  $this->login=$this->Dao[$this->position]["login"];
  $this->password=$this->Dao[$this->position]["password"];

    }

 function SearchAdmin($id='',$name='',$type='')
 {
  $sql="select * from users";
  if(!empty($id))
  {
   $sql.=" where id=".$id;
  }
  $this->executeSql($sql);
 
  
  
 }
}

?>