php实现mysql封装类示例

PHP MySQL封装类的优雅实现

在PHP中，封装MySQL操作为一个类可以大大提高代码的可读性和可维护性。以下是一个简单的MySQL封装类的示例，供您参考。

一、类定义

====

```php

class MySQLWrapper {

private $host;

private $user;

private $password;

private $dbname;

private $charset;

private $conn;

public function __construct($host = 'localhost', $user = 'root', $password = 'root', $dbname = 'test', $charset = 'utf8') {

$this->host = $host;

$this->user = $user;

$this->password = $password;

$this->dbName = $dbname;

$this->charset = $charset;

$this->connect();

$this->selectDb();

$this->setCharset();

}

private function connect() {

$this->conn = mysql_connect($this->host, $this->user, $this->password);

if (!$this->conn) {

die('数据库连接失败');

}

}

public function selectDb() {

$this->query("USE {$this->dbName}");

}

public function setCharset() {

$this->query("SET NAMES {$this->charset}");

}

private function query($sql) {

return mysql_query($sql, $this->conn);

}