Small PHP/MySQL Cron Job

I have a Thyme calendar installed which controls booking information for a client. Clients book meeting rooms using the calendar and they're inserted into the database as "tentative" bookings until a deposit is received.

My client would like to automate the process of removing bookings that are not confirmed with a deposit so I need to write a small cron job to do it with the following requirements:

- I would anticipate running the job probably once per day. I would simply like it to query the database, select any events which are still tentative 7 days after they were booked, and change their type to "cancelled". I'd also like the job to then send the calendar owner an email telling her the number of events that were cancelled, as well as the corresponding dates and titles of the events that were cancelled.

- Each event has it's own table row with a unique ID for each event, an "etype" field storing the event type, "title" for the event title, and "added" which is the date the booking was added to the database (stored as a unix timestamp) - so all the information to do the job is already in the database.

- I would like the ability to change the 7 day period easily just in case the client's needs change down the track. No problem for me to edit the code manually though, I don't need any fancy front ends or anything like that.

I would anticipate this is a fairly quick and easy job for an experienced PHP/MySQL coder, but I don't have the time to learn right now so I'm throwing it out there for someone a bit smarter than me to have a go.



Skills: PHP

See more: mysql cron job, mysql cron, mysql cron jobs, cron jobs mysql, cron php mysql, cron job mysql, cron php mysql problem, mysql query cron, schedule cron job php, cron mysql query, cronjob mysql query, php cron events, write my own book, tentative event, someone write my book for me, so ben, small it job, s controls, rooms to go, php per, php owner, php mysql job, php code for calendar, learn go, job titles

About the Employer:
( 1 review ) Norwood, Australia

Project ID: #248611

Awarded to:


Hi please check pmb for details

$30 USD in 1 day
(166 Reviews)

11 freelancers are bidding on average $32 for this job


Hi, please, check your PM

$30 USD in 0 days
(329 Reviews)

Can start to work immediately. Regards Bo Zhang

$30 USD in 0 days
(272 Reviews)

Hello, I can deliver Your project in a few hours. Please check PMB for more details.

$30 USD in 0 days
(30 Reviews)

Hello, please check PM for details. Thanks -Omar

$50 USD in 1 day
(10 Reviews)

Can do it right away..

$30 USD in 1 day
(14 Reviews)

Can be done in 1 hour, Please contact me. Thanks.

$30 USD in 0 days
(5 Reviews)

Hello I have similar project also and I have experience in cron jobs. I can make similar script in one day. Cheers

$30 USD in 2 days
(1 Review)

Can be done today. NP Mike Thomas TheLabWeb

$30 USD in 0 days
(5 Reviews)

i think i know as much php as i need to solve this problem

$30 USD in 0 days
(2 Reviews)

I can do this job for you, i am experienced in php programming

$30 USD in 7 days
(0 Reviews)