<?php
class db {
/*** mysql hostname ***/
var $hostname = 'localhost';
/*** mysql username ***/
var $username = 'root';
/*** mysql password ***/
var $password = '';
var $dbh;
var $connected = false;
function __construct(){

   $this->dbh = new PDO("mysql:host=$this->hostname;dbname=legiontd", $this->username, $this->password);
   $this->connected = true;
 }

function get_loop($query){
        if ($this->connected==true){
}
    foreach ($this->dbh->query($query) as $row)
      {
        print $row['author'] .' -<br/> '. $row['title'] . '<br />';
       }

    /*** close the database connection ***/
    $dbh = null;
    }
}

?>