connect_error > 0) {
die('Could not connect: ' . $dbconn->connect_error);
exit(); // if it doesnt connect error page
}
// checking for an id if not then redirects back to rental
$RentalID = 0;
if (isset($_GET['RentalID']))
$RentalID = $_GET['RentalID'];
if ($RentalID == 0)
{
$redirect = "location: http://localhost/gamerental/rental";
header($redirect);
}
// get the details of the rental
$sql = $dbconn->prepare("SELECT RentalID as rentalid,
MemberID as memberid,
GameID as gameid,
Expected as expected,
Returned as returned,
Hired as hired,
Overdue as overdue
from rental
where RentalID = ?");
$sql->bind_param('i', $RentalID);
// execute the query
$sql->execute();
// binding the fields
$sql->bind_result($rentalid, $memberid,$gameid, $expected, $returned, $hired, $overdue);
$sql->store_result();
$sql->fetch();
//close connection
mysqli_close($dbconn);
?>
View Rental Details