php mysql 数据库类_php mysql数据库类

/*

*    mysql数据库DB类

*/

class db

{

//mysql连接标识符

var $connection_id = "";

//是否无间断连接

var $pconnect = 0;

//中断查询语句数组

var $shutdown_queries = array();

//数据库操作sql语句数组

var $queries = array();

//mysql_query资源标识符

var $query_id = "";

//查询次数

var $query_count = 0;

//返回记录

var $record_row = array();

//查询是否失败

var $failed = 0;

//错误消息

var $halt = "";

//操作日志

var $query_log = array();

/**

* 连接数据库

*/

function connect($db_config)

{

if ($this->pconnect) {

$this->connection_id = mysql_pconnect($db_config["hostname"], $db_config["username"],

$db_config["password"]);

} else {

$this->connection_id = mysql_connect($db_config["hostname"], $db_config["username"],

$db_config["password"]);

}

if (!$this->connection_id) {

$this->halt("Can not connect MySQL Server");

}

if (!@mysql_select_db($db_config["database"], $this->connection_id)) {

$this->halt("Can not connect MySQL Database");

}

if ($db_config["charset"]) {

@mysql_unbuffered_query("SET NAMES '" . $db_config["charset"] . "'");

}

return true;

}

/**

* 发送SQL 查询，并返回结果集

*/

function query($query_id, $query_type = 'mysql_query')

{

$this->query_id = $query_type($query_id, $this->connection_id);

$this->queries[] = $query_id;

if (!$this->query_id) {

$this->halt("查询失败:\n$query_id");

}

$this->query_count++;

$this->query_log[] = $str;

return $this->query_id;

}

/**

* 发送SQL 查询，并不获取和缓存结果的行

*/

function query_unbuffered($sql = "")

{

return $this->query($sql, 'mysql_unbuffered_query');

}

/**

* 从结果集中取得一行作为关联数组

*/

function fetch_array($sql = "")

{

if ($sql == "")

$sql = $this->query_id;

$this->record_row = @mysql_fetch_array($sql, MYSQL_ASSOC);

return $this->record_row;

}

/**

* 中断查询

*/

function shutdown_query($query_id = "")

{

$this->shutdown_queries[] = $query_id;

}

/**

* 取得结果集中行的数目，仅对 INSERT，UPDATE 或者 DELETE

*/

function affected_rows()

{

return @mysql_affected_rows($this->connection_id);

}

/**

* 取得结果集中行的数目，仅对 SELECT 语句有效

*/

function num_rows($query_id = "")

{

if ($query_id == "")

$query_id = $this->query_id;

return @mysql_num_rows($query_id);

}

/**

* 返回上一个 MySQL 操作中的错误信息的数字编码

*/

function get_errno()

{

$this->errno = @mysql_errno($this->connection_id);

return $this->errno;

}

/**

* 取得上一步 INSERT 操作产生的 ID

*/

function insert_id()

{

return @mysql_insert_id($this->connection_id);

}

/**

* 得到查询次数

*/

function query_count()

{

return $this->query_count;

}

/**

* 释放结果内存

*/

function free_result($query_id = "")

{

if ($query_id == "")

$query_id = $this->query_id;

@mysql_free_result($query_id);

}

/**

* 关闭 MySQL 连接

*/

function close_db()

{

if ($this->connection_id)

return @mysql_close($this->connection_id);

}

/**

* 列出 MySQL 数据库中的表

*/

function get_table_names()

{

global $db_config;

$result = mysql_list_tables($db_config["database"]);

$num_tables = @mysql_numrows($result);

for ($i = 0; $i < $num_tables; $i++) {

$tables[] = mysql_tablename($result, $i);

}

mysql_free_result($result);

return $tables;

}

/**

* 从结果集中取得列信息并作为对象返回，取得所有字段

*/

function get_result_fields($query_id = "")

{

if ($query_id == "")

$query_id = $this->query_id;

while ($field = mysql_fetch_field($query_id)) {

$fields[] = $field;

}

return $fields;

}

/**

* 错误提示

*/

function halt($the_error = "")

{

$message = $the_error . "
\r\n";

$message .= $this->get_errno() . "
\r\n";

$sql = "INSERT INTO `db_error`(pagename, errstr, timer) VALUES('" . $_SERVER["PHP_SELF"] .

"', '" . addslashes($message) . "', " . time() . ")";

@mysql_unbuffered_query($sql);

if (DEBUG == true) {

echo "

MySQL 数据库错误";

echo "\r\n";

echo "

\r\n";

echo "

\r\n";

echo "" .

htmlspecialchars($message) . "\r\n";

echo "

\r\n";

exit;

}

}

function __destruct()

{

$this->shutdown_queries = array();

$this->close_db();

}

/**

* 单表查询

*/

function sql_select($tbname, $where = "", $limit = 0, $fields = "*", $orderby =

"id", $sort = "DESC")

{

$sql = "SELECT " . $fields . " FROM `" . $tbname . "` " . ($where ? " WHERE " .

$where : "") . " ORDER BY " . $orderby . " " . $sort . ($limit ? " limit " . $limit :

"");

return $sql;

}

/**

* 单表添加

*/

function sql_insert($tbname, $row)

{

foreach ($row as $key => $value) {

$sqlfield .= $key . ",";

$sqlvalue .= "'" . $value . "',";

}

return "INSERT INTO `" . $tbname . "`(" . substr($sqlfield, 0, -1) .

") VALUES (" . substr($sqlvalue, 0, -1) . ")";

}

/**

* 单表更新

*/

function sql_update($tbname, $row, $where)

{

foreach ($row as $key => $value) {

$sqlud .= $key . "= '" . $value . "',";

}

return "UPDATE `" . $tbname . "` SET " . substr($sqlud, 0, -1) . " WHERE " . $where;

}

/**

* 单表删除

*/

function sql_delete($tbname, $where)

{

return "DELETE FROM `" . $tbname . "` WHERE " . $where;

}

/**

* 新增加一条记录

*/

function row_insert($tbname, $row)

{

$sql = $this->sql_insert($tbname, $row);

return $this->query_unbuffered($sql);

}

/**

* 更新指定记录

*/

function row_update($tbname, $row, $where)

{

$sql = $this->sql_update($tbname, $row, $where);

return $this->query_unbuffered($sql);

}

/**

* 删除满足条件的记录

*/

function row_delete($tbname, $where)

{

$sql = $this->sql_delete($tbname, $where);

return $this->query_unbuffered($sql);

}

/**

* 根据条件查询，返回所有记录

* $tbname 表名, $where 查询条件, $limit 返回记录, $fields 返回字段

*/

function row_select($tbname, $where = "", $limit = 0, $fields = "*", $orderby =

"id", $sort = "DESC")

{

$sql = $this->sql_select($tbname, $where, $limit, $fields, $orderby, $sort);

return $this->row_query($sql);

}

/**

* 详细显示一条记录

*/

function row_select_one($tbname, $where, $fields = "*", $orderby = "id")

{

$sql = $this->sql_select($tbname, $where, 1, $fields, $orderby);

return $this->row_query_one($sql);

}

/**

* 返回所有数据(多维数组)

*/

function row_query($sql)

{

$rs = $this->query($sql);

$rs_num = $this->num_rows($rs);

$rows = array();

for ($i = 0; $i < $rs_num; $i++) {

$rows[] = $this->fetch_array($rs);

}

$this->free_result($rs);

return $rows;

}

/**

* 返回一行数据

*/

function row_query_one($sql)

{

$rs = $this->query($sql);

$row = $this->fetch_array($rs);

$this->free_result($rs);

return $row;

}

/**

* 计数统计

*/

function row_count($tbname, $where = "")

{

$sql = "SELECT count(id) as row_sum FROM `" . $tbname . "` " . ($where ?

" WHERE " . $where : "");

$row = $this->row_query_one($sql);

return $row["row_sum"];

}

}

//配置数据库参数

$db_config['hostname'] = 'localhost'; //服务器地址

$db_config['username'] = '********'; //数据库用户名

$db_config['password'] = '********'; //数据库密码

$db_config['database'] = '********'; //数据库名称

$db_config['charset'] = "utf8";

//使用范例

$db_config['table'] = "db_pro";

$rows = "受影响行数：";

$db = new db($db_config);

//显示所有表

print_r($db->get_table_names());

//插入一行数据

$insert_arr = array(username => 'test', sex => '男');

$db->row_insert($db_config['table'], $insert_arr);

echo '
';

//返回受影响行数

echo $rows . $db->affected_rows();

//插入多行数据

$insert_sql = "insert into {$db_config['table']}(username,sex) values('test2','女'),('test3','男')";

$db->query($insert_sql, 'mysql_query');

echo '
';

echo $rows . $db->affected_rows();

//获取多条数据

echo '
';

$sql = "select * from {$db_config['table']}";

print_r($db->row_query($sql));

echo '
';

echo $rows . $db->num_rows();

//获取一条数据

echo '
';

$sql = "select * from {$db_config['table']}";

print_r($db->row_query_one($sql));

echo '
';

echo $rows . $db->num_rows();

//更新数据

$update_arr = array(username => 'updtest', sex => '女');

$where = 'username="test"';

$db->row_update($db_config['table'], $update_arr, $where);

echo '
';

echo $rows . $db->affected_rows();

//删除数据

$where = 'id is not null';

$db->row_delete($db_config['table'], $where);

echo '
';

echo $rows . $db->affected_rows();

echo '
';

echo '执行查询：' . $db->query_count();

echo '
';

echo 'sql语句：';

print_r($db->queries); //显示所有sql查询语句

echo '
';

echo $db->queries[$db->query_result]; //显示上一次sql查询语句

?>