A php function - retrieval ban for present and future?

[samanj]

Hi,

 

I have made a database linked with php that I use a html form for.

The HTML form requests a particular date to retrieve, and the php form it is linked to then retrieves data from the MySQL database from that date.

 

My question is: I want there to be a restriction so that the retrieval can only be for dates before the present date (and certainly not any date in the future).

 

e.g. if it is 6th July 2020, then the database can only retrieve from the 5th July 2020 and before. (7th July 2020 onwards also is not allowed.)

Is there a way I can do it? Anyone who can guide me to a particular code function or something of that sort - I would be deeply grateful as my searches have not come up fruitful.

Edited July 10, 2020 by samanj
clarity

[gw1500se]

if( strtotime($database_date) <= strtotime('now') ) {
...

Make it just < if you want to exclude today as well.

[Phi11W]

At it's most simplest, your solution is called an "If statement". 

The HTML page loaded into the User's browser submits data to your PHP for processing.  As as essential part of that processing, you should validate the supplied data values against your chosen criteria. 

In this case, they need to enter a valid [Character Representation of a] Date that must be earlier than the current date.

If the supplied data does not match your criteria, then you send error back message(s) that the HTML (or Javascript) has to show to the User.

Regards, 
   Phill  W.

 

[Barand]

Restrict your db query with a where clause so you only retrieve the records you want

SELECT ... WHERE datecol BETWEEN input_date AND CURDATE() - INTERVAL 1 DAY

 

Edited July 13, 2020 by Barand

[StevenOliver]

After years of fighting with my server's time zone (shared hosting),  I now have these lines of code on my PHP date page (thanks to Barand):

date_default_timezone_set('America/Los_Angeles');
$date = new DateTime();

After you implement the suggestions posted above, these two lines of code on your PHP page(s) will save you the aggravation of wondering why your PHP / mySQL seems to always be off by an hour or two :-)

[samanj]

Thanks all, I will try it out and will reply once successful.