connect_error > 0) { die('Could not connect: ' . $dbconn->connect_error); exit(); // you should redirect to some form of error page !!!! } // lets see if we have the media id if not return to the list $mediaid = 0; if (isset($_GET['mediaid'])) $mediaid = $_GET['mediaid']; if ($mediaid == 0) { $redirect = "location: http://localhost/rentals/media"; header($redirect); } // get the details of the media $sql = $dbconn->prepare("SELECT m.MediaID as mediaid, m.MediaName as medianame, m.Category as category, m.Director as director, IF(g.GenreID is null, 'Genre Not Allocated', g.genredesc) as genredesc, IF(s.SupplierID is null, 'Supplier Not Allocated', s.SupplierName) as suppliername, IF(p.PriceCodeID is null, 0.00, p.RentalPrice) as rentalprice, IF(m.ImageName = 'No Image', 0, 1) as imagename FROM media m left join genre g on g.GenreID = m.GenreID left join suppliers s on s.SupplierID = m.SupplierID left join pricecode p on p.PriceCodeID = m.PriceCodeID where m.MediaID = ?"); $sql->bind_param('i', $mediaid); // execute the query $sql->execute(); // we have the data, bind the fields $sql->bind_result($mediaid, $medianame, $category, $director, $genredesc, $suppliername, $rentalprice, $imagename); $sql->store_result(); $sql->fetch(); // now who rented the film and on what date $sql = $dbconn->prepare("SELECT IF(c.MemberID is null, 0, c.MemberID) as memberid, IF(c.MemberID is null, 'Customer Deleted/Removed', CONCAT(c.Forename, ' ', c.Surname)) as customername, r.Hired as hired, r.Expected as expected, r.Returned as returned, r.Overdue as overdue from rentals r left join customers c on c.MemberID = r.MemberID where r.DvdID = ?"); $sql->bind_param('i', $mediaid); // execute the query $sql->execute(); // we have the data, bind the fields $sql->bind_result($memberid, $customername, $hired, $expected, $returned, $overdue); $sql->store_result(); $datatable = ""; // loop through the customers rentals while($sql->fetch()) { $datatable.= ""; // allow hyperlink to customer if they exist if ($memberid == 0) $datatable.=""; else $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; $datatable.= ""; // check for overdue if ($overdue == 1) $datatable.= ""; else $datatable.= ""; $datatable.= "" ; } //close connection mysqli_close($dbconn); ?> Dashboard Template · Bootstrap

Media Details

Media Name