马上给你 <?php /*===============================================================*/ /*文件名:Model.class.php */ /*概要: 模块处理类,公用的数据库的操作*/ /*作者:袁再新 */ /*作品声明:本人属于初学者,限于技术水平勿将此例作为商用*/ /*制作时间:2012-3-30 */ /*===============================================================*/ // class Model{ protected $pdo; protected $tabName; protected $messList; protected $fieldList; function __construct(){ try{ $this->pdo=new PDO('mysql:dbname='.DB_NAME.';host='.DB_HOST,DB_USER,DB_PSWD,array(PDO::ATTR_ERRMODE=>PDO::ERRMODE_EXCEPTION)); $this->pdo->exec('set names gbk');//解决字符编码问题 }catch(PDOException $e){ echo '数据库连接失败:'.$e->getMessage(); exit; } }function add($postList){ $fieldList=''; $value=''; foreach($postList as $key=>$val){ if(in_array($key,$this->fieldList)){ $fieldList.=$key.','; if($key=='userPwd'){ $val=md5($val); } if(!get_magic_quotes_gpc()){ $value.="'".addslashes($val)."'".','; }else{ $value.="'".$val."',"; } } } $fieldList=rtrim($fieldList,','); $value=rtrim($value,','); try{ $sql='INSERT INTO '.$this->tabName.'('.$fieldList.')'.' values('.$value.')'; $affected=$this->pdo->exec($sql); }catch(PDOException $e){ echo '数据录入失败:'.$e->getMessage(); echo $sql; exit(); } return $affected; }function mod($postList){ $id=''; $value=''; $id=$postList['id']; unset($postList['id']); foreach($postList as $key=>$val){ if(in_array($key,$this->fieldList)){ if(!get_magic_quotes_gpc()){ if($key=='userPwd'){ $val=md5(addslashes($val)); }else{ $val=addslashes($val); } $value.=$key."='".$val."',"; }else{ $value.=$key."='".$val."',"; } } } $value=rtrim($value,','); try{ $sql='UPDATE '.$this->tabName.' SET '.$value.' WHERE id='.$id; $affected=$this->pdo->exec($sql); }catch(PDOException $e){ echo '更新失败;'.$e->getMessage(); exit; } return $affected; } function del($id){ if(is_array($id)){ $tmp='IN ('.join(',',$id).')'; }else{ $tmp="$id"; } try{ $affected=$this->pdo->exec('DELETE FROM '.$this->tabName.' WHERE id='.$tmp); }catch(PDOException $e){ echo '数据删除失败:'.$e->getMessage(); exit(); } return $affected; }function find($id){ $fields=join(',',$this->fieldList); $sql='SELECT '.$fields.' FROM '.$this->tabName.' WHERE id='.$id; $stmt=$this->pdo->query($sql); if($stmt&&$stmt->rowCount()>0){ return $stmt->fetch(PDO::FETCH_ASSOC); }else{ //echo $stmt;作为调试用 return false; } } function total($where=''){ $sql='SELECT * FROM '.$this->tabName.' '.$where; $stmt=$this->pdo->query($sql); return $stmt->rowCount(); } function findAll($where='',$field=array(),$offset=0,$number=0,$isall=false,$order='id desc'){ if(empty($field)){ $field=join(',',$this->fieldList); }else{ $field=join(',',$field); } if($number==0){ $sql='SELECT '.$field.' FROM '.$this->tabName." ".$where.' ORDER BY '.$order; }else{ $sql='SELECT '.$field.' FROM '.$this->tabName." ".$where.' ORDER BY '.$order.' LIMIT '.$offset.','.$number; } $stmt=$this->pdo->query($sql); if($stmt&&$stmt->rowCount()>0&&$isall===false){ return $stmt->fetch(PDO::FETCH_ASSOC); }elseif($stmt&&$stmt->rowCount()>0&&$isall===true){ return $stmt->fetchAll(PDO::FETCH_ASSOC); }else{ return false; } } function getMessList(){ $message=''; if(!empty($this->messList)){ foreach($this->messList as $value){ $message.=$value.'<br>'; } } return $message; }}
这是一个类吧?其实我想要能实现的具体代码,