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
waltd
13 Jun 2008, 1:04 pmI 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
Freeway user since 1997
ScottSimons
13 Jun 2008, 1:15 pmnot 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
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
hugh
13 Jun 2008, 1:45 pmHi 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