Pass prompt variable through to mysql query

[aikorei]

I'm not sure if this is the right place for this, but since php is sort of the hub I figure this might work.

 

I'm struggling with finding the right way to snag a variable from a javascript prompt and pass that through to the server for a mysql query. I'm relatively new to all of this, so any help (even the obvious stuff) would be greatly appreciated. Here's my situation...

 

I'm using a scheduling plugin on Wordpress that allows users to schedule an appointment with a service provider. Unfortunately, these appointments are for a set duration (e.g. 30 minutes). I'd like to allow the user to select their start time and then set their own duration.

 

The plugin uses jQuery to display a calendar in table format and the user can click on a date/time that works for them. Then a new <div> appears on the page to confirm the appointment.

 

I would basically like to insert a javascript prompt when the user clicks on their starting time that asks for the duration in hours. I need to pass this value back to the server (using jQuery or Ajax I'm guessing?) so I can send a query to the database and check if this time conflicts with other appointments, then continue with the confirmation <div>.

 

I've spent probably 2 or 3 hours searching Google and I'm simply not finding a way to do this. Seems like it should be straightforward, but the answer is eluding me.

[gristoi]

Use jquery to listen to the click event of div holding their starting time, dont use a promtp, use a dialog ( google jquery dialog ). Using that when the user has selected their duration and hit submit, you can shoot off an ajax call to a php script. That will take in the variable as a GET | POST variable and insert into db

[aikorei]

The confirmation <div> is already assigned to .click()... if I assign another jQuery piece to the same .click() action, wouldn't they both fire at the same time?