Db=new mysqli ($host, $user, $pwd, $name); Database connection if (Mysqli_connect_errno ()) {echo "Database connection Error". Mysqli_connect_errno (); Exit (); } $this->db->query ("Set names UTF8"); $this->table= $table _names; $this->opt[' field ']= "*"; $this->opt[' where ']= $this->opt[' Order ']= $this->opt[' Limit ']= $this->opt[' Group ']= ';//Var_dump ($ this->opt[' where '); $this->m ($table _names); }//Database connection//protected function M ($table _name) {//$this->db=new mysqli (dbhost,dbuser,dbpwd,dbname);//// if (Mysqli_connect_errno ()) {//echo "Database connection Error". Mysqli_connect_errno ();//exit ();//}// $this->db->query ("Set names UTF8");//$this->table= $table _name;//}//field in table Public function t Bfield () {$desc = $this->db->query ("desc {$this->table}"); $FIELDARR =array (); while (($row = $desc->fetch_assoc ())!=false) {$fieldarr[]= $row [' Field ']; }//Var_dump ($FIELDARR); return $FIELDARR; }//Query field Public function field ($filed) {//Split field $FILEDARR =is_string ($filed)? Explode (",", $filed): $filed; if (Is_array ($FILEDARR)) {$filed = '; foreach ($filedArr as $v) {$filed. = "'". $v. "'". ","; }}//var_dump ($filed); return RTrim ($filed, ","); }//Determine if the field exists public function Isfield ($fileds) {$filedArr =is_string ($fileds)? Explode (",", $fileds): $fileds; $tbFiled = $this->tbfield (); Var_dump ($tbFiled); foreach ($filedArr as $v) {if (!in_array ($v, $tbFiled)) {echo "field input Error"; }}}//Conditional statement public function where ($where) {$this->opt[' where ']=is_string ($where)? " WHERE {$where} ":" Is not a string "; return $this; }//limit Public Function Limit ($limit) {$this->opt[' limit ']=is_string ($limit)? " Limit {$lImit} ":" Is not a string "; return $this; The Public Function Order ($order) {$this->opt[' order ']=is_string ($order)? " Order by {$order} ":" Is not a string "; return $this; } Public Function Group ($group) {$this->opt[' group ']=is_string ($group)? " Group by {$group} ":" Is not a string "; return $this; }//Query string public function Select () {$sql = "select * from {$this->table} {$this->opt[' where ']} {$this-&G t;opt[' Group '} {$this->opt[' Limit '} {$this->opt[' Order '} "; return $this->fetch ($sql); }//Result set query public function fetch ($sql) {$result = $this->db->query ($sql); $sqlarr =array (); while (($row = $result->fetch_assoc ())!=false) {$sqlarr []= $row; }//Var_dump ($sqlarr); return $sqlarr; }//No result set query public function Querys ($sql) {$sqls = $this->db->query ($sql); return $this->db->affected_rows; }//DELETE statement public function Delete ($where =array ()) { if ($where = = "" && empety ($this->opt[' where ')) die ("Cannot be empty"); if ($where! = "") {if (Is_array ($where)) {$where =implode (",", $where); } $this->opt[' where ']= "where ID in ({$where})"; } $sql = "Delete from {$this->table} {$this->opt[' where '} {$this->opt[' Limit '}"; Var_dump ($sql); return $this->query ($sql); }//array key name Public function key ($key) {if (!is_array ($key)) die ("illegal array"); $keys = ""; foreach ($key as $v) {$keys. = $v. ","; } return RTrim ($keys, ","); }//Array value Public function value ($value) {if (!is_array ($value)) die ("illegal array"); $strvalue = ""; foreach ($value as $v) {$strvalue. = "'". $v. "'". ","; } return RTrim ($strvalue, ","); }//Add statement Public Function Add ($filed) {if (!is_array ($filed)) die ("illegal array"); $fileds = $this->key (Array_keys ($filed)); Returns the key names in the array//var_dUMP ($FILEDS); $values = $this->value (array_values ($filed)); $sql = "INSERT INTO {$this->table} ({$fileds}) VALUES ($values)"; Var_dump ($sql); return $this->querys ($sql); }//Find a single record public function find ($field, $id) {$sql = "Select {$this->opt[' field ']} from {$this->table} {$t His->where ($field. ' ='."'". $id. "')}"; Var_dump ($sql); return $this->fetch ($sql); }//UPDATE statement public Function Save ($ARRS) {if (!is_array ($arrs)) die ("illegal array"); if (Empty ($this->opt[' where ')) die ("condition cannot be null"); $str = ""; while (list ($k, $v) =each ($arrs)) {$str = "{$k}=". " {$v} ', '; } $str =rtrim ($str, ","); $sql = "Update {$this->table} set {$str} {$this->opt[' where '}"; return $this->querys ($sql); }//Gets the total number of records public function counts () {$sql = "select ' id ' from {$this->table}{$this->opt[' where '}"; Var_dump ($sql); return $this->querys ($sQL); }} $db =new mysqls (' 127.0.0.1 ', ' root ', ' ', ' MySQL ', ' user ');
Part of the writing has a problem referencing a part of others
The above describes the Apache php mysql PHP value MySQL operation class, including the Apache PHP MySQL content, want to be interested in PHP tutorial friends helpful.