<form action="verwerken.php" method="post"> Kies een minimumprijs: <select> <option value="10" name="min">10 euro</option> <option value="30" name="min">30 euro</option> <option value="50" name="min">50 euro</option> <option value="100" name="min">100 euro</option> <option value="500" name="min">500 euro</option> </select> <br>Kies een maximumprijs: <select> <option value="10" name="max">10 euro</option> <option value="30" name="max">30 euro</option> <option value="50" name="max">50 euro</option> <option value="100" name="max">100 euro</option> <option value="500" name="max">500 euro</option> </select> <br><input type="submit" name="submit" value="Geef overzicht artikelen"><br><br> </form>
<?php $con=mysqli_connect("localhost","root","","mysql"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $min = mysqli_real_escape_string($con, $_POST['min']); $max = mysqli_real_escape_string($con, $_POST['max']); $result = mysqli_query($con,"SELECT * FROM artikel WHERE Verkoopprijs BETWEEN $min AND $max ORDER BY Verkoopprijs"); echo "<table border='1'> <tr> <th>Artikelnr</th> <th>Verkoopprijs</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['Artikelnr'] . "</td>"; echo "<td>" . $row['Verkoopprijs'] . "</td>"; echo "</tr>"; } echo "</table>"; mysqli_close($con); ?>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)