Using less than calculation in PHP and MySQL

Question

I have three dates to compare:

$pDate = date("d/m/Y G:i A");
$lDate = new DateTime('last wednesday G:i A');
$cDate = new DateTime('next tuesday G:i A');

If $pDate is in between $lDate and $cDate then mysql table field is updated yes

i.e. the 9th is in between the 8th and 14th

If $pDate is less than equal to $lDate then MySQL table field is updated no

$pDate cannot be more than $cDate

How would I write a elseif statement for the above? i.e.

elseif ( .... ) {
    mysql_query("UPDATE ... SET ... WHERE ...");
}

Community · Accepted Answer · 2017-05-23 12:09:11Z

1

if ($lDate < $pDate && $cDate > $pDate) {
 // do table insert or update here
} else {
 // date is not in desired range.
}

php date compares like a number.

Heres a post you should look at. How to Compare Dates in php?

CommunityBot

11 silver badge

answered Dec 9, 2010 at 5:16

Gauthier

1,32910 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

thanks! so it works even if my date is in the UK format dd/mm/yyyy?

I am not sure on that, I am reading the other post as I haven't tried that before. ( my guess is yes )

Chandresh M · Accepted Answer · 2010-12-09 05:31:00Z

0

you can try IF ELSE condition in the MySQL query. try this to solve your problem, let me know if you dont.

answered Dec 9, 2010 at 5:31

Chandresh M

3,4932 gold badges26 silver badges48 bronze badges