[Solved] MySQL Database Selecting and Reading Data using PHP Script Ubuntu LAMP

MySQL Database : Selecting and Reading Data 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 SNO, NAME FROM CLIENT";
$result = DB_Execute($sql);

while($row = $result->fetch_assoc())
{
echo $sno = $row['SNO'];
echo $name = $row['NAME'];
}
?>