一个php Mysql类 可以参考学习熟悉下
2015-01-24信息快讯网
慢慢研究吧,非常适合学习的php数据库(mysql)类,也可以拿来直接就用,稍微熟悉一下就可以啦!
<?php class Mysql { private $conn; private $host; private $username; private $password; private $dbname; private $pconnect; private $charset; public function __construct(array $params = null) { if (!empty($params)) { foreach ($params as $k => $v) { $this->$k = $v; } } } public function connect() { $fun = $this->pconnect ? 'mysql_pconnect' : 'mysql_connect'; $this->conn = $fun($this->host, $this->username, $this->password); $this->conn && $this->query('set names ' . $this->charset); $this->conn && mysql_select_db($this->dbname, $this->conn); } public function getInstance() { return $this->conn; } public function query($sql) { return mysql_query($sql, $this->conn); } public function fetchOne($sql) { $data = $this->fetchRow($sql); return $data[0]; } public function fetchCol($sql) { $tmp = $this->fetchAll($sql, MYSQL_NUM); foreach ($tmp as $v) { $data[] = $v[0]; } } public function fetchRow($sql) { $result = $this->query($sql); $data = mysql_fetch_row($result); mysql_free_result($result); return $data; } public function fetchAssoc($sql) { $result = $this->query($sql); $data = mysql_fetch_assoc($result); mysql_free_result($result); return $data; } public function fetchAll($sql, $type = MYSQL_ASSOC) { $result = $this->query($sql); while ($tmp = mysql_fetch_array($result, $type)) { $data[] = $tmp; } return $data; } public function fetchPairs($sql) { $result = $this->query($sql); while ($tmp = mysql_fetch_row($result)) { $data[$tmp[0]] = $tmp[1]; } return $data; } public function insert($table, array $bind) { $cols = array(); $vals = array(); foreach ($bind as $col => $val) { $cols[] = $col; $vals[] = $val; unset($bind[$col]); } $sql = "INSERT INTO " . $table . ' (`' . implode('`, `', $cols) . '`) ' . 'VALUES (\'' . implode('\', \'', $vals) . '\')'; $stmt = $this->query($sql, $this->conn); $result = $this->affectedRows(); return $result; } public function getLastInsertId() { return mysql_insert_id($this->conn); } public function affectedRows() { return mysql_affected_rows($this->conn); } public function update($table, array $bind, $where = '') { $set = array(); foreach ($bind as $col => $val) { $set[] = '`' . $col . "` = '" . $val . "'"; } $sql = "UPDATE `" . $table . '` SET ' . implode(', ', $set) . (($where) ? " WHERE $where" : ''); $stmt = $this->query($sql, array_values($bind)); $result = $this->affectedRows(); return $result; } public function delete($table, $where = '') { /** * Build the DELETE statement */ $sql = "DELETE FROM " . $table . (($where) ? " WHERE $where" : ''); /** * Execute the statement and return the number of affected rows */ $stmt = $this->query($sql); $result = $stmt ? mysql_affected_rows($this->conn) : $stmt; return $result; } public function close() { $this->conn && mysql_close($this->conn); } } ?>
PHP Session_Regenerate_ID函数双释放内存破坏漏洞
PHP中通过加号合并数组的一个简单方法分享
PHP中删除变量时unset()和null的区别分析
PHP企业级应用之常见缓存技术篇
兼容性最强的PHP生成缩略图的函数代码(修改版)
discuz的php防止sql注入函数
php下连接mssql2005的代码
PHP备份/还原MySQL数据库的代码
PHP 设置MySQL连接字符集的方法
PHP+SQL 注入攻击的技术实现以及预防办法
解决PHP在DOS命令行下却无法链接MySQL的技术笔记
PHP与MySQL开发的8个技巧小结
php数据入库前清理 注意php intval与mysql的int取值范围不同
php 分页函数multi() discuz
discuz7 phpMysql操作类
php 将bmp图片转为jpg等其他任意格式的图片
PHP COOKIE设置为浏览器进程
PHP 输出缓存详解
php 图像函数大举例(非原创)
php MYSQL 数据备份类
PHP写MySQL数据 实现代码
php adodb连接mssql解决乱码问题
php MsSql server时遇到的中文编码问题
IIS6+PHP5+MySQL5+Zend Optimizer+phpMyAdmin安装配置图文教程 2009年
PHP XML备份Mysql数据库