<?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');