I have a table in the database and I need to do a function to filter by date. I want to fetch the records from a date that has already passed and that I would return the records from the bank table as they were on that day and that I can edit this data on another page. I'm doing in "pure" php without Framework and in mvc standard. Obs: I already have a select that brings me the bank data on a page, I just need a function and know how I get this data from the bank for another day and that the date can be selected at the top of the page, being possible to select any date and show me the records of the selected date on this page.
What do I need?
Practical examples of how to do this function mentioned above.