Web Development

<?
require_once('DB.php');
 
include ('db_params.php');
 
$dsn = "mysql://$user:$pass@$host/$db_name";
$db = DB::connect($dsn, false);
if (DB::isError($db)) {
die ($db->getMessage());
}
$film_sql = "select * from film where id = $film_id";
 
$q_film = $db->query($film_sql);
if (DB::iserror($q_film)) {
die($q_film->getMessage());
}
while ($row = $q_film->fetchRow()) {
$festival = $row[1];
$nationality = $row[2];
$genre = $row[3];
$blurb_id = $row[4];
$director = $row[5];
$title = stripslashes($row[6]);
$length = $row[7];
$status = $row[8];
$video = substr($row[10],0,1);
 
$blurb_sql = "select content from blurb where id = $blurb_id";
$q_blurb = $db->query($blurb_sql);
if (DB::iserror($q_blurb)) {
die($q_blurb->getMessage());
}
$description = stripslashes($db->getOne($blurb_sql));
$festival_sql = "select name from festival where id = $festival";
$festival_name = stripslashes($db->getOne($festival_sql));
if (DB::iserror($festival_name)) {
die($festival_name->getMessage());
}
}
$db->disconnect();
?>