How to create a booking calendar | php mysql | Part 2

Buy me a cup of coffee.

This is part 2 of our "How to create a booking calendar" series.
In this part we have added navigation to change months and return back to current month.

We also created a small form which is connected to mysql database to make and save a booking.

Then we connected our calendar to the booking mysql database to check for existing bookings for that particular month, and if there is no booking, we show a green book button which on clicks takes you to the booking form and if there's a booking exist on that day, we show the Book button as Already Booked.

Check out our Doctors Appointment Online Booking System at

source code:

keywords:
calendar
php
booking
mysql
events
booking calendar
how to create a calendar in php
how to develop calendar in php
php booking calendar
php calendar tutorial

[MonirulIslam-sgoh]

Hello, did you skip? from part 1 to 2 not matching the output . In part 2 it seems something already build but you did not shown

[Alfisd]

Hi im at 5:20 and i have the buttons but the calendar does not change from the current month although the url does increase +1 or -1 if the button is clicked but only one click, are you able to help me as i cant workout at this early point for the calendar not to change?? many thanks

[atlesund]

Hey, I really enjoyed the booking system. Is there a way to add different times to the day

[anasarain]

$stmt-> bind_param('ss', $month, $year); it's gives the uncaught error

[mordantish]

Thank you for this excellent tutorial.

Has anyone come up with a solution as to why the month buttons won't switch between months at all? I've gone through the source code several times, but haven't detected why this keeps happening.

[thilankamadhuranga]

Hello in your 2nd video mktime function in line no 31 is not working. Previous or next month. In url it is changing.

[geethhashan]

Date is not fetched from the calender to the form. If there's any reason for this let me know

[AbhishekSharma-reey]

hello sir ...sir mera previous month or next month wala calendor nhi open ho rha h ..qry string mai pass ho rha h pr..current calendor hii show ho rha h bs

[kidstimehome]

Hi, is a very good code, but the las 3 days (numbers) of the week are out of the calendar, how could I fix that?
Thabks

[tehweichuan]

Hi, I follow all your codes, but the previous and next buttons still cannot work, may I know why?

[napsterking]

Hi please notice me i downloaded your php calendar a months ago and the design of it doesnt work anymore today what's wrong in the code or file? plss help 😭

[paulakula]

Help please...The calendar is not showing when i insert the code to make a connection to the database & querying the bookings table to select the date. Btw this is a cool calendar app.

[GigiValdez-ly]

Can you booking Calendar both user and admin is can edit the day for example admin disable of that day because admin is unavailable on that day. The user is book The availble day in the calendar and receive it by admin can you do that bro? 🎉

[mathenraj]

Bro i dont know why but when click next month button its showing the current month. Example from april it should jump to May when the next month button is clicked but in my case its just stucked and showing the same month .

[dashwinderkaurjarnailsingh]

i have a problem to insert the booking details in the database it is not showing the booking is successful..

[ferlandomkiva]

my code does not execute the following code:

if(isset($_GET['date1'])){ $date = $_GET['date1'];}

[harristylissanakis]

Hello and thanks for the help, could you please reupload the .sql file beacause you deleted it from google drive and we are not able to download it. Also in part 3 you skip the process of creating the timeslot column... please help

[casperroskr]

so i got it all workign and such. But i am struggling with finding a way to translate the months to my language Danish. since it uses mktime and getdate i thought setlocale(LC_ALL, 'da_DA'); Would do it but it will not change when it lists the current month

[ankitchoudhary]

I am unable to make the previous and next month working though the month value is changing in URL one time but not on screen.

[domgee]

Hi Chef, 1st of all thanks for this tutorial, I finally got it all and it improved my know how in a huge way. What my problem is now, that the calendar is 1 od many pages which already are having a style.css. How can I get my old style back? instead of !important por ex.