Can I Display DB Info Based on the Selected Date?
I have created a form using php,html and mysql.Now when I select a particular date in the form how to display the contents of that day visible?For example I have a calendar when I select a particular date I want to display all the details..How?
Thank you for your question on database information displayed according to date. If your database tables have a date column, you can create a query that pulls information according to the date selected by calendar date. This would be in the WHERE portion of your query.
An simple example would look like this:
SELECT * FROM Orders WHERE OrderDate='2008-11-11'
Like this Question? Tweet
Related ArticlesCreate a Database Diagram in MySQL Workbench
What are Database User Privileges?
How to Create a MySQL Database Using the cPanel API
How to Create a Database Using MySQL from the Command Line
How to View MariaDB databases in SSH