Tooltip text
prepare($sql)) {
$stmt->bind_param(“i”, $lotNumber);
if ($stmt->execute()) {
$result = $stmt->get_result();
// Check if any result is returned
if ($result->num_rows > 0) {
// Fetch the data
$row = $result->fetch_assoc();
// Return the lot details as HTML
echo “
Lot Number: ” . $row[‘LotNumber’] . “
“; echo “Size: ” . $row[‘SizeSqMeters’] . ” m²
“; echo “Frontage: ” . $row[‘Frontage’] . ” m
“; echo “Depth: ” . $row[‘Depth’] . ” m
“; echo “Residential Code (R Code): ” . $row[‘ResidentialCode’] . “
“; echo “Fire Code (BAL): ” . $row[‘FireCode’] . “
“; echo “Price: $” . number_format($row[‘PriceInDollars’], 0) . “
“; echo “Availability Status: ” . $row[‘AvailabilityStatus’] . “
“; } else { // Return a message if no lot found echo “No lot found for this number in Seven Oaks Estate.
“; } } else { // Display query execution error echo “Query failed: ” . $stmt->error . “
“; } // Close statement $stmt->close(); } else { // Display statement preparation error echo “Error preparing the SQL statement: ” . $conn->error . “
“; } } else { // Display message if no lot number is provided echo “No lot number specified.
“; } // Close the connection $conn->close(); ?>