Best way to automate a mysql query (PHP or ...)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
rbroadwe
Forum Newbie
Posts: 10
Joined: Wed May 06, 2009 5:18 pm

Best way to automate a mysql query (PHP or ...)

Post by rbroadwe »

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?
divito
Forum Commoner
Posts: 89
Joined: Sun Feb 22, 2009 7:29 am

Re: Best way to automate a mysql query (PHP or ...)

Post by divito »

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?
rbroadwe
Forum Newbie
Posts: 10
Joined: Wed May 06, 2009 5:18 pm

Re: Best way to automate a mysql query (PHP or ...)

Post by rbroadwe »

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?
Post Reply