Build a two-part form with MySQL and PHP

Closed

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

Skills: AJAX, Javascript, jQuery / Prototype, MySQL, PHP

See more: build things, mysqli, appointments jquery, jquery appointment, php mysql ajax appointment, jquery ajax message, jquery build, mysql php single page, trigger javascript, jquery format table, time slot, php slot, mysql php jquery table, javascript slot, javascript mysql table, mysql jquery form, php time slots, php jquery ajax form, php mysql jquery sign, jquery php appointment, ajax mysql table php, sign form ajax php, jquery registration form php mysql, jquery php mysql form, form ajax mysql

Project ID: #4931906

Awarded to:

sam45

can do it and start today! please see PM

$80 CAD in 1 day
(92 Reviews)
6.3

12 freelancers are bidding on average $110 for this job

gopalvora

Hi ready to start Thanks

$123 CAD in 3 days
(214 Reviews)
7.1
scriptphp87

Hello Please read more than private message thank you

$206 CAD in 3 days
(89 Reviews)
6.5
yunuscse

I can do it easily using JQuery.

$100 CAD in 1 day
(90 Reviews)
6.4
rajawi9999

****.. 12 YEARS of EXPERIENCE .. **** Hi. Ready to start; I can start right away. Thanks.

$85 CAD in 0 days
(145 Reviews)
6.4
RRStoyanov

Hello, I can do this for you in just couple of hours. Drop me a line if interested.

$115 CAD in 0 days
(74 Reviews)
6.1
bigdognec

Ready to start

$105 CAD in 3 days
(82 Reviews)
5.8
dustafo

I can get this done for pretty quickly.

$100 CAD in 1 day
(90 Reviews)
5.6
neliobuchadas

Hi! I'm interested on the job! I can start right away! Best!

$100 CAD in 1 day
(11 Reviews)
5.4
miraclesolution

ready to start right now..

$155 CAD in 2 days
(13 Reviews)
4.0
praveen458

Hello,I am a javascript and php programmer.I can do this job,please look at my message for the information of similar work I have done. thanks,praveen

$50 CAD in 3 days
(14 Reviews)
3.6
bsiinfotech

hi , we did some good project in php and jquery which you can check in pm thank you

$105 CAD in 2 days
(0 Reviews)
0.0