简单封装数据库类

最新推荐文章于 2024-10-08 11:49:18 发布

RabinRow

最新推荐文章于 2024-10-08 11:49:18 发布

阅读量64

点赞数

文章标签：数据库 php

原文链接：http://www.cnblogs.com/sensai-sun/p/6930569.html

版权

<?php

class Model{

      protected $db; // 连接标志
      protected $tableName;
      protected $where=''; // 存储where条件
      protected $order=''; // 存储排序条件

      public function __construct($dbtable,$host='127.0.0.1',$user='root',$passwd='123',$dbname='php1503'){
           try{
               $this->db = mysql_connect($host,$user,$passwd,$dbname);
           }catch(Exception $e){
               echo $e->getMessage();
               exit;
           }
           mysql_set_charset("utf8");
           $this->tableName = $dbtable;
      }

      // where
      public function where($where=''){

       if(is_array($where)){
           $realwhere=[];
           foreach($where as $key=>$v){
               $realwhere[]="$key='$v'";
           }
           $this->$where = implode(' and ', $realwhere);
       }else{
           $this->where = $where;
       }

       return $this;
      }

      // order by
      public function order($order=''){
          $this->order = $order;
          return $this;
      }

      public function select($field=''){
         // 自动拼接字符串生成sql语句
         $sql = "select ";
         $sql.= $field ? $field : '*';
         $sql.=" from {$this->tableName}";
         $sql.= $this->where ? "where {$this->where}" : "";
         $sql.= $this->order ? "order by {$this->order}" : "";

         $res = mysql_query($sql,$this->db);
         return mysql_fetch_assoc($res);

      }

      public function insert(){

      }

      public function delete(){

      }

}

$db = new Model("student");
$db->where("stuno like '204%'")->order('sid asc')->select('sid,sname');