Question

How to open MySQL database and view a table with PHP Data Objects (PDO) in PHP

Answer 1

$db = new PDO("mysql:host=localhost;dbname=database_name", "username", "password");

$sql = $db->prepare("SELECT * FROM a_table");
$sql->execute();

while ($row = $sql->fetch()) 
    print_r($row);
    
$sql = null;

70+ SQL courses for beginners and professionals