php简单操作mysql数据库的类
发布:smiling 来源: PHP粉丝网 添加日期:2021-05-22 19:47:59 浏览: 评论:0
这篇文章主要介绍了php简单操作mysql数据库的类,涉及php操作mysql的连接、查询、插入、删除等基本操作方法,非常具有实用价值,需要的朋友可以参考下
本文实例讲述了php简单操作mysql数据库的类,分享给大家供大家参考,具体如下:
- <?php
- /**
- * Database class
- *
- * @version: 2.2
- * @revised: 27 may 2007
- *
- **/
- class 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 class="faded">['.$cellName.']</span>';
- }
- function getError() {
- return mysql_error($this->linkId);
- }
- function close()
- {
- mysql_close($this->linkId);
- }
- }
- ?>
Tags: php操作mysql数据库
- 上一篇:php生成rss类用法实例
- 下一篇:php实现用于计算执行时间的类实例
相关文章
- ·一款简单实用的php操作mysql数据库类(2021-05-03)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)