connect_error > 0) {
die('Could not connect: ' . $dbconn->connect_error);
exit(); // if it doesnt connect error page
}
//gets the price data
$sql = $dbconn->prepare("select PriceID, rentalprice
from price
where PriceID = ?");
$sql->bind_param('i', $id);
// execute the query
$sql->execute();
// got the data, now binds it
$sql->bind_result($PriceID, $rentalprice);
$sql->store_result();
if ($sql->num_rows == 0 || $sql->num_rows > 1)
{
$redirect = "location: http://localhost/gamerental/price";
header($redirect);
}
$sql->fetch();
?>
Game Rental