mySQL无法建立与php的连接[重复]

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 created a very simple database on mySQL using phpMyAdmin. Now I want to connect my database through php file so that I can manipulate data in DB, i.e. inserting, deleting, showing, updating data. I wrote the code:

index.php file:

    <?php
include 'includes/connection.php';
$query="SELECT * FROM people";
$result=mysql_query($query);
while($person= mysql_fetch_array($result)){
echo "<h3>". $person['name']."</h3>";

}
?>

connection.php file:

    <?php
$dbhost='localhost';
$dbuser='root';
$dbpass='';
$db='mysql_tut';
$conn=mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db($db);

?>

But it shows the following error in the browser window:

 Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\phpMyAdmin\index.php on line 5

</div>

Answer 1

You gotta pass two parameters to the function. The database name and the query.

$conn = mysqli_connect($query, $query);

I use mysqli_connect instead of mysql_connect becaouse mysql is deprecated.