<!DOCTYPE html>
<LINK HREF="style.css" REL="stylesheet" TYPE="text/css">
<html>
<?php
include "database.php";
include "autos.php";
$db = new dbconn();
$conn = $db->getDb();
mysqli_select_db($conn, "autos");
$sql = "SELECT * FROM autowbshp";
if (isset($_POST['submit'])) {
$maxprijs = $_POST["maxprijs"];
$minprijs = $_POST["minprijs"];
if ($_POST['minprijs'] == "") {
$minprijs = 0;
}
if ($_POST['maxprijs'] == "") {
$maxprijs = 999999999999999;
//2147483647
}
$merk = $_POST["select"];
if ($_POST['select'] == "Kies een merk") {
$sql = "SELECT * FROM autowbshp WHERE autoprijs <= '{$maxprijs}' AND autoprijs >= '{$minprijs}'";
} else {
$sql = "SELECT * FROM autowbshp WHERE automerk = '{$merk}' AND autoprijs <= '{$maxprijs}' AND autoprijs >= '{$minprijs}'";
}
}
$result = $connection->query($sql);
?>
