三种php链接数据MySQLi 和 PDO 连接 MySQL

MySQLi (面向对象)
MySQLi (面向过程)
PDO

实例 (MySQLi - 面向对象)
<?php
$servername = "localhost";
$username = "username";
$password = "password";

// 创建连接
$conn = new mysqli($servername, $username, $password);

// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
echo "连接成功";
?>

实例 (MySQLi - 面向过程)
<?php
$servername = "localhost";
$username = "username";
$password = "password";

// 创建连接
$conn = mysqli_connect($servername, $username, $password);

// 检测连接
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
echo "连接成功";
?>

实例 (PDO)
<?php
$servername = "localhost";
$username = "username";
$password = "password";

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