| PHP database Operation class, to realize the table additions and deletions, to get the number of rows, query multiple data records, left connection query, create data table structure. Feature-rich, convenient to move the value, the need for friends, you can refer to the next. PHP Database class complete code with example below. 1. Code
Links = mysql_connect (Db_host, Db_user, db_pwd); if (DEBUG) {mysql_select_db (db_name) or Die (' ERROR: '. mysql_error ());} else{mysql_select_db (db_name);} $char _sql = "SET NAMES". CHARSET. "'"; $this->query ($char _sql);} /*** ****************** Operation *******************//*** Additions and deletions change operation method * Input SQL statement * Returns a Boolean or result set $row*/function query ($sql) {if (DEBUG) { $render = mysql_query ($sql) or Die (' Query ERROR: '. Mysql_error (). "
SQL statement error: ". $sql); return $render;} Else{return mysql_query ($sql);}} /*** calculated row Count method * Input * result array */function count ($table, $condition = ' 1 ') {$sql = "SELECT count (*) from '". Db_prefix. $table. " ' Where $condition '; $result = $this->select ($sql); return $result [0][' Count (*) '];} /*** Original SQL Statement Check operation method * Input SQL statement * result array */function Select ($sql) {$row = $this->query ($sql); $results = Array (); while ($arr = $t His->fetch ($row)) {$results [] = $arr;} $this->free_result ($row); return $results;} /*** Check if a field has a value * @param enter the table name. field, value * @return ID or false**/function check_exists ($table, $val) {$render = false; $tab = Explod E ('. ', $table), if ($tab [' 1 '] && $tab [' 1 ']!= ' id ') {$fields = $tab [' 1 ']; $table = "{$tab [0]}.id,{$fields}";} else{$fields = ' id '; $table = $tab [0]. ". ID ";} $condition = "' $fields ' = ' {$val} '"; $detail = $this->read ($table, $condition), if ($detail [$fields]) {$render = $detail [' ID '];} return $render;} /*** querying multiple Data methods * Enter table name. field, field, query condition, number of bars * If the condition is an array, enter advanced search mode * return result array */function readall ($table, $condition = ' 1 ', $limit = '){$tab = explode ('. ', $table); $table = $tab [' 0 '];if ($tab [' 1 ']) {$fields = $tab [' 1 ']; $fields _array =explode (', ', $fields); $fields = '; foreach ($fields _array as $one) {$fields. = "' $one ',";} $fields = RTrim ($fields, ', ');} else{$fields = ' * ';} if (Is_array ($condition)) {$condition = $this->parse_condition ($condition);} $sql = "Select $fields from". Db_prefix. $table. " ' Where $condition ', if ($limit) $sql. = "Limit $limit"; return $this->select ($sql);} /*** querying a single data method * Enter the table name. field, field, query condition * Returns an array of results */function read ($table, $condition = ' 1 ') {$render = $this->readall ($table, $ condition,1); return $render [0];} /*** Modify Data method * Enter table name, insert data array (' field ' = = ' value '), Condition * Return boolean value */function update ($table, $data, $condition) {$set = "; foreach ($ Data as $key = = $val) {$set. = "' $key ' = '". $val. "',";} $set = RTrim ($set, ', '), if (Is_array ($condition)) {$condition = $this->parse_condition ($condition);} $sql = "Update". Db_prefix. $table. " ' Set $set where $condition '; return $this->query ($sql);} /*** Insert Data method * Enter table name, data array (' field ' = = ' value ') * returnBack to Boolean */function insert ($table, $data) {$fields = array (); $values = Array (); foreach ($data as $key + = $val) {if (Is_array ($ val) {$_values = array (); $_fields = Array (); foreach ($val as $k = = $v) {$_fields[]= "' $k '"; $_values[]= "' {$v} '";} $fields = $_fields; $values [] = ' ('. Implode (', ', $_values) ') ';} else{$fields [] = "' $key '"; $values [] = "' {$val} ';}} $fields = Implode (', ', $fields), $values = Implode (', ', $values); $sql = "INSERT INTO". Db_prefix. $table. " ' ($fields) VALUES ($values) "; return $this->query ($sql);} /*** Delete Data method * Enter table name, condition * Returns bool*/function Delete ($table, $condition) {if (empty ($condition)) {die (' condition cannot be null ');} if (Is_array ($condition)) {$condition = $this->parse_condition ($condition);} $sql = "Delete from". Db_prefix. $table. " ' Where $condition '; return $this->query ($sql);} /*** function for parsing conditions * @param condition Array * $arr [] = "' id ' ==0"; $arr [] = "' id ' ==5"; $arr [' id '] = "5"; $arr [' or '] [] = "' id '!=2"; $arr [' or '] [] = "' id '!=1"; $arr [' or ' [] = "' id '!=2"; $arr [' Groups '][]= ' id '; $arr [' Orders '] [' ID ']= ' ASC '; $arr [' Orders '] [' TD ']= ' DESC '; *
$sql determine
";} ElseIf ($_get[sure] && $this->query ($sql)) {echo "Done";} Else{echo "Operation failed:
>$sql
";} Exit;}};? >Invocation Example:
CreateTable (' article ', $data, ' Article table ');//additions and Deletions $data[' title ']= ' t '; $data [' keyword ']= ' k '; $Db->insert (' article ', $ Data), $num = $Db->read (' article.id ', ' 1 ORDER by id DESC '), $data [' created '] = mktime () + $num [' id ']; $Db->update (' Article ', $data, ' ' id ' =2 '); $Db->delete (' article ', "' id ' = 3"); >
|
