(mysql vs mysqli error (advantage))
大家好，请看代码。这段代码运行在我的本地主机WAMP Win7 php版本5.5.12，但它给出了一个错误:
---
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:'wamp'www'get_data02.php on line 9
Call Stack
# Time Memory Function Location
1 0.0010 135216 {main}( ) ..'get_data02.php:0
2 0.0010 135680 mysql_connect ( ) ..'get_data02.php:9
---
我试着用mysqli代替mysql，但那只是给了更多的错误。我该如何解决这个问题?谢谢你,
<?php
// 1. Enter Database details
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'iamdb_copy_04';
// 2. Create a database connection
$connection = mysql_connect($dbhost,$dbuser,$dbpass);
if (!$connection) {
die("Database connection failed: " . mysql_error());
}
// 3. Select a database to use
$db_select = mysql_select_db($dbname,$connection);
if (!$db_select) {
die("Database selection failed: " . mysql_error());
}
$query = mysql_query("SELECT * FROM users WHERE city = 'city' ");
while ($rows = mysql_fetch_array($query)) {
$f_name = $rows['first_name'];
$address_01 = $rows['address_01'];
$city = $rows['city'];
echo "$f_name<br>$address_01<br>$city<br><br>";
}
?>
有两个选项可以从这个错误中退出。
-
在php
<?php启动后使用ini_set("display_errors",0)设置php文件中的display_errors关闭 -
将
mysql_connect、mysql_select_db、mysql_query、mysql_fetch_array中的mysql替换为mysqli
如果你仍然遇到任何问题，请告诉我，并注释你的错误。