mysqli_fetch_assoc（）使用localhost而不是godaddy [重复]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

I have a code like below:

$sql="SELECT * FROM $tbl_name WHERE AdminId='$AdminId'";
$result=mysqli_query($conn,$sql);
$row = mysqli_fetch_assoc($result);

and $conn is declared like below in a separate connection file:

<?php
$host="1.2.3.4:1234"; // Host name
$username="xyz"; // Mysql username
$password="abc"; // Mysql password
$db_name="dbname"; // Database name

$conn=@mysqli_connect("$host", "$username", "$password")or die("Cannot connect to the server");
mysqli_select_db($conn,"$db_name")or die("Cannot select DB");
?>

While running the php page, I am getting below error:

mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given

While, this query works fine with my localhost.

Any suggestion ?

Thanks.

</div>

Answer 1

Replace with this I hope this work.As mysqli_fetch_assoc was deprecated in PHP 5.5.0

$row = mysql_fetch_assoc($result);