connect_error > 0) {
die('Could not connect: ' . $dbconn->connect_error);
exit(); // you should redirect to some form of error page !!!!
}
// now get the goalkeeper data, there should be only 1 record
$sql = $dbconn->prepare("select playerid, lastname
from goalkeepers
where playerid = ?");
$sql->bind_param('i', $id);
// execute the query
$sql->execute();
// we have the data, bind the fields
$sql->bind_result($playerid, $description);
$sql->store_result();
// check for 0 rows or > 1 rows, if so redirect to list
if ($sql->num_rows == 0 || $sql->num_rows > 1)
{
$redirect = "location: http://localhost/lfc/goalkeepers";
//header($redirect);
}
// get the row of data - you will need a loop if there is more than 1 row
$sql->fetch();
?>
Liverpool FC