As someone who is new to PHP, I have a question. How can I set up a date range filter? I've looked at tutorials, but they haven't worked for me.
I do have some code, but it doesn't include any functions. I want to implement this in a CRUD table.
<form role="form" action="index.php" method="get">
<div class="form-group">
<input placeholder="Filter From" class="col-sm-2" type="text" id="from" name="from">
<input placeholder="To" class="col-sm-2" type="text" id="to" name="to">
<input style="padding-bottom:0px" class="btn btn-default" type="submit" name="go" value="filter range">
</div>
</form>
and for the date picker, I use the following code.
<script>
$(function(){
$("#from").datepicker({
defaultDate:"+lw",
changeMonth: true,
numberOfMonths:3,
onClose:function(selectedDate){
$("#to").datepicker("option","minDate",selectDate);
}
});
$("#to").datepicker({
defaultDate: "+1w",
changeMonth:true,
numberOfMonths: 3,
onClose: function(selectedDate){
$("#from").datepicker("option", "maxDate", selectedDate);
}
});
});
</script>
The PHP table where I want to implement this looks like this:
<?php
$connect = mysqli_connect("localhost", "root", "root", "appointments");
$output = '';
$sql = "SELECT * FROM appointments ORDER BY id DESC";
$result = mysqli_query($connect, $sql);
$output .= '
<div class="table-responsive">
<table class="table table-bordered">
<tr>
<th>Select</th>
<th width="10%">Id</th>
<th width="40%">Name</th>
<th width="40%">Email</th>
<th width="40%">Address</th>
<th width="10%">phoneNumber</th>
<th width="10%">appointmentTime</th>
<th width="10%">appointmentDate</th>
<th width="50%">message</th>
<th width="10%">delete</th>
</tr>';
if(mysqli_num_rows($result) > 0)
{
while($row = mysqli_fetch_assoc($result))
{
$output .= '
<tr id="'.$row["id"].'">
<td><input type="checkbox" name="id" value="'.$row["id"].'"></td>
<td>'.$row["id"].'</td>
<td class="name" data-id1="'.$row["id"].'" contenteditable>'.$row["name"].'</td>
<td class="email" data-id2="'.$row["id"].'" contenteditable>'.$row["email"].'</td>
<td class="address" data-id2="'.$row["id"].'" contenteditable>'.$row["address"].'</td>
<td class="phoneNumber" data-id2="'.$row["id"].'" contenteditable>'.$row["phoneNumber"].'</td>
<td class="appointmentTime" data-id2="'.$row["id"].'" contenteditable>'.$row["appointmentTime"].'</td>
<td class="appointmentDate" data-id2="'.$row["id"].'" contenteditable>'.$row["appointmentDate"].'</td>
<td class="message" data-id2="'.$row["id"].'" contenteditable>'.$row["message"].'</td>
<td><button type="button" name="delete_btn" data-id3="'.$row["id"].'" class="btn btn-xs btn-danger btn_delete">Delete This Row</button></td>
</tr>
';
}
}
else
{
$output .= '<tr><td colspan="10">Data not Found</td></tr>';
}
$output .= '</table>
<div align="center">
<button type="button" name="delete" id="delete">Delete</button>
</div>
</div> ';
echo $output;
?>