<?php
class Songs extends PDO
{
   /**
    * Database User
    *
    * @var      string
    * @access   private
    */
    private $_user;

   /**
    * Database Password
    *
    * @var      string
    * @access   private
    */
    private $_password;

   /**
    * Database Host
    *
    * @var      string
    * @access   private
    */
    private $_host;

   /**
    * Database Name
    *
    * @var      string
    * @access   private
    */
    private $_dbname;

    public function __construct( $host, $user='', $password='', $dbname='' )
    {
        $drivers = PDO::getAvailableDrivers();

        // Assume an SQLite database
        if(strlen($user) < 1) {
            if(!in_array('sqlite', $drivers)) die('SQLite driver unavailable!');
            parent::__construct('sqlite:'. $host);
            $this->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            return;
        }

        if(!in_array('mysql', $drivers)) die('MySQL driver unavailable!');
        parent::__construct("mysql:host={$host};dbname={$dbname}", $user, $password,
            array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
        return;
    }

    public function fetch_all_songs()
    {
        $stmt = $this->query("SELECT * FROM songs");
        $rows = array();

        while(($row = $stmt->fetch(PDO::FETCH_ASSOC)) !== false) {
            $rows[] = $row;
        }

        if(count($rows) < 1) return false;
        $json   = array();
        for($i=0;count($rows)<$i;$i++) {
            $json[$i]['name'] = $rows[$i]['title'];
            $json[$i]['mp3']  = $rows[$i]['mp3'];
        }
        echo 'var myPlayList = '. json_encode($json) .';';
        return;
    }
}

$dbh = new Songs( './testdb.sdb');