Search Two Dates In Data Table Using PHP

Submitted by alpha_luna on Wednesday, April 27, 2016 - 12:12.

Good Day!!!

If you are looking for source code in Search Two Dates In Data Table Using PHP then you are at the right place. In this article, we create a simple program that will teach you on how to create searching data use by two dates in PHP/MySQL. Let's begin with this:

Creating our Table

For the first step, we are going to make our database. To create a database:

Open PHPMyAdmin
Create a database and name it as "lms_1".
After creating a database name, click the SQL and kindly copy the code below.

--
-- Table structure for table `user`
--
 
CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `school_number` varchar(100) NOT NULL,
  `firstname` varchar(100) NOT NULL,
  `middlename` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `contact` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `type` varchar(100) NOT NULL,
  `level` varchar(100) NOT NULL,
  `section` varchar(100) NOT NULL,
  `user_image` varchar(100) NOT NULL,
  `status` varchar(100) NOT NULL,
  `user_added` datetime NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

Creating The Form Field

This form field where the user can search data using two dates.

<form method="POST" action="user_log_search.php" class="form-inline">
<div class="control-group">
    <div class="controls">
        <div class="col-md-3">
            <input type="date" style="color:black;" value="<?php echo date('Y-m-d'); ?>" name="datefrom" class="form-control has-feedback-left" placeholder="Date From" aria-describedby="inputSuccess2Status4" required />
            <span class="fa fa-calendar-o form-control-feedback left" aria-hidden="true"></span>
            <span id="inputSuccess2Status4" class="sr-only">(success)</span>
        </div>
    </div>
</div>
<div class="control-group">
    <div class="controls">
        <div class="col-md-3">
            <input type="date" style="color:black;" value="<?php echo date('Y-m-d'); ?>" name="dateto" class="form-control has-feedback-left" placeholder="Date To" aria-describedby="inputSuccess2Status4" required />
            <span class="fa fa-calendar-o form-control-feedback left" aria-hidden="true"></span>
            <span id="inputSuccess2Status4" class="sr-only">(success)</span>
        </div>
    </div>
</div>
<button type="submit" name="search" class="btn btn-primary btn-outline"><i class="fa fa-calendar-o"></i> Search By Date Log In</button>		
</form>

Creating Connection

This PHP source code is our database connection, kindly copy and save it as "dbcon.php".

<?php
mysql_select_db('lms_1',mysql_connect('localhost','root',''))or die(mysql_error());
?>

Our Search Script

This source code will execute after the user set the two dates to search data in the data table.

<?php
$datefrom = $_POST['datefrom'];
$dateto = $_POST['dateto'];
$result= mysql_query("select * from user_log 
LEFT JOIN user ON user_log.user_id = user.user_id 
where user_log.date_log BETWEEN '".$_POST['datefrom']." 00:00:01' and '".$_POST['dateto']." 23:59:59' 
order by user_log.user_log_id DESC ") or die (mysql_error());
while ($row= mysql_fetch_array ($result) ){
$id=$row['user_log_id'];
$user_id=$row['user_id'];
?>

And, this is the output: Result

Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Add new comment

288 views