viewing a column in mysql database using php script

Question

I'm trying to print a row from a table in mysql using a PHP script - here is the code but its not working - it shows Bad query apparently there is no issue:

$conn = mysqli_connect($servername, $username, $password, $db);
if (!$conn) {
   die("Connection failed: " . mysqli_connect_error());
}

else{

echo "Connected successfully";

}


$any = "show columns from help_category";
$chk = mysqli_query($any) or die("Bad Query: $sql");
echo"<table border='3'>";
echo"<tr><td>Type</td><tr>";

while($row = mysqli_fetch_assoc($chk))

{

echo"<tr><td>{$row['Type']}</td><tr>";


}


echo"</table>";

Answer 1

I have checked your code and i found out that you have issue with your query execution on php function mysqli_query

mysqli_query requires two parameter first one is connection object and second one is query variable to execute a query.

Below is exact code:-

$conn = mysqli_connect($servername, $username, $password, $db);
if (!$conn) {
   die("Connection failed: " . mysqli_connect_error());
}

else{

echo "Connected successfully";

}


$any = "show columns from transaction";
$chk = mysqli_query($conn, $any) or die("Bad Query: $sql");
echo"<table border='3'>";
echo"<tr><td>Type</td><tr>";

while($row = mysqli_fetch_assoc($chk))

{

echo"<tr><td>{$row['Type']}</td><tr>";


}


echo"</table>";