prepare($sql); $stm->execute([':id' => $business_id]); $business_name = $stm->fetch()[0]; /** * Go back with an error message if the business with this id does not exist. */ if (empty($business_name)) { header('Location: /businesses.php?err=bad_id'); exit(); } $pageTitle = 'Business: ' . $business_name; $pageSlug = 'businesses'; require_once('./inc/head.php'); require_once('./inc/header.php'); ?>

prepare($sql); $stm->execute([':id' => $business_id]); $business = $stm->fetch(); /** * Fetch all services that this business offers and concatenate them in a single string. */ $sql = ' select string_agg(s.service_name, \'; \') as services from business_service bs join service s on bs.service_id = s.service_id where business_id = :id'; $stm = $conn->prepare($sql); $stm->execute([':id' => $business_id]); $services = $stm->fetch()[0]; ?>
Category:
Service(s):
Description:
Phone:
Work hours:
Address(es):
    prepare($sql); $stm->execute([':id' => $business_id]); $addresses = $stm->fetchAll(); foreach ($addresses as $row) { ?>

Reviews

prepare($sql); $stm->execute([':id' => $business_id]); $reviews = $stm->fetchAll(); foreach ($reviews as $row) { ?>
✅ Verified'; } else { echo '☑️ Not verified'; } ?>
Location:
Reviewed at:

Add review

$row) { ?>
>
>
" required>