[Solved] MySQL Database Query using PHP Script Ubuntu LAMP

MySQL Database Query 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();
}
?>

<?php
$sql = "SELECT * FROM CLIENT";
$result = DB_Execute($sql);
?>