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 index
$CatID = 0;
if (isset($_GET['CatID']))
$CatID = $_GET['CatID'];
if ($CatID == 0)
{
$redirect = "location: http://localhost/assignment/index.php";
header($redirect);
}
// get the details of the cats
$sql = $dbconn->prepare("SELECT CatID as CatID,
description as description
from famouscat
where CatID = ?");
$sql->bind_param('i', $CatID);
// execute the query
$sql->execute();
// binding the fields
$sql->bind_result( $CatID, $description);
$sql->store_result();
$sql->fetch();
//close connection
mysqli_close($dbconn);
?>
Pawsome Website
Back