PDO Tutorial Connect Database and Query Example

Learn how to connect to a mysql database and query it using the PDO extension in PHP. After this PDO coding exercise we conduct a mysqli vs PDO discussion that you may find informative.

<?php
try {
    $db = new PDO('mysql:host=localhost;dbname=db_name', 'db_user', 'db_password');
} catch (PDOException $e) {
    echo $e->getMessage()."<br>";
    die();
}
$sql = 'SELECT username, country from people';
foreach( $db->query($sql) as $row ) {
    echo $row['username']." - ".$row['country']."<br>";
}
$db = null;
?> 

Link to document we discussed about the PHP mysqli extension. http://php.net/manual/en/mysqli.overview.php