Online booking system - any suggestions?

[sitewonders]

Hi all.

New to the forum but hope to become an active member

One of my clients needs a way to manage their bookings. They run a travel company that specialise in taking students to and from airports.

At the moment they are an inbound and outbound request forms that email them the details. They then manually input the details into excel.

I am redesigning their website and I have suggested a web based system to take the data from the form and put it into a web based database that they can view.

They have the following criteria...

When they log in, new bookings should be obvious (highlighted for example)

Should be able to sort data by fields (ie by date or location).

Should be able to email direct from the database (a mailto would be fine)


They do not have a huge budget, but I want to do them a good job as they are really nice guys, so i am ideally looking for a script that can offer these features. I am looking around but I thought I would ask you nice people for any suggestions

Thanks in advance.

Gary
Sitewonders Limited

[saltedm8]

do you know anything about php and mysql because that is what you are going to need, the first rule of website design is never take on a job you cant handle..

a script like that should not take too long to build, but if you dont know either of the above ( php and mysql ) it might take a little longer,

google is your friend, when you have some sort of basic script please come back and ask us how it can be adjusted for your needs

p.s this is not a rant, just basic advice

cheers

[sitewonders]

I am not an expert in either but I have worked with countless php scripts and I am confident in my troubleshooting

Just want a nice easy script so I dont have to spend too long on this one

Many Thanks

Gary

[saltedm8]

a basic script would be a form to database and then a call from the database to display information.

the highlighting of the latest submissions could be done by creating a function to echo colors and fonts if submitted after your last session

( i would have thought your last session could be recorded by the database )

[welshstew]

Not really sure if this will work, but you could search for some open source resource booking systems and then customise it to your needs.

Each "car" would then be booked as a resource and scheduled in for pick up drop off.

As I mentioned not sure if this will work the way you want it to. Anyways, It's all open source, so you can take a look at the solutions and pick out the code that you need.

[sitewonders]

Thanks Guys.

Well I think a simple form to database script that has a simple user interface for the db would be good.

Any suggestions?

Rest assured I am looking around too!

Many Thanks

Gary

[saltedm8]

have a look at this, its just something i built when i was messing about, but it has most the elements you would want ( attached )