I have to display records for specific date.Below Code i tried.I am getting output "0 Results";
$startDate=$_POST['startDate'];//date in format(d-m-y)
$endDate=$_POST['endDate'];//date in format(d-m-y)
include("../db/connection.php") ;
$sql ="SELECT *FROM Emp WHERE empDate BETWEEN $startDate AND $endDate";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["Id"]. " - Name: " . $row["First_name"]. " " . $row["Last_name"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();
}
I have records in my database like this
2016-10-03 2:51:35
2016-10-03 2:53:25
2016-10-04 3:52:30
2016-10-04 4:15:55
I founded question on stackoverflow get values from table only for a specific day in mysql but that query is not working for me.Would you help me in this?