MySQLi常用性數(shù)據(jù)操作
一般性操作public function getRow($sql, $fetch_type = MYSQLI_ASSOC) 獲取1條數(shù)據(jù), 為關(guān)聯(lián)一維數(shù)組public function getAll($sql, $fetch_type = MYSQLI_ASSOC) 獲取全部數(shù)據(jù)集, 按關(guān)聯(lián)二維組數(shù)返回public function getLastInsID() 獲取數(shù)據(jù)庫最后一個插入IDpublic function insert($table, $array) 數(shù)據(jù)的添加public function delete($table, $where) 數(shù)據(jù)的刪除public function update($table, $array, $where) 數(shù)據(jù)的更新通用性數(shù)據(jù)操作public function execute($sql) 執(zhí)行:insert, update , deletepublic function query($sql) 執(zhí)行:select事務(wù)處理public function beginTransaction() 開啟一個事務(wù)public function rollBack() 回滾一個事務(wù)public function commit() 提交一個事務(wù)預(yù)編譯public function fetch($sql, $param) 最后1條數(shù)據(jù), 為一維數(shù)組public function fetchAll($sql, $param) 獲取全部數(shù)據(jù)集, 按關(guān)聯(lián)二維組數(shù)返回public function exec($sql, $param) 執(zhí)行insert, update, delete 預(yù)編譯語句PDO 常用性數(shù)據(jù)操作
一般性操作public function getRow($sql, $fetch_type = PDO::FETCH_ASSOC)public function getAll($sql, $fetch_type = PDO::FETCH_ASSOC)public function getLastInsID() 獲取數(shù)據(jù)庫最后一個插入IDpublic function insert($table, $array)public function delete($table, $where)public function update($table, $array, $where)事務(wù)處理public function beginTransaction()public function rollBack()public function commit()預(yù)編譯public function fetch($sql, $param) 最后1條數(shù)據(jù), 為一維數(shù)組public function fetchAll($sql, $param) 獲取全部數(shù)據(jù)集, 按關(guān)聯(lián)二維組數(shù)返回public function exec($sql, $param) 執(zhí)行:insert, update , delete新聞熱點
疑難解答
圖片精選