首页 > 文章 > php教程 > php简单操作mysql数据库的类

php简单操作mysql数据库的类

WBOY原创: 2016-06-13 09:06:481045浏览

php简单操作mysql数据库的类

具体如下：

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

/**

* 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']:'['.$cellName.']';

}

function getError() {

return mysql_error($this->linkId);

}

function close()

{

mysql_close($this->linkId);

}

声明：

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

上一篇：php实现对两个数组进行减法操作的方法，数组减法下一篇：PHP生成唯一订单号的方法汇总，php订单号汇总

查看更多

php简单操作mysql数据库的类

php简单操作mysql数据库的类

相关文章