nig

<?php
require_once(dirname(__FILE__) . '/config.php');

try {
    // instantiate a PDO object
    $db = new PDO("mysql:host=" . DBHOST . ";dbname=" . DBNAME, DBUSER, DBPASS, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

    // get the data
    $fridges_q = $db->prepare("
    SELECT
        f.id,
        s.height,
        s.volume,
        e.level,
        e.years,
        f.usage
    FROM fridges AS f
    INNER JOIN sizes AS s
        ON s.id = f.size
    INNER JOIN energy_levels AS e
        ON e.id = f.energy_level
    ");

    $db = null;
}
catch (PDOException $e) {
    die($e->getMessage());
}