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($_POST['mediaid']))
$mediaid = $_POST['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, 0, g.GenreID) as genreid,
IF(s.SupplierID is null, 0, s.SupplierID) as supplierid,
IF(p.PriceCodeID is null, 0, p.PriceCodeID) as pricecodeid,
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, $genreid, $supplierid, $pricecodeid, $imagename);
$sql->store_result();
$sql->fetch();
// generate various dropdowns - first genre
$sql = $dbconn->prepare("select GenreID as genreid, genredesc from genre");
/* execute the query */
$sql->execute();
$sql->bind_result($id, $desc);
$sql->store_result();
$genredd = "";
$genredd.= ' ';
// now the supplier
// generate various dropdowns - first genre
$sql = $dbconn->prepare("select SupplierID as supplierid, SupplierName as suppliername from suppliers");
/* execute the query */
$sql->execute();
$sql->bind_result($id, $desc);
$sql->store_result();
$supplierdd = "";
$supplierdd.= ' ';
// and finally what about the price code - have a go yourself ?
$sql = $dbconn->prepare("select PriceCodeID as pricecodeid, CONCAT(pricecode, ' - ', RentalPrice) as rentalprice from pricecode");
/* execute the query */
$sql->execute();
$sql->bind_result($id, $desc);
$sql->store_result();
$pricecodedd = "";
$pricecodedd.= ' ';
//close connection
mysqli_close($dbconn);
?>
Dashboard Template · Bootstrap