php 数据库操作基础类DBObject Class的用法示例

php 数据库操作基础类DBObject Class，感兴趣的小伙伴，下面一起跟随脚本之家 jb51.cc的小编来看看吧。
经测试代码如下：

/**
 * 数据库操作基础类DBObject Class
 *
 * @param 
 * @arrange (512.笔记) jb51.cc
 **/
/* WORKS IN PHP5 ONLY */
 class DBObject
 {
  private $id;
  private $id_field;
  private $table_name;
  private $fields = array();
 
  function __construct($table_name,$id_field,$fields)
  {
   $this->table_name = $table_name;
   $this->id_field = $id_field;
 
   foreach($fields as $key)
    $this->fields[$key] = null;
  }
 
  function __get($key)
  {
   return $this->fields[$key];
  }
 
  function __set($key,$value)
  {
   if(array_key_exists($key,$this->fields))
   {
    $this->fields[$key] = $value;
    return true;
   }
   return false;
  }
 
  function select($id)
  {
   global $db;
 
   $db->query("SELECT * FROM " . $this->table_name . " WHERE " . $this->id_field . " = '$id'");
   if(mysql_num_rows($db->result) == 0)
    return false;
   else
   {
    $this->id = $id;
    $row = mysql_fetch_array($db->result,MYSQL_ASSOC);
    foreach($row as $key => $val)
     $this->fields[$key] = $val;
   }
  }
 
  function insert()
  {
   global $db;
 
   unset($this->fields[$this->id_field]);
   $fields = join(",",array_keys($this->fields));
   $values = "'" . join("','",$this->fields) . "'";
 
   $db->query("INSERT INTO " . $this->table_name . " ($fields) VALUES ($values)");
 
   $this->id = mysql_insert_id($db->db);
   return $this->id;
  }
 
  function update()
  {
   global $db;
 
   unset($this->fields[$this->id_field]);
   $arrStuff = array();
   foreach($this->fields as $key => $val)
    $arrStuff[] = "$key = '$val'";
   $stuff = implode(",$arrStuff);
 
   $db->query("UPDATE " . $this->table_name . " SET $stuff WHERE " . $this->id_field . " = '" . $this->id . "'");
   return mysql_affected_rows($db->db); // Not always correct due to mysql update bug/feature
  }
 
  function delete()
  {
   global $db;
   $db->query("DELETE FROM " . $this->table_name . " WHERE " . $this->id_field . " = '" . $this->id . "'");
   return mysql_affected_rows($db->db);
  }
 
  function empty_table()
  {
   global $db;
   $db->query("DELETE FROM " . $this->table_name);
  }
 }
 
// 
//  class Person extends DBObject 
//  {
//   function __construct()
//   {
//    parent::__construct('person','person_id',array('name','eye_color','hair_color'));
//   }
//  }
//


/***   来自脚本之家 jb51.cc（jb51.cc）   ***/

（编辑：安卓应用网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!