PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
]);
} catch (PDOException $e) {
die("Database connection failed: " . $e->getMessage());
}
$suggested_equipment = [];
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$square_footage = $_POST['square_footage'];
$num_rooms = $_POST['num_rooms'];
// Calculating total BTUs required
// The below values are placeholders and should be replaced with your actual BTU calculation logic
$btu_per_room = 6000; // This value should be determined based on the actual data and calculation logic
$total_btus = $num_rooms * $btu_per_room;
// Fetch the suggested equipment based on the calculated BTUs and number of rooms
$stmt = $pdo->prepare("SELECT * FROM HVAC_Products WHERE rooms_range_min <= :num_rooms AND rooms_range_max >= :num_rooms AND btus_range_min <= :total_btus AND btus_range_max >= :total_btus");
$stmt->execute(['num_rooms' => $num_rooms, 'total_btus' => $total_btus]);
// Fetching all the matching equipment
$suggested_equipment = $stmt->fetchAll();
}
?>
HVAC Equipment Suggestion
Find Your Suggested HVAC Equipment
No equipment found for the given criteria.
Suggested Equipment
| Manufacturer |
Model Number |
Heating Capacity |
Cooling Capacity |
SEER2 |
HSPF2 |
Heating Capacity at Low Temp |
Price |
|
|
|
|
|
|
|
$ |