This query is a part of the main query where Date search is applied along with other columns search. Here is the full query
SELECT * FROM table_name WHERE name LIKE '%John%' AND DATE BETWEEN '2017-03-02' AND '2017-03-11'
So we can replace WHERE with AND based on our requirement.
Using backend PHP Script
Usually the query is used in backend PHP script to handle records in a database. For this our form should submit data to backend script and query to be generated based on these data.
$dt1=$_POST['dt1'];
$dt2=$_POST['dt2'];
if(strlen($dt1) >5){ // if from date is filled
$date = new DateTime($dt1);
$dt1=$date->format('Y-m-d'); // To match MySQL date format
$sql= " AND dt >='$dt1' " ;
}
if(strlen($dt2) >5){ // if to date is filled
$date = new DateTime($dt2);
$dt2=$date->format('Y-m-d'); // To match MySQL date format
$sql= " AND dt <= '$dt2' " ;
}
if(strlen($dt1) >5 and strlen($dt2>5)){ // if both dates are filled
$sql= " AND dt between '$dt1' AND '$dt2' " ;
}
$sql=preg_replace("/AND/","WHERE",$sql,1); // Remove first AND with WHERE
Now above code can be joined with our main Query like this.
if compare two dates that particular values is changed on rows and column by using stored procedure and displayed on gridview using C# with example and explaination
DR NIKHIL KUMAR GHORAI
14-02-2017
how to execute the statement and show data in a table injsp