I'm creating a filter button on my SQL query. I have a form where a user can insert a date and then a button after it. Whenever a user clicks this button it only searches for that date in the table. I've created all this but it's not working.
It's not giving me an error or anything..
$mysqli = mysqli_connect("localhost", "root", "", "urenregistratie");
The button doesn't do anything. This is what I have:
<body>
<div class="form">
<p>
<a href="dashboard.php">Dashboard</a> | <a href="view.php">Projecten inzien</a> | <a href="logout.php">Loguit</a>
</p>
<h2>Projecten:</h2>
<table width="100%" border="1" style="border-collapse:collapse;">
<thead>
<tr>
<th><a href="overzicht.php?sort=gebruiker">Gebruiker</a></th>
<th><a href="overzicht.php?sort=projectname">Project naam:</a></th>
<th><a href="overzicht.php?sort=aantaluren">Aantal uren</a></th>
<th><a href="overzicht.php?sort=datum">Datum:</a></th>
</thead>
<tbody>
<?php
//SORT BY ASC OR DESC
$sel_query="SELECT * FROM uren";
if ($_GET['sort'] == 'gebruiker') {
$sel_query .= " ORDER BY gebruiker";
}elseif ($_GET['sort'] == 'projectname') {
$sel_query .= " ORDER BY projectname";
}elseif ($_GET['sort'] == 'aantaluren') {
$sel_query .= " ORDER BY aantaluren DESC";
}elseif ($_GET['sort'] == 'datum') {
$sel_query .= " ORDER BY datum";
}
$result = mysqli_query($mysqli,$sel_query);
while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td align="center"><?php echo $row["gebruiker"]; ?></td>
<td align="center"><?php echo $row["projectname"]; ?></td>
<td align="center"><?php echo $row["aantaluren"]; ?></td>
<td align="center"><?php echo $row["datum"]; ?></td>
</tr>
<?php } ?>
</tbody>
</table>
<form name="filter" method="POST" action="overzicht.php">
"<input type="hidden" name="uid" value="<?php echo $uid; ?>">
SHOW POSTS FROM:
<input type"date" name="date">
<input type="submit" name="submit" value="Filter">
</form>
<?php
//FILTER BUTTON
if (isset($_POST['submit'])) {
$uid = $_POST['uid'];
$date = $_POST['date'];
$filter = "WHERE DATUM(post_date) IS '$date'";
$query = "SELECT * FROM uren $filter";
$respost = mysqli_query($mysqli, $query);
} else {
$query = "SELECT * FROM uren";
$respost = mysqli_query($mysqli, $query);
}
?>
</body>
