面向对象简单Db类

Class Db{
	private $db_host;
	private $db_user;
	private $db_pass;
	private $db_name;
	private $charset;

	public function __construct($config){
		$this->db_host = $config['db_host'];
		$this->db_user = $config['db_user'];
		$this->db_pass = $config['db_pass'];
		$this->db_name = $config['db_name'];
		$this->charset = $config['charset'];
		$this->connectDb();
		$this->selectDb();
		$this->setCharset();

	}

	public function connectDb(){
		if(!@mysql_connect($this->db_host,$this->db_user,$this->db_pass)){
			die("链接数据库失败");
		}
	}

	public function selectDb(){
		if(!mysql_select_db($this->db_name)){
			die("选择数据库失败");
		}
	}

	private function setCharset(){
		mysql_query("set names {$this->charset}");
	}

}
$arr = [
	'db_host' => 'localhost',
	'db_name' => 'de',
	'db_user' => 'root',
	'db_pass' => 'root',
	'charset' => 'utf8',
];
$obj = new Db($arr);
var_dump($obj);

 

mysqli 只能连接mysql数据库

(面向对象)

$servername = "localhost";
$username = "root";
$password = "root";
 
// 创建连接
$conn = new mysqli($servername, $username, $password);
 
// 检测连接
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
} 
echo "连接成功";

关闭连接：$conn->close();

 

面向过程

$servername = "localhost";
$username = "root";
$password = "root";
 
// 创建连接
$conn = mysqli_connect($servername, $username, $password);
 
// 检测连接
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "连接成功面向过程";

关闭连接

mysqli_close($conn);

PDO  可以连接很多种数据库

$servername = "localhost";
$username = "root";
$password = "root";
 
try {
    $conn = new PDO("mysql:host=$servername;", $username, $password);
    echo "连接成功PDO"; 
}
catch(PDOException $e)
{
    echo $e->getMessage();
}

关闭连接：$conn = null;