Click link to create a MySQL data entry
Hello,
I have a PHP class I'm using to create a bookings calendar. It outputs 12 months at a time starting with the current month. Each day of each month is a hyperlink.
I would like to use jQuery to allow users to click a day to mark it as "booked". I am familiar with passing data betwen PHP pages for processing and storage in a MySQL database but these standard forms would need far too much page reloading to be practical.
Is there a way I can pass the property ID and the date the user clicks on via jQuery to my database? Both values are stored in HTTP GET variables. If the update is successful I'd like to change the background colour of the date via a CSS class or similar to show it is booked. Ideally, one click would set the date as booked, another click would clear the booking.
I would really appreciate any assistance and guidance,
Adam