php實(shí)現(xiàn)Mysql簡(jiǎn)易操作類

2020-03-22 18:03:31

字體：大中小

供稿：網(wǎng)友

自己封裝的Mysql簡(jiǎn)易操作類，已塞在Ben框架中，基于PDO來(lái)寫的，代碼風(fēng)格上有些無(wú)厘頭。。。mysql.html' target='_blank'>class.phpclass mysql extends PDO{ public $server; public $database; public $user; public $password; public $sql; public function __construct($server,$database,$user,$password,$port=3306){ $this- server = $server; $this- database = $database; $this- user = $user; $this- password = $password; parent::__construct("mysql:host=$server;port=$port;dbname=$database",$user,$password); $this- query('SET NAMES utf8'); public function drop($table){ $sql = 'DROP TABLE '.$table.';'; $re = $this- query($sql); if($re){ return true; }else{ return false; public function insert($table,$name,$value=null){ $sql = "INSERT INTO ".$table.'('; if($value == null){ $arrname = array_keys($name); $arrvalue = array_values($name); }else{ $arrname = explode('|', $name); $arrvalue = explode('|', $value); for($i=0;$i count($arrname);$i++){ if($i==count($arrname)-1){ $sql = $sql.$arrname[$i]; }else{ $sql = $sql.$arrname[$i].","; $sql = $sql.")VALUES("; for($i=0;$i count($arrvalue);$i++){ if($i==count($arrvalue)-1){ $sql = $sql."'".$arrvalue[$i]."'"; }else{ $sql = $sql."'".$arrvalue[$i]."',"; $sql .=");"; $re = $this- query($sql); if($re){ return true; }else{ return false; public function delete($table,$Conditionsname,$Conditionsvalue=null){ if($Conditionsvalue!=null){ $sql = "DELETE FROM ".$table." WHERE ".$Conditionsname."='".$Conditionsvalue."';"; }else{ $sql = "DELETE FROM ".$table." WHERE "; $arrname = array_keys($Conditionsname); $arrvalue = array_values($Conditionsname); for($i=0;$i count($arrname);$i++){ if($i==count($arrname)-1){ $sql.=$arrname[$i].'='."'".$arrvalue[$i]."'"; }else{ $sql.=$arrname[$i].'='."'".$arrvalue[$i]."',"; $sql.=';'; $re = $this- query($sql); if($re){ return true; }else{ return false; public function select($table,$name,$Conditionsname,$Conditionsvalue=null){ if($Conditionsvalue!=null){ $sql = "SELECT ".$name." FROM ".$table." WHERE ".$Conditionsname."='".$Conditionsvalue."';"; }else{ $sql = "SELECT ".$name." FROM ".$table." WHERE "; $arrname = array_keys($Conditionsname); $arrvalue = array_values($Conditionsname); for($i=0;$i count($arrname);$i++){ if($i==count($arrname)-1){ $sql.=$arrname[$i].'='."'".$arrvalue[$i]."'"; }else{ $sql.=$arrname[$i].'='."'".$arrvalue[$i]."' and "; $sql.=';'; $re = $this- query($sql); $row = $re- fetch(); return $row[$name]; public function update($table,$name,$value,$Conditionsname,$Conditionsvalue=null){ if($Conditionsvalue!=null){ $sql = "UPDATE ".$table." SET ".$name."= '".$value."' WHERE ".$Conditionsname."='".$Conditionsvalue."';"; }else{ $sql = "UPDATE ".$table." SET ".$name."= '".$value."' WHERE "; $arrname = array_keys($Conditionsname); $arrvalue = array_values($Conditionsname); for($i=0;$i count($arrname);$i++){ if($i==count($arrname)-1){ $sql.=$arrname[$i].'='."'".$arrvalue[$i]."'"; }else{ $sql.=$arrname[$i].'='."'".$arrvalue[$i]."' and "; $sql.=';'; $re = $this- query($sql); if($re){ return true; }else{ return false; public function group($table,$name){ $sql = "SELECT ".$name." FROM ".$table.";"; $return = array(); $re = $this- query($sql); while($row = $re- fetch(PDO::FETCH_ASSOC)){ array_push($return,$row[$name]); return $return; public function fetchall($sql){ $return = array(); $re = $this- query($sql); while($row = $re- fetch(PDO::FETCH_ASSOC)){ array_push($return,$row); return $return;PHP教程

鄭重聲明：本文版權(quán)歸原作者所有，轉(zhuǎn)載文章僅為傳播更多信息之目的，如作者信息標(biāo)記有誤，請(qǐng)第一時(shí)間聯(lián)系我們修改或刪除，多謝。

上一篇：前端網(wǎng)頁(yè)php與mysql數(shù)據(jù)庫(kù)字符編碼(解決中文等亂碼問(wèn)題）

下一篇：PHP基礎(chǔ)之函數(shù)（三）Mysql字段操作數(shù)組對(duì)象類函數(shù)