I have two process I need to automate.
(1) I need to populate my dbase with an entire month of appointments (rows). Each day has multiple appointments and each week is the same (I have the same appointments EVERY Monday).
(2) Every day, I need the appointments for the next day to be updated as "filled" (a field in my table that specifies the appointment is unavailable) so that I don't get appointments scheduled last minute. So today for example, the appointments for tomorrow would be marked as filled.
What would be the best way to automate these processes?
Best way to automate a mysql query (PHP or ...)
Moderator: General Moderators
Re: Best way to automate a mysql query (PHP or ...)
There could be a few ways to do it. The first thing to do is establish where the information is coming from.
Do you need it to be converted to the database from another source, or are you willing to use an online form to enter all the current info, and collect each future appointment's information to store in the database?
Do you need it to be converted to the database from another source, or are you willing to use an online form to enter all the current info, and collect each future appointment's information to store in the database?
Re: Best way to automate a mysql query (PHP or ...)
I could use a form, I just want it to be easy and convenient. Basically what it boils down to is I have a schedule; that schedule is the same for the next 3 months. So each week, I have available time where people can schedule appointments with me.
I guess I could make a form where I input one week, and make a PHP script that populates that week as well as the rest of the month.
Any other ideas?
I guess I could make a form where I input one week, and make a PHP script that populates that week as well as the rest of the month.
Any other ideas?