未捕获的错误:调用未定义的函数mysql_select_db()
问题描述:
我试图从数据库中使用Xamp服务器获取数据,但得到此错误。未捕获的错误:调用未定义的函数mysql_select_db()
Fatal error: Uncaught Error: Call to undefined function mysql_select_db() in E:\xamp\htdocs\PoliceApp\News\fetch.php:10 Stack trace: #0 {main} thrown in E:\xamp\htdocs\PoliceApp\News\fetch.php on line 10
下面是我PHP脚本,我仍然在新的PHP 请帮我出这一点。 但我在这里阅读所有其他帖子,但它似乎让我感到困惑,我该如何正确地请它。
<?php
$username="root";
$password="namungoona";
$hostname = "localhost";
//connection string with database
$dbhandle = mysqli_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "";
// connect with database
$selected = mysql_select_db("police",$dbhandle)
or die("Could not select examples");
//query fire
$result = mysql_query("select * from News;");
$json_response = array();
// fetch data in array format
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
// Fetch data of Fname Column and store in array of row_array
$row_array['Headlines'] = $row['Headlines'];
$row_array['Details'] = $row['Details'];
$row_array['NewsPhoto'] = $row['NewsPhoto'];
//push the values in the array
array_push($json_response,$row_array);
}
//
echo json_encode($json_response);
?>
答
根据您的要求,我修改了代码。
<?php
$username="root";
$password="namungoona";
$hostname = "localhost";
//connection string with database
$dbhandle = mysqli_connect($hostname, $username, $password)
or die("Unable to connect to MySQL");
echo "";
// connect with database
$selected = mysqli_select_db($dbhandle, "police")
or die("Could not select examples");
//query fire
$result = mysqli_query($dbhandle,"select * from News;");
$json_response = array();
// fetch data in array format
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
// Fetch data of Fname Column and store in array of row_array
$row_array['Headlines'] = $row['Headlines'];
$row_array['Details'] = $row['Details'];
$row_array['NewsPhoto'] = $row['NewsPhoto'];
//push the values in the array
array_push($json_response,$row_array);
}
//
echo json_encode($json_response);
mysqli_free_result($result);
?>
请注意:您需要添加错误检查。另外请注意,在这里输入(未测试),所以如果有一些错误,请耐心等待。
+0
不错。但请记住不要忘记手册。它是一个很好的资源,有很多例子,技巧,措施和注意事项。 – bansi
应该将'mysqli_select_db'和其他'myslq_ *'函数改为它们的'mysqli_ *' – bansi
你不能混合和匹配'mysql_ *'和'mysqli_ *'函数。听起来你可能正在使用PHP 7,它已经完全删除了mysql_ *'API。即使你不是,你也不应该使用它们。 –
当我在第10行添加msqli_ *时,他们说**警告:mysqli_select_db()期望参数1是在第10行E:\ xamp \ htdocs \ PoliceApp \ News \ fetch.php中给出的mysqli,字符串 无法选择例子**,请你为我编辑代码@bansi –