Connect to MySQL database and fetch data from MySQL table and display in html Topic is solved

[sudheer1994]

I want to get data from MySQL database and display in html table

[cuehosting]

Code: Select all

<?php include 'header.php';
$con = mysqli_connect( "xyz.com","nano","itsacar","my_db" );
$sql = "SELECT * FROM cars";
$result = $con->query($sql);
	
echo "<table border='1'>
<tr>
<th>Name</th>
<th>Model</th>
</tr>";

while($array= mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $array['Name'] . "</td>";
echo "<td>" . $array['Model'] . "</td>";
echo "</tr>";
}
echo "</table>";

mysqli_close($con);
?>

Hope it works for you