<?php class ConnDB{ private $local; private $username; private $pwd; private $db; private $connID; private $code; public function __construct($local,$username,$pwd,$connID,$code,$db){ $this->local=$local; $this->username=$username; $this->pwd=$pwd; $this->connID=$connID; $this->code=$code; $this->db=$db; $this->connect(); } public function connect(){ if($this->connID=="pconn"){ $this->connID=mysql_pconnect($this->local,$this->username,$this->pwd)or die("Connect MySQL False"); }else{ $this->connID=mysql_connect($this->local,$this->username,$this->pwd)or die("Connect MySQL False"); } mysql_select_db($this->db,$this->connID) or die("Connect DB False"); mysql_query("SET NAMES $this->code"); return $this->connID; } } class AdminDB{ function executeSQL ($sql, $connID){ $sqlType=strtolower(substr(trim($sql), 0, 6));//提取SQL语句的类型 $rs = mysql_query($sql,$connID); if ($sqlType == 'select') { $arrayData = mysql_fetch_array($rs); //返回查询记录集 if (count($arrayData)==0 || $rs==false){//如果没查询到或发生错误 return false; }else{ return $arrayData; } }elseif ($sqlType == 'insert' || $sqlType == 'update' || $sqlType == 'delete') { return $rs;//返回语句执行状态,即成功返回true,失败返回false }else { return false; } } } ?>
使用示例:
$connobj = new ConnDB("数据库地址:端口","账号","密码","conn","utf8","库名"); //实例化数据库连接类 $conn = $connobj->connect(); //返回连接标识 $admindb = new AdminDB(); //数据库操作类实例化 //调用数据库操作类中方法执行查询语句 $res = $admindb->executeSQL ("SELECT * FROM appzk_system",$conn); if($res){ //如果返回结果为真,则输出数据 var_dump($res); //输出一个数组。 }
转载请注明来源: php封装数据库操作类 - 朱凯博客
支付宝
微信