增刪改查類

<?php
// 所有數據表的基類
abstract class Model {protected $tableName = "";protected $pdo = "";protected $sql="";function __construct() {$pdo = new PDO( "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, DB_USERNAME, DB_PASSWORD );$pdo->exec ( "set names " . DB_CHARSET );$this->pdo = $pdo;}function updatetone($where=''){$sql = 'UPDATE ' . $this->tableName . ' SET clicknum=clicknum+1'. ($where == NULL ? $where : ' WHERE ' . $where);$this->sql=$sql;return $this->pdo->exec ( $sql );}/*** 獲取總記錄數 select count(*) as num from news where cateid=5*/function count($where=""){$where = empty($where) ? "" : " where ".$where;$sql="select count(*) as num from {$this->tableName} $where";$this->sql=$sql;$pdoS=$this->pdo->query($sql);$arr=$pdoS->fetch(PDO::FETCH_ASSOC);return $arr['num'];}/*** 增加* array $arr=array('字段名'=>值,....) exp:array('username'=>'xiaowang','password'=>'123456')*/function insert($arr) {// 把數組轉化成sql語句// sql語句是php向mysql，告訴她給我寫一條記錄進表// insert into 表名(字段列表) value(數據列表)// insert into adminuser(username,password) value('xiaowang','123456')$fiedList = "";$valueList = "";foreach ( $arr as $k => $v ) {$fiedList .= "," . $k;$valueList .= ",'" . $v . "'";}$fiedList = substr ( $fiedList, 1 );$valueList = substr ( $valueList, 1 );// 拼sql$sql = "insert into {$this->tableName}({$fiedList}) value({$valueList})";$this->sql=$sql;// 執行$re = $this->pdo->exec ( $sql );if ($re) {// 返回主鍵idreturn $this->pdo->lastInsertId ();} else {return false;}}// 查詢function findByPk($id) {// 獲取表的主鍵名稱 desc 表名$pdoS = $this->pdo->query ( "desc " . $this->tableName );$arr = $pdoS->fetchAll ( PDO::FETCH_ASSOC );foreach ( $arr as $v ) {if ($v ['Key'] == 'PRI') {$fieldName = $v ['Field'];break;}}$sql = "select * from {$this->tableName} where $fieldName=$id";$this->sql=$sql;$pdoS = $this->pdo->query ( $sql );return $pdoS->fetch ( PDO::FETCH_ASSOC );}/*** 查詢多條記錄* array $arr 用來管理查詢語句的子句* array('limit'=>'0,5','where'=>"id=5")*/function findAll($arr = array()) {// select 字段列表 from 表名// where 條件 group by 字段 having 條件 order by 字段 desc|asc limit start,length// select 字段列表 from 表1 as t1 join 表2 as t2 on t1.字段=t2.字段 join 表3 as t3 on t2.字段=t3.字段// 拼sql語句$field = isset ( $arr ['field'] ) ? $arr ['field'] : "*";$where = isset ( $arr ['where'] ) ? " where " . $arr ['where'] : '';$group = isset ( $arr ['group'] ) ? " group by " . $arr ['group'] : '';$having = isset ( $arr ['having'] ) ? " having " . $arr ['having'] : "";$order = isset ( $arr ['order'] ) ? " order by " . $arr ['order'] : '';$limit = isset ( $arr ['limit'] ) ? " limit " . $arr ['limit'] : '';$alias = isset ( $arr ['alias'] ) ? " as " . $arr ['alias'] : "";$join = isset ( $arr ['join'] ) ? " join " . $arr ['join'] : '';$sql = "select $field from {$this->tableName} $alias $join $where $group $having $order $limit";$this->sql=$sql;$pdoS = $this->pdo->query ( $sql );if (is_object ( $pdoS )) {return $pdoS->fetchAll ( PDO::FETCH_ASSOC );} else {return array ();}}function delete($where = NULL) {$sql = 'DELETE FROM ' . $this->tableName . ($where == NULL ? $where : ' WHERE ' . $where);$this->sql=$sql;return $this->pdo->exec ( $sql );}function update($bind, $where = NULL) {$set = NULL;foreach ( $bind as $field => $value ) {if (is_null ( $set )) {$set .= $field . "='" . $value . "'";} else {$set .= ',' . $field . "='" . $value . "'";}}$sql = 'UPDATE ' . $this->tableName . ' SET ' . $set . ($where == NULL ? $where : ' WHERE ' . $where);$this->sql=$sql;return $this->pdo->exec ( $sql );}function query($sql){//判斷是更新語句，還是查詢語句if(preg_match("/^select/i",$sql)){$pdoS=$this->pdo->query($sql);return $pdoS->fetchAll(PDO::FETCH_ASSOC);}else{return $this->pdo->exec($sql);}}function getLastSql(){return $this->sql;}
}