PHP实体层基础类

PHP实体层基础类

class BaseModel
    {
        private $tableName;
        private $fields=array();
        function __construct()
        {
            $this->tableName=rtrim(get_class($this),'M');
        }
        function __get($n)
        {
            return($this->$n);
        }
        function __set($n, $value)
        {
            $this->$n = $value;
            $this->fields[$n]=$value;
        }

        function Add()
        {
            $f='';
            $f1='';
            $arrKeys=array_keys($this->fields);
            foreach($arrKeys as $row)
            {
                $f.=$row.',';
                $f1.=':'.$row.',';
            }
            $f=rtrim($f,',');
            $f1=rtrim($f1,',');
            $sql='insert into '.$this->tableName.'('.$f.') values('.$f1.')';
            //echo $sql;
            global $dbh;
            return $dbh->edit($sql,$this->fields);
        }

        function Update($sql_where,$params=array())
        {
            $f='';
            $f1='';
            $arrKeys=array_keys($this->fields);        
            foreach($arrKeys as $row)
            {
                $f.=$row.'=:'.$row.',';
            }
            $f=rtrim($f,',');
            $sql='update '.$this->tableName.' set '.$f.' where '.$sql_where;
            
            $arrKeys1=array_keys($params);
            foreach($arrKeys1 as $row)
            {
                $this->fields[$row]=$params[$row];
            }
            
            global $dbh;
            return $dbh->Edit($sql,$this->fields);
        }
        
        function Delete($sql_where,$params=array())
        {
            $sql='delete from '.$this->tableName.' where '.$sql_where;
            //echo $sql;
            
            global $dbh;
            return $dbh->Edit($sql,$params);
        }

    }

实体层：

class proM extends BaseModel
{
    private $proName;
    private $proDetail;
    private $proPic;
    private $proPic1;
    private $proAttr;
    private $proTaxis;
    private $proIsHome;
    private $proIsTJ;
    private $proIsCTJ;
    private $proIsDel;
    private $proAddTime;
    private $proisHot;
    private $proisPorClass;
    private $proisYN;
    private $proGL;
    private $proSeoT;
    private $proSeoK;
    private $proSeoD;
    private $proBH;
    private $FK_proClass;
    private $proModel;
    private $proPrice;
    private $proDiscount;
    private $proHit;
    private $proURL;
    private $proisKdWords;
    private $proisKdDone;
    private $proFL;
}

使用：

$m=new proM();
$m->proName='代码';
$m->proDetail='php开发';
$m->Update('proID=:proID',array(proID=>1));