sohailsaif

Dear Barand, I am trying to develop something that, patient don't need to ring doctor, he/she can book the appointment online, If he/she reaches the clinic after specified time then he/she have to wait there for the next available slot.

Thanks Barand for you help, but Can you help me how auto assign time to each patient, suppose starting Time for DR A is 12:05PM, when first patient book his appointment, time 12:05 PM will be automatically assigned to him,/her, when second patient book appointment, then 12:15 PM will be assigned to him.her, for each patient there will be a increment of 10 minutes, how to do this?

Please see the attached image, What I want is when patient will open the the Appointment Registration form, he/she can select doctors from list, select available dates, enter his/her name, address, mobile number and save the form, a booking code will be generated, time will be assigned(starting a time, there will be a increment of 10 minutes for each patient, for example see the appointment_time, row in the appointment table), a booking code will be generated(using doctor id, appointment date and 4 digit number which will be increment 1 for each patient for that selected date and doctor, please see the booking_code in appointment_table). booking code will start if a patient select another date and if there is no appointment, then it will again start from DR001-27-03-2016-0001. Hope you can understand my problem, If I some one can help me with full codes, I will be very thankfull, I am new in PHP, Please Help me.

Can some one help to generate a unique Doctor Appointment ID when some one save the registration form, I am trying to make online doctor appoint booking system, I want something like for each doctor, each date, it will generate a unique id, that may be something like following Dr_ID-Date-Auto increment number( DR001-03-23-2016-0001 ) If any one have better idea to generate a short and unique id, please suggest me. I am a beginner in PHP, please help me guys