how to get dates between dates that user inter

Question

How to get all data between to dates (from-dates & to_dates ) that user enter from a html form like. When user enter date like, from (1\1\2019) to (30\1\2019) I want check if that two date between date in MySQL table

I tried :

 $from = $_POST['from'];
 $end = $_POST['end '];
 $sql = "SELECT * FROM  table_name WHERE  '" . $from . "'  between 
  from_date and to_date and '" . $end . "'  between from_date and 
  to_date
  ";

from_date and to_date...col in mysql table

Possible duplicate of [Searching between 2 date](https://stackoverflow.com/questions/17670934/searching-between-2-date) — executable, Jan 16 '19 at 09:02

MorganFreeFarm · Accepted Answer · 2019-01-16T09:55:55.723

2

Here, but you should format $from and $end to correct format

"SELECT * FROM table_name WHERE (date_column_name BETWEEN '" . $from . "' AND '" . $end . "') AND (date_column_name2 BETWEEN '" . $from . "' AND '" . $end . "')"

Where table_name is table you want to SELECT and date_column_name is your date column.

edited Jan 16 '19 at 09:55

answered Jan 16 '19 at 09:04

MorganFreeFarm

3,811
8
23
46

the user inter two date not one ...i want to check the two date that user inter – Hesham Mohmed Jan 16 '19 at 09:49
i have two date_column_name (from and to ) that i want to check – Hesham Mohmed Jan 16 '19 at 09:53
@HeshamMohmed Just add one more check, it's edit, check it and replace with your column names – MorganFreeFarm Jan 16 '19 at 09:56
1

thanks it works .... i try it before and doesn't work but now work fine may i wright syntax wrong ....again thank u :) – Hesham Mohmed Jan 16 '19 at 10:08
Glad to hear it :) – MorganFreeFarm Jan 16 '19 at 10:09

Chanuka Sandeepa · Answer 2 · 2019-01-16T10:06:21.763

1

Try this,

    $from = $_POST['from'];
 $end = $_POST['end '];
 $sql = "SELECT * FROM  table_name WHERE date_column1 >= '" . $from . "' AND date_column2 <= '" . $end . "' ";

edited Jan 16 '19 at 10:06

answered Jan 16 '19 at 09:10

Chanuka Sandeepa

680
6
10

@Hesham Mohmed let me know your progress – Chanuka Sandeepa Jan 16 '19 at 09:17
i have two date_column_name (from and to ) that i want to check from user post – Hesham Mohmed Jan 16 '19 at 09:54
@Hesham Mohmed now have a try – Chanuka Sandeepa Jan 16 '19 at 10:08

JIJOMON K.A · Answer 3 · 2019-01-16T10:30:04.420

1

First you need to convert the input dates in to database date format yyyy-mm-dd

 $from = date('Y-m-d',strtotime($_POST['from']));
 $end = date('Y-m-d',strtotime($_POST['end ']));

 $sql = "SELECT * FROM  table_name WHERE  (date_column_name1 BETWEEN '" . $from . "' AND '" . $end . "')  AND (date_column_name2 BETWEEN '" . $from . "' AND '" . $end . "')";

OR

$sql = "SELECT * FROM  table_name WHERE  (from_date_column >='" . $from . "' AND to_date_column <='" . $end . "')";

edited Jan 16 '19 at 10:30

answered Jan 16 '19 at 09:15

JIJOMON K.A

1,290
3
12
29

the user inter two date not one ...i want to check the two date that user inter ..i convert the input date right – Hesham Mohmed Jan 16 '19 at 09:50
i have two date_column_name (from and to ) that i want to check – Hesham Mohmed Jan 16 '19 at 09:53
@HeshamMohmed I Updated my answer – JIJOMON K.A Jan 16 '19 at 10:30

sanjaya · Answer 4 · 2019-01-17T07:06:49.703

0

Please try this

SELECT * FROM table_name 
WHERE  from_date >='$from' AND to_date <='$end';

or

SELECT * FROM table_name
WHERE from_date BETWEEN '$from' AND '$end' or to_date BETWEEN '$from' AND '$end';

edited Jan 17 '19 at 07:06

answered Jan 16 '19 at 09:11

sanjaya

204
2
4
11

how to get dates between dates that user inter

4 Answers4