简述php操作mysql数据库的类

本文实例讲述了php操作mysql数据库的类。分享给大家供大家参考。具体如下：

 ?php * Database html' target='_blank'>class * @version: 2.2 * @revised: 27 may 2007class Database { var $host; var $name; var $user; var $pass; var $prefix; var $linkId; function Database($mysql) { foreach($mysql as $k = $v){ $this- $k = $v; if(strlen($this- prefix) 0 substr($this- prefix, -1) !== _ ) $prefix .= _  $this- prefix = $prefix; function getLastID() { $id = mysql_fetch_row(mysql_query( SELECT LAST_INSERT_ID() , $this- linkId)); return $id[0]; function getPossibleValues($tableA, $whereA) { if(gettype($tableA) == array ) { $table =  foreach($tableA as $t) { $table .= $this- prefix.$t. ,  $table = substr($table, 0, -2); } else $table = $this- prefix.$tableA; if(gettype($whereA) != array ) { $whereA = array($whereA); $return = array(); foreach($whereA as $where) { $sql = mysql_query( SHOW COLUMNS FROM .$table. LIKE % .$where. %  while($arr = mysql_fetch_array($sql)) { if(strpos($arr[ Type ], enum )===0) { $vals = substr($arr[ Type ], 5, -1); } else { $vals = substr($arr[ Type ], 4, -1); $vals = str_replace( , ,$vals); $vals = explode( , ,$vals); $i = 1; foreach($vals as $val) { $return[$arr[ Field ]][$i++] = $val; $return[$arr[ Field ]][ default ] = $arr[ Default  if($arr[ Null ] != NO ) $return[$arr[ Field ]][0] = NULL; return $return; function connect() { $this- linkId = mysql_connect($this- host, $this- user, $this- pass); if(!$this- linkId) { return false; if(mysql_select_db($this- name, $this- linkId)) return true; mysql_close($this- linkId); return false; function runSelect($tables, $where = 1 , $fieldsA = * , $order = false, $limit = false, $offset = false, $group = false) { if(gettype($tables) == array ) { $table =  foreach($tables as $t) { $table .= $this- prefix.$t. ,  $table = substr($table, 0, -2); } else $table = $this- prefix.$tables; if(gettype($fieldsA) == array ) { $fields =  $keys = array_keys($fieldsA); if($keys[0] != 0 ) { foreach($keys as $key) { $fields .= $key. AS .$fieldsA[$key]. ,  } else { foreach($fieldsA as $field) { $fields .= $field. ,  $fields = substr($fields, 0, -2); } else $fields = $fieldsA; $query = SELECT .$fields. FROM .$table. WHERE .$where. ($order!== false? ORDER BY .$order:($group!==false ? GROUP BY .$group : )). ($limit !== false? LIMIT .$limit: ). ($offset !== false? OFFSET .$offset:  return mysql_query($query, $this- linkId); function runUpdate($table, $valuesA, $where = 1 ) { if(gettype($valuesA) == array ) { $fields =  $values =  $keys = array_keys($valuesA); foreach($keys as $key) { if($valuesA[$key] !== NULL) $values .= ` .$key. `= .str_replace( , / , $valuesA[$key]). ,  else $values .= $key. =NULL,  $fields = substr($fields, 0, -1); $values = substr($values, 0, -1); } else $values = $valuesA; $query = UPDATE .$this- prefix.$table. SET .$values. WHERE .$where; if(mysql_query($query, $this- linkId)) return mysql_affected_rows($this- linkId); return false; function runDelete($table, $where = 1 ) { if(mysql_query( DELETE FROM .$this- prefix.$table. WHERE .$where, $this- linkId)) return mysql_affected_rows($this- linkId); return false; function runInsert($table, $valuesA, $onDuplicate = NULL) { if(gettype($valuesA) == array ) { $fields =  $values =  $keys = array_keys($valuesA); foreach($keys as $key) { $fields .= ` .$key. `,  $values .= ($valuesA[$key]===NULL? NULL, : .str_replace( , / , $valuesA[$key]). ,  $fields = substr($fields, 0, -2); $values = substr($values, 0, -2); $onDup =  if($onDuplicate != NULL) { $onDup = ON DUPLICATE KEY UPDATE  if(gettype($onDuplicate) == array ) { $keys = array_keys($onDuplicate); foreach($keys as $key) { $onDup .= ` .$key. `= .($onDuplicate[$key]===NULL? NULL, : .str_replace( , / , $onDuplicate[$key]). ,  $onDup = substr($onDup, 0, -2); } else $onDup .= $onDuplicate; $query = INSERT INTO .$this- prefix.$table.($fields!==NULL? ( .$fields. ) : ). VALUES ( .$values. ) .$onDup; if(mysql_query($query, $this- linkId)) return mysql_affected_rows($this- linkId); return false; function getCells($table){ $query = SHOW COLUMNS FROM ` .$table. `  $fields = mysql_query($query, $this- linkId) or die( hej  return $fields; function translateCellName($cellName){ $sql = $this- runSelect( mysql_cell_translation , mysql_name = .$cellName.  $row = mysql_fetch_assoc($sql); return $row[ human_name ]?$row[ human_name ]: span >
总结：以上就是本篇文的全部内容，希望能对大家的学习有所帮助。
相关推荐：
php结合html5的websocket通讯的使用方法
php针对上传图片文件的功能详解
php结合html5的websocket通讯的使用方法
以上就是简述php操作mysql数据库的类的详细内容，PHP教程        
郑重声明：本文版权归原作者所有，转载文章仅为传播更多信息之目的，如作者信息标记有误，请第一时间联系我们修改或删除，多谢。