display demo with PDO

gistfile1.php

<?php
//connection details
$host = 'localhost';
$dbname = 'database name';
$dbusername = 'database username';
$password = 'db password';

//make a connection
$db = new PDO("mysql:$host=;port=8889;$dbname=", $dbusername, $password);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);


//get records from database if there's an error catch it.
try {
 
   	//select columns to select from the database table
        $stmt = $db->query('SELECT id, name, address FROM table');

        //loop through the rows
        while($row = $stmt->fetch()){
            
            //print the output
            echo '<p>';
                echo 'id: '.$row['id'].'<br />';                 
                echo 'name: '.$row['name'].'<br />';                 
                echo 'addres: '.$row['address'];                 
            echo '</p>';
 
        }// end the while
 
} catch(PDOException $e) {

	//display any error messages
    echo $e->getMessage();
    
}
?>