0
I have a table in the database and I need to do a function to filter by date. I want to search the records of a past date and return the database table records as they were that day and I can edit this data on another page. I am doing in php "pure" without Framework and mvc pattern. Obs: I already have a select that brings me the database data on a page, I just need a function and know how to bring this data from the database of the other day and that can be selected the date at the top of the page, it is possible to select any date and show me the records of the date selected on this page.
What I need ?
Practical examples of how to do this function quoted above.
How is the table structure? What have you tried to do?
– user28595
fetch date 7 days before the current php date, Browse data from 1 day to 3 days ago mysql and Get Rows from at least 3 days ago
– rray
My case is another. My table backs up itself at 00:00 every day just by updating the date column to the new day and duplicating the records. It keeps yesterday’s records, only changes the date. It would need to make a query on top of that date column. If it’s the 10th, bring me the records from the 10th. Because I have a function that edits this data, so every day will be modified and create a backup at 00:00.
– K.roy