mysqli=new mysqli($this->host,$this->user,$this->pwd,$this->db,$this->port); if(mysqli_connect_errno()){ $this->mysqli=false; echo mysqli_connect_error(); die(); }else{ $this->mysqli->set_charset($char); } } //析构函数：释放结果集和关闭数据库 public function __destruct(){ $this->free(); $this->close(); } //初始化$mysqli对象 public static function getinstance(){ if(!(self::$_instance instanceof self)) { self::$_instance = new self(); } return self::$_instance; } //释放结果集 private function free(){ @$this->result->free(); } //关闭数据库连接 private function close(){ $this->mysqli->close(); } //执行sql语句 public function query($sql){ return $this->mysqli->query($sql); } //获取查询结果 public function get_result_array($table,$field,$c $table=$this->prefix.$table; if(is_array($field)){ $field = join(',',$field); } $sql = select $field from .$table; if(!empty($condition))$sql .= $condition ; $this->result = $this->query($sql); $return = array(); while($row = $this->fetch($this->result)){ $return[] = $row; } $this->free(); return $return; } //增删改操作 public function execute($table,$action,$arr_field=array(),$c $table=$this->prefix.$table; switch($action){ case 'insert': $str_field = ''; $str_val = ''; foreach($arr_field as $key=>$val){ $str_field .= '`'.$key.'`,'; $str_val .= '\''.$val.'\','; } $str_field = rtrim($str_field, ','); $str_val = rtrim($str_val, ','); $sql = insert into $table ($str_field) values ($str_val) ; break; case 'delete': $sql = delete from $table; if (!empty($condition)) $sql .= where $condition; break; case 'update': $str_field = ''; foreach($arr_field as $key => $val){ $str_field.= '`'.$key .` ='$val',; } $str_field = rtrim($str_field, ','); $sql = update $table set $str_field; if (!empty($condition)) $sql .= where $condition; break; } $this->query($sql); return $this->get_affected_rows(); } //获得受影响行数(针对增删改操作) public function get_affected_rows(){ return $this->mysqli->affected_rows; } //获取集合条数 public function get_rows($table,$c 1 ',$id='id'){ $table=$this->prefix.$table; $sql=select count($id) num from .$table. $condition; $this->result=$this->query($sql); $row=$this->fetch($this->result); return $row['num']; } //获得结果集 public function fetch($result){ return $result->fetch_array($this->fetch_mode); } //获得所有结果集 public function fetch_all($result){ $rows=array(); while($row=$this->fetch($result)){ $rows[]=$row; } return $rows; }}
想用php写手机app的接口封装的一个数据库操作类 以上就介绍了php mysqli数据库操作类，包括了对象方面的内容，希望对php教程有兴趣的朋友有所帮助。