Question

How to open MySQL database and view a table with MySQLi Object in PHP

Answer 1

$db = new mysqli("localhost", "username", "password", "databasename");

$sql = "SELECT * FROM a_table";
$result = $db->query($sql);
while ($row = $result->fetch_assoc()) 
    print_r($row); // $row['field']

$result->close();
$db->close();

70+ SQL courses for beginners and professionals