自己写的yaf的mysql pdo扩展

来源：互联网发布：非农历史数据统计分析编辑：程序博客网时间：2024/05/23 22:59
yaf没有自己的数据库扩展，正好闲着没事就花了一上午写了一个pdo的数据库扩展，支持php连贯操作，支持数组插入，更新等，因为时间有限，写的并不是很完善，还有很多要去补充，比如执行错误提示等等，先粘贴出来，希望大家可以提出意见和建议。
<?php/** * Created by PhpStorm. * User: Administrator：HenryZhang * Date: 2016/3/31 * Time: 8:23 */interface  delete1{    function delete();    function  deletebyId($id);}interface  update1{    function  update_array(array $arr);//    function    function update($data,$where);}interface  insert1{    function insert(array $arr);}interface  select2{    function  get_all();//获取数据库全部信息    function  get_one($where);//获取一条信息    function  get_field();//获取一个字段的信息    function  select();//选择    function  findbyId($id);//根据id条件查询}class db123{    function __construct()    {        $connect= new PDO("mysql:host=localhost;dbname=yaf","root","");        return $connect;    }    function  exec_sql($sql){        $conn= $this->__construct();        return  $arr=$conn->query($sql);    }    function  query_sql($sql){        $conn= $this->__construct();        return  $arr=$conn->query($sql);        $result=array();        foreach($arr as $v){            $result[]=$v;        }//        return $conn->getError();        return $result;    }}class pdotest1 extends db123 implements  select2,insert1,update1,delete1{    private $password='';    private $tablename="";    private $where="";    private $limit="";    private $field="";    private $order="";    private $connect;    function __construct()    {     return   parent::__construct();    }    function  where($where)    {  $this->where="where  ".$where;        // TODO: Implement where() method.        return $this;    }    function  tablename($tabname)    {        $this->tablename=" ".$tabname;        // TODO: Implement db() method.        return $this;    }    function  limit($limit,$end=" ")    {        // TODO: Implement limit() method.        if($end==" "){        $this->limit=" limit 0,".$limit;        }        else{            $this->limit=" limit $limit,$end";        }        return $this;    }    function  field($filed)   {       $this->field=$filed;       return $this;       // TODO: Implement field() method.   }    function  order($field, $oder)  {  $this->order="order by $field  $oder";      // TODO: Implement order() method.      return $this;  }    function  select()  {//      $this->db1("user");      // TODO: Implement sele() method.      $conn= $this->__construct();     $tabelname=($this->tablename);      $where=$this->where;        $limit=$this->limit;        $field=$this->field;        $order=$this->order;        if($field==""){            $sql="select * from $tabelname $where $order $limit";        }        else{         $sql="select $field $tabelname $where $order  $limit";        }     return  parent::query_sql($sql);  }    function  get_all()    {//        // TODO: Implement get_all() method.        $tbname=$this->tablename;       $sql="select *  from $tbname";        echo $sql;        $conn= $this->__construct();        $arr=$conn->query($sql);        $result=array();        foreach($arr as $v){            $result[]=$v;            var_dump( $v);        }        return $result ;    }    function  get_field()   {       // TODO: Implement get_field() method.       $field=$this->field;       $taname=$this->tablename;       $sql="select  $field  from  $taname";       echo $sql;     return  parent::query_sql($sql);   }    function  get_one($where) {     // TODO: Implement get_one() method.     $tbname=$this->tablename;     $sql="select * from $tbname where  $where";     echo $sql;  return  parent::query_sql($sql); }    function  findbyId($id)    {        // TODO: Implement findbyId() method.        $tabelname=$this->tablename;        $sql="select * from   $tabelname where id=$id";        return parent::query_sql($sql);    }    function insert(array $arr)    {        $len=count($arr);        $value1=array();        foreach($arr as $k=>$v){            $value1[]=$k;            $value2[]=$v;        }        $filed="";        $filed1="";        for ($i=$len-1;$i>=0;$i--){       $filed=$value1[$i].','.$filed;        }        for ($i=$len-1;$i>=0;$i--){            $filed1="'".$value2[$i]."'".','.$filed1;        }//        echo $filed1;        $value3=substr($filed,0,(strlen($filed)-1));        $value4= substr($filed1,0,(strlen($filed1)-1));//        echo $value4;        var_dump($value1);        var_dump($value2);        $tabname=$this->tablename;        $sql="insert into $tabname ($value3) values($value4)";        if(!parent::exec_sql($sql)){            echo "insert error";        }        else{            echo "ok";        }    }    function update_array(array $arr){        $len=count($arr);    }    function update($data,$where){        $tbname=$this->tablename;        $sql="update $tbname set $data where $where";       if(!parent::exec_sql($sql)){           echo  "updaa error";       }        else{            echo  "ok";        };    }    function deletebyId($id){        $tbname=$this->tablename;        $sql="delete from $tbname where id=$id";        if(!parent::exec_sql($sql)){            echo  " deletebyId error";        }else{            echo "deletebyId ok";        }    }    function  delete()    {        $tbname=$this->tablename;    echo $tbname;        $where=$this->where;        $sql="delete from $tbname $where";        echo $sql;        if(!parent::exec_sql($sql)){            echo "delect error";        }else{            echo "delete ok";        }    }}
0 0