频道导航

• ▸ PHP
• ▸ Java
• ▸ Java SE
• ▸ Python
• ▸ C#
• ▸ C&C++
• ▸ Ruby
• ▸ VB
• ▸ asp.Net
• ▸ Go
• ▸ Perl
• ▸ netty
• ▸ Django
• ▸ Delphi
• ▸ Jsp
• ▸ .NET Core
• ▸ Spring
• ▸ Flask
• ▸ Springboot
• ▸ SpringMVC
• ▸ Lua
• ▸ Laravel
• ▸ Mybatis
• ▸ Asp
• ▸ Groovy
• ▸ ThinkPHP
• ▸ Yii
• ▸ swoole
• ▸ HTML
• ▸ HTML5
• ▸ JavaScript
• ▸ CSS
• ▸ jQuery
• ▸ Bootstrap
• ▸ Angularjs
• ▸ TypeScript
• ▸ Vue
• ▸ Dojo
• ▸ Json
• ▸ Electron
• ▸ Node.js
• ▸ extjs
• ▸ Express
• ▸ XML
• ▸ ES6
• ▸ Ajax
• ▸ Flash
• ▸ Unity
• ▸ React
• ▸ Flex
• ▸ Ant Design
• ▸ Web前端
• ▸ 微信小程序
• ▸ 微信公众号
• ▸ iOS
• ▸ Android
• ▸ Swift
• ▸ Hybrid
• ▸ Cocos2d-x
• ▸ Flutter
• ▸ Xcode
• ▸ Silverlight
• ▸ cocoa
• ▸ Cordova

• 前端之家
• PHP
• 一个php Mysql类 可以参考学习熟悉下

<div class="codebody" id="code7932">
<?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 " <BR>. $table <BR>. ' 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);
}
}
?>