建议使用MySQLi或PDO扩展。不建议在新开发中使用旧的MySQL扩展,因为它在PHP5.5.0中被废弃,在PHP 7中被删除。
PHP提供了三种不同的API来连接MySQL。下面我们展示了MySQL、mysqli和PDO扩展提供的API。每个代码片段使用用户名“username”和密码“Password”创建到运行在“example.com”上的MySQL服务器的连接。然后运行一个查询来问候用户。
示例1:比较三种MySQLAPI
// mysqli
$mysqli = new mysqli("example.com", "username", "password", "database");
$result = $mysqli->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");
$row = $result->fetch_assoc();
echo htmlentities($row['_message']);
// PDO
$pdo = new PDO('mysql:host=example.com;dbname=database', 'username', 'password');
$statement = $pdo->query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");
$row = $statement->fetch(PDO::FETCH_ASSOC);
echo htmlentities($row['_message']);
// mysql
$c = mysql_connect("example.com", "username", "password");
mysql_select_db("database");
$result = mysql_query("SELECT 'Hello, dear MySQL user!' AS _message FROM DUAL");
$row = mysql_fetch_assoc($result);
echo htmlentities($row['_message']);
?>
我建议您尝试MySQLi和PDO,并找出您喜欢的API设计。