[Solved] MySQL Database Creating or Filling Table with Data Read using PHP Script Ubuntu LAMP

MySQL Database : Creating or Filling Table with Data Read using PHP Script

Database Connection and Query

<?php
function DB_Execute($sql)
{
$servername = "localhost";
$username = "root";
$password = "root";
// Create connection
$conn = new mysqli($servername, $username, $password);
// Check connection
if ($conn->connect_error)
{ die("Connection failed: " . $conn->connect_error); }
// Executing Sql Query
$temp = $conn->query($sql);
if ($temp->num_rows > 0)
{ return $temp; }
else
{ return null; }
// Closing connection
$conn->close();
}

$sql = "SELECT * FROM CLIENT";
$result = DB_Execute($sql);

echo "<table>";
echo "<tr><th>SNO</th>";
echo "<th>NAME</th></tr>";
while($row = $result->fetch_assoc())
{
$sno = $row['SNO'];
$name = $row['NAME'];
echo "<tr><td>$sno</td>";
echo "<td>$name</td><tr>";
}
echo "</table>";
?>