connect_error > 0) {
die('Could not connect: ' . $dbconn->connect_error);
exit(); // Error page
}
// now get the member data
$sql = $dbconn->prepare("select MemberID,
Title ,
Forename,
Surname,
Address1,
Address2,
Postcode,
Telephone,
Email,
DataOfBirth,
Gender
from customers
where MemberID = ?");
$sql->bind_param('i', $id);
// execute the query
$sql->execute();
// once got the data, bind it.
$sql->bind_result($memberid, $title, $forename, $surname, $address1, $address2, $postcode, $telephone, $email, $dateofbirth, $gender);
$sql->store_result();
//checking the rows, if there is 0 then redirects to customer page
if ($sql->num_rows == 0 || $sql->num_rows > 1)
{
$redirect = "location: http://localhost/gamerental/customers";
}
$sql->fetch();
?>
Customers