PHP MySQL警告：mysqli_fetch_array（）期望参数1为mysqli_result [duplicate]
This question already has an answer here:
This is my PHP code :
<html>
<head>
<title>SQL DB Management</title>
</head>
<body>
<h1>MySqlAdmin</h1>
<table>
<tr>
<th><!--Heading 1--></th>
<th><!--Heading 2--></th>
<th><!--Leave it blank--></th>
</tr>
<?php
$db_host = "mysql.freehostingnoads.net";
$db_username = "";
$db_password = "";
$db_name = "";
$db_table = "";
$db = mysqli_connect($db_host, $db_username, $db_password, $db_name);
if (mysqli_connect_errno()){die("Failed to connect to MySQL: " . mysql_connect_error());}
$content = mysqli_query($db,"SELECT * FROM " . $db_table);
while($line = mysqli_fetch_array( $content )){
echo("<tr>");
echo("<td>" . $line['c1'] . "</td>");
echo("<td>" . $line['c2'] . "</td>");
#delete button
echo("<td><form action='del.php' method='GET'><input type='text' name='c1' value='" . $line['c1'] . "' /><input type='text' name='c2' value='" . $line['c2'] . "' /><input type='button' value='DEL' /></form></td>");
echo("</tr>");
}
?>
</body>
</html>
And simply skip reading the <head>, this is the warning I received:
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/u273577101/public_html/index.php on line 23
I have searched but cannot find the answer. What's the problem here?
There is no connection error, I guess. It doesn't seem to give me any error message about connecting.
</div>
Sorry, that was not the problem.
The problem is that I assigned the value "table" for $db_table and it might be a key word.
Thank you for your help.
mysqli_query is returning boolean FALSE because your $db_table variable is set to an empty string and so the resulting query you are giving it is invalid.
You simply need to set the $db_table variable to be a valid table name.
mysqli_query returns false on failure, so there is something wrong with your code or server. Please make sure the table exists and the table's name is not a keyword in MySQL.
us3.php.net/mysqli_query