Completed

Build a two-part form with MySQL and PHP

This project was successfully completed by sam45 for $80 CAD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 CAD
Completed In
1 day
Total Bids
12
Project Description

There are a couple of ways of doing this: one strictly with PHP, the other by using jQuery to trigger ajax. Either method is ok with me.

I have a registration form which takes the person's personal information and stores it in a table on a MySQL database. There is a field that offers people the opportunity to sign up for a consultation appointment. There are two appointments available for each time slot. When someone chooses '11:00' on this form, this information needs to be submitted to the database. If someone has already signed up for one of the appointments at 11:00, a message saying 'Only one appointment left!' needs to show up beside the 11:00 option. If two people have already signed up for this time slot, 11:00 would no longer show up as an option at all.

Time slots are as follows:
11:00
11:20
11:40
13:00
13:20
13:40
14:00
14:20
14:40
(again, two appointments may be booked for each time slot)

I require all MySQL coding to be in the mysqli format. I can show you the code I have so far, and how I would like to integrate this into things (at present, there is a single-page form with consultation choices, but nothing that shows if someone has already chosen this time slot).

Thanks,
Coleen

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online