Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New Coder
    Join Date
    Aug 2007
    Posts
    26
    Thanks
    2
    Thanked 0 Times in 0 Posts

    appointment help

    hello

    i've been asked by someone to help them with their website by creating an apointment bookings system for it, but am not sure where to start.

    what they need is a way for someone to come onto the site and book an apointment at an available timeslot. i was thinking this could be done using php and mysql, but am not sure where to begin.

    they need it so that when someone clicks on a date, all available timeslots are shown, and they can fill in their details and book the apointment, but i'm not sure how to do this. i'm not looking for someone to give me some code, but to help me to:
    a) decide if php/mysql is the best option (it's all i have knowledge of apart from html)
    b) figure out the processes i would need to go through in a step by step way in order to get the code to work.

    can anyone offer me any help?
    thanks

  • #2
    Master Coder
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,456
    Thanks
    8
    Thanked 1,084 Times in 1,075 Posts
    I know this is sort of a lame answer ...

    What you're doing is going to be a huge project for an experienced
    PHP/MySQL programmer. I can only speak for myself that I would
    never do something that large for free.

    With that said, a Google search finds many pre-made scripts...
    some free, some for a fee. Any of them could be customized for
    your particular use, depending on the features you need.

    Here's a list of many options:
    http://www.google.com/search?q=php+a...pt&btnG=Search

  • #3
    New Coder
    Join Date
    Aug 2007
    Posts
    26
    Thanks
    2
    Thanked 0 Times in 0 Posts
    thanks for the speedy response, much apreciated.

    just a couple of quick points here,
    the website isn't for a commercial business, so it isn't overly important to him if i can come up with some sort of work around for him, also he only wants to take appointments for 1 month at a time, and on certain days, so was wondering whether the following would work.

    if i created a php script which he could update once per month with the following months appointment times, and store those in a database, and then have a page which the user would see which has a listbox or some other way of chosing a date along with a "check availability" button, which would then reload the page with records which are not yet allocated (e.g. are blank in the name field), and then allow the user to fill in their details and click book, would this work, or is there a huge flaw that i'm missing.

    obviously security is an issue here, but as long as there is some sort of password/username system in use, would this work?

    thanks for the help
    karl

  • #4
    Regular Coder
    Join Date
    Feb 2007
    Location
    Canada
    Posts
    924
    Thanks
    10
    Thanked 56 Times in 55 Posts
    There are all sorts of Calendar scripts out there already that do exactly what you want. No need to re-invent the wheel.
    Yahoo! Calendar for example might work out of the box by setting the calendar to public. Not sure, haven't used it for awhile.
    The better ones apply the vCalendar format (I think it is) so you can migrate the data between different calendars. Mozilla Sunbird is good, too, and uses that format.
    Last edited by jlhaslip; 10-30-2007 at 10:34 PM.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •