php mysql 单例模式_PHP单例模式_PHP单例模式数据库连接类

添加查询数据库的方法，方法后注释有参数填写的例子与格式

public function select($table,$condition=array(),$field = array(),$limit='',$order=''){ //(表名，条件，查询的字段)  select('tb_table',array('id'=>'93','name'=>'user'),array('id','aa'))

$where='';

if(!empty($condition)){

foreach($condition as $k=>$v){

$where.=$k."='".$v."' and ";

}

$where='where '.$where .'1=1';

}

$fieldstr = '';

if(!empty($field)){

foreach($field as $k=>$v){

$fieldstr.= $v.',';

}

$fieldstr = rtrim($fieldstr,',');

}else{

$fieldstr = '*';

}

self::$sql = "select {$fieldstr} from {$table} {$where} {$order} {$limit}";

$result=mysqli_query($this->conn,self::$sql);

$resuleRow = array();

$i = 0;

while($row=mysqli_fetch_assoc($result)){

foreach($row as $k=>$v){

$resuleRow[$i][$k] = $v;

}

$i++;

}

return $resuleRow;

}