Link to home
Start Free TrialLog in
Avatar of karthik80c
karthik80cFlag for United States of America

asked on

how can i make a php scheduler like this?

we are making a scheduler using php. I will explain the execution process with example. If the consultant have these times available.“1:00-2:30, 3:00 -5:00, 6:00-9:00, and 10:-11:45 to make appointment. when a client schedule a 15 minute or a 30 minute appointment then automatically five minutes will be blocked  before and after the appointment depending on if there was available time before and after the appointment fixed by the client. When the client schedules a 1 hour appointment there will be a 10 minute block. If client makes an 30 minutes appointment 3:30-4:00, then the new availability time will be 3:00 -3:25, 4:05 - 5:00. so we will get available time 3.00 to 5.00 is separated into two such 3.00 to 3.25 and 4.05 to 5.00. We have the maximum of 72 available timings per day for each consultant . For each available time we will have two available time when the appointment is fixed in between. Now how could I make a table for this kind of situation to store timing and is there any other way to work around this??
ASKER CERTIFIED SOLUTION
Avatar of Ray Paseur
Ray Paseur
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Vimal DM
Hi,

1.Write whatever the login is need, in a php file
2.Secondly set that PHP file in CRON JOB of the linux hosting server

# crontab -e
00 * * * * /usr/local/bin/php /home/john/myscript.php
*/5 * * * * /usr/bin/curl -o temp.txt http://www.thegeekstuff.com/myscript.php

anything is good for executing the PHP file in cron job ...