<?php
/*** Database Information  ***/
require_once('dbconfig.php');

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);
    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    echo $e->getMessage();
}

$id = $_GET['id'];


$sql = "SELECT movie.title, movie.year, movie.rating, movieartwork.filename, movieartwork.ext
FROM movie
LEFT JOIN movieartwork
ON movie.poster=movieartwork.id
WHERE movie.id = ?;";

$query = $dbh->prepare($sql);
$query->execute(array($id));

$result = $query->fetchAll();
echo '<pre>', print_r($result), '</pre>';




?>