mysqli连接数据类实例

来源：互联网发布：淘宝小女孩子长裙礼服编辑：程序博客网时间：2024/05/24 06:31
<?phpclass MysqliDb{private $link;private $host='127.0.0.1';//数据库地址private $user='root';//数据库用户名private $pwd = 'root';//数据库密码private $db_name='message';//构造函数public function __construct(){$this->link = new mysqli($this->host,$this->user,$this->pwd,$this->db_name);if($this->link->connect_errno) die("数据库连接失败".$this->link->connect_error);$this->link->query("set names gbk");}//执行select语句public function mysqliQuery($table,$field="*",$where=""){if(is_array($where)){$where_key = array_keys($where);$where_val = array_values($where);$str_where_key = implode($where_key,',');$str_where_val="'".implode($where_val,',')."'";}if($where==""){$sql = "select ".$field." from ".$table;}else{$sql = "select ".$field." from ".$table." where ".$str_where_key."=".$str_where_val;}$res = $this->link->query($sql);return $res;}//执行insert update delete语句public function mysqli_dml($table,$data="",$type="insert",$where=""){if(is_array($data)){$key = array_keys($data);$val=array_values($data);$str_key = implode($key,',');    $str_val = "'".implode($val,"','")."'";}if(is_array($where)){$where_key = array_keys($where); //获得数组的键$where_val = array_values($where); //获得数组的值$str_where_key = implode($where_key,','); //把数组变为字符串$str_where_val = "'".implode($where_val,',')."'";}if($where==""){$sql = "insert into ".$table."(".$str_key.") values(".$str_val.")";}else{if($type=="update"){$str = "";for($i=0;$ilink->query($sql);if(!$res){return 0;}else{if($this->link->affected_rows > 0){return 1;}else{return 2;}}}}}}
0 0