<!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); ?>