Question

php报错Warning: mysql_fetch_array() expects parameter 1 to be resource

<?php
error_reporting(E_ALL ^ E_NOTICE^ E_DEPRECATED);

if (!isset ($_SESSION)) {
ob_start();
session_start();
}
$hostname="localhost"; //mysql地址
$basename="root"; //mysql用户名
$basepass="root"; //mysql密码
$database="travel"; //mysql数据库名称

$conn=mysql_connect($hostname,$basename,$basepass); //连接mysql
if(!$conn){
die('不能连接数据库'.mysql_error());
}
mysql_select_db($database,$conn); //选择mysql数据库
mysql_query("set names 'utf8'");//mysql编码
$userid=$_GET['userid'];

$sql = "select * from Users where user_id=".$userid;
$result = mysql_query($sql);

$user = mysql_fetch_array($result);

echo "
<tr>
<td> ".$user['user_id']."</td>
<td> ".$user['user_name']."</td>
<td> ".$user['remarks']."</td>

</tr>
";

?>
不知道错在哪里

Answer 1

连接后应该是还没有选择库$db_selected=mysql_select_db('库名称',$conn);

Answer 2

好像没有开启mysqli或者没有安装mysqli扩展