How to get data from the database between two dates in PHP & MySQL

(PHP Gurukul) In this tutorial, we will learn how to get employee data between two dates in PHP from the database. Below is the step-by-step procedure.

https://phpgurukul.com/wp-content/uploads/2022/07/bwdatesinphp-300x177.png 300w, https://phpgurukul.com/wp-content/uploads/2022/07/bwdatesinphp-768x454.png 768w, https://phpgurukul.com/wp-content/uploads/2022/07/bwdatesinphp.png 1327w" alt="bw dates data in PHP" width="1024" height="606" />

Step1: First create a database with name “betdb” where employee data is stored.

Step2: Second is to create a table with the name “tblempdata” and insert the employee data.

CREATE TABLE `tblempdata` (

`ID` int(5) NOT NULL,

`EmployeeName` varchar(200) DEFAULT NULL,

`Department` varchar(200) DEFAULT NULL,

`Email` varchar(200) DEFAULT NULL,

`MobileNumber` varchar(200) DEFAULT NULL,

`EmpID` varchar(200) DEFAULT NULL,

`JoiningDate` date DEFAULT current_timestamp(),

`PostingDate` timestamp NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Step3: Create a database connection file and save this file with the name “config.php”. Below is the code of databse connection.

<?php

$con = mysqli_connect("localhost","root","","betdb");

// Check connection

if (mysqli_connect_errno())

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

Step4: Create a form with two fields which is “from date” and “to date”

<tr>

</td>

</tr>

<tr>

</tr>

<tr>

<button class="btn-primary btn" type="submit" name="submit">Submit</button>

</tr>

</table>

</form>

Step 5: PHP code for fetching data from the database on the basis of from & to dates.

<?php

if(isset($_POST['submit']))

{

$fdate=$_POST['fdate'];

$tdate=$_POST['tdate'];

<h3 style="padding-left: 100px;color:blue">Report from <?php echo $fdate?> to <?php echo $tdate?></h3>

<hr >

<thead>

<tr>

<th scope="col">Employee Name</th>

<th scope="col">Department</th>

<th scope="col">Mobile Number</th>

<th scope="col">Email</th>

<th scope="col">Employee ID</th>

<th scope="col">Joining Date</th>

</tr>

</thead>

<?php

$ret=mysqli_query($con,"select * from tblempdata where JoiningDate between '$fdate' and '$tdate' ");

$num=mysqli_num_rows($ret);

if($num>0){

$cnt=1;

while ($row=mysqli_fetch_array($ret)) {

<tbody>

</tr>

<?php

$cnt=$cnt+1;

} } else { ?>

<tr>

<td colspan="8"> No record found against this dates</td>

</tr>

<?php } }?>

</tbody>

</table>

Here is the full code that we have written for this tutorial

Download Script

Download Now

How to Run the Script | PHP Gurukul

1. Download the zip file

2. Extract the file and copy bw_dates _script_php folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/HTML)

4.Open PHPMyAdmin (http://localhost/phpmyadmin)

5. Create a database with the name betdb

6. Import betdb.sql file(given inside the zip package in the SQL file folder)

7. Run the script http://localhost/bw_dates _script_php

Blog