PHP中mysql到mysqli的升级示例

从旧的 mysql 扩展迁移的用户，选择面向过程的接口，因为两者的差异较小，只需简单的修改即可。

1、mysql 扩展

<?php

$mysql = mysql_connect("example.com", "user", "password");

mysql_select_db("test");

$result = mysql_query("SELECT 'Use the mysqli extension instead.' AS _msg FROM DUAL", $mysql);

$row = mysql_fetch_assoc($result);

echo $row['_msg'];

?>

 

2、mysqli 扩展

<?php

$mysqli = mysqli_connect("example.com", "user", "password", "database");

$result = mysqli_query($mysqli, "SELECT 'Please do not use the deprecated mysql extension for new development. ' AS _msg FROM DUAL");

$row = mysqli_fetch_assoc($result);

echo $row['_msg'];

?>