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 customers
$memberid = 0;
if (isset($_GET['memberid']))
$memberid = $_GET['memberid'];
if ($memberid == 0)
{
$redirect = "location: http://localhost/gamerental/customers";
header($redirect);
}
// get the details of the members
$sql = $dbconn->prepare("SELECT MemberID as memberid,
Title as title,
Forename as forename,
Surname as surname,
Address1 as address1,
Address2 as address2,
Postcode as postcode,
Telephone as telephone,
Email as email,
DataOfBirth as dateofbirth,
Gender as gender
from customers
where MemberID = ?");
$sql->bind_param('i', $memberid);
// execute the query
$sql->execute();
// binding the fields
$sql->bind_result( $memberid, $title,$forename, $surname, $address1, $address2, $postcode, $telephone, $email, $dateofbirth, $gender);
$sql->store_result();
$sql->fetch();
//close connection
mysqli_close($dbconn);
?>
View Customer Details