Recurring Courses

xeonman13

Hello,
I have searched the boards and not found something exactly like I need.
Hopefully someone can help me.

I have created a PHP/MySQL Course Scheduling System.
Everything is working fine.

Trainers go in and create a new course for a certain date.

Now I need to add a new feature.
While creating a course (using a different form is OK) we would like the option to create a recurring course, however what this should do is the following:

Trainer adds new course. Selects Monthly or Biweekly.
And selects the end date. During the insert statement, it should create all the classes at that time. So if its a monthly course and the end date the trainer enters on the form is one year from today, it should create 12 courses.

What is the easiest way to accomplish this?

dalecosp

xeonman13;10988268 wrote:
Hello,
I have searched the boards and not found something exactly like I need.
Hopefully someone can help me.

Well, thanks for doing that. Don't stop reading ... it's one of only two ways you'll get smarter and better at PHP.

I have created a PHP/MySQL Course Scheduling System.
Everything is working fine.

Cool. 🆒

Trainers go in and create a new course for a certain date.

So you're familiar with [man]date/man, then? That's 🆒, as you will probably need it again to create your new feature.

Now I need to add a new feature.
While creating a course (using a different form is OK) we would like the option to create a recurring course, however what this should do is the following:

Trainer adds new course. Selects Monthly or Biweekly.
And selects the end date. During the insert statement, it should create all the classes at that time. So if its a monthly course and the end date the trainer enters on the form is one year from today, it should create 12 courses.

What is the easiest way to accomplish this?

I'd use PHP :p

As I mentioned, date() is your friend; see also [man]strtotime/man (an incredibly handy function) --- and to make things recur, I'd suggest a loop of somekind, possible a while().

HTH,