Off Topic

3 replies to this thread. Most Recent

hugh

13 Jun 2008, 12:23 am

course reservation

Anyone know of a course reservation software/script that I might use? Have an adult educational establishment which wants people to be able to book courses online. Not sure whether they want folk to pay online too, but possibly.

Obviously could use a shopping cart system like Mals linked to some Freeway generated course details and a ‘reserve’ button, but Mals cart is rather obviously a shop cart with £.s.d etc. so wondered if anyone knew of a bespoke script for thius kind of thing? I’ve had a look around hotscripts but can’t see much.

One of the things needed is an inventory/stock reducer…i.e. there are 20 course places available, this needs to be updated when a person reserves the course until all places are ‘bought’ and the course is full.

Any ideas or offers welcome!

cheers Hugh

quote

waltd

13 Jun 2008, 1:04 pm

I thought this would be one of those well-solved problems, but a few minutes’ research at HotScripts failed to turn up even one example. On Jun 12, 2008, at 8:23 PM, hugh wrote:

Anyone know of a course reservation software/script that I might use? Have an adult educational establishment which wants people to be able to book courses online. Not sure whether they want folk to pay online too, but possibly.

Building the list of courses, and checking “seats” off an inventory per class, would be a good starter project for someone trying to learn PHP/MySQL coding.

Adding commerce to this would not, however, although there may be some way to integrate the Mals cart into the process. I recommend baby steps here. If you would like some basic information about setting this up in code, please do ask.

Walter

quote

Freeway user since 1997

www.walterdavisstudio.com

ScottSimons

13 Jun 2008, 1:15 pm

not sure if you want to use a third party, but this is quite nice www.eventbrite.com

On Fri, Jun 13, 2008 at 6:04 AM, Walter Lee Davis wrote:

I thought this would be one of those well-solved problems, but a few minutes’ research at HotScripts failed to turn up even one example. On Jun 12, 2008, at 8:23 PM, hugh wrote:

Anyone know of a course reservation software/script that I might use? Have an adult educational establishment which wants people to be able to book courses online. Not sure whether they want folk to pay online too, but possibly.

Building the list of courses, and checking “seats” off an inventory per class, would be a good starter project for someone trying to learn PHP/MySQL coding.

Adding commerce to this would not, however, although there may be some way to integrate the Mals cart into the process. I recommend baby steps here. If you would like some basic information about setting this up in code, please do ask.

Walter

Scott

quote

Back to Top

hugh

13 Jun 2008, 1:45 pm

Hi Walter,

Yes, I was surprised there was nothing at hotscripts. As you say, probably not a massive project for someone who knows their PHP/MySQL. Unfortunately I haven’t the time to learn and will be looking for a third party solution or someone who can code this for me (with an eye to integration in Freeway).

So yes, I’m asking about the basic information for setting up this code ;)

Initially we wanted to put the courses into a database so that a) staff could add/amend course details, and b) viewers could search/sort courses via criteria.

Once they’ve found a course they want, it would then be good to have a reservation/booking option (maybe online payment, too) which when completed reduces the number of seats left on that course. I have lots of thoughts here, like a seat reduction (inventory) shouldn’t reduce until the course is actually paid for…and other such considerations.

But in the early steps, you’re pretty much bang on about what’s needed.

Welcome your thoughts…and interest in doing this?

Hugh


Hi Scott,

Thanks for the reference. Had a quick look but I think it’s more ‘event’ based as its name implies. Don’t know whether it could be tweaked for courses, suppose I need to trial it and look at the interface. Maybe I should find time for that.

thanks again,

Hugh

quote

FreeCounter