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>