Member Avatar for lifeworks

Hi

The case scenario is this;

a website allows people to book rooms on certain dates. I would like the website to email clients 7 days before their booking date to remind them that they have made this booking... how do i get my website to do this automatically?

Thanks

lworks

  • 3 Contributors
  • 4 Replies
  • 99 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by Shanti C
Member Avatar for Shanti C

hello..

you just add 7 days to your user booked date by using DATEADD function in mysql...
and compare that date with CURDATE ,then if condition is ok,write mail function to remind them ...

Member Avatar for lifeworks

Hi, thanks for getting back to me - i understand the maths of working out the date, but how do i get my website to do this, without any specific prompt (button clicks etc) from me...

Thanks

Member Avatar for vicky_rawat

Hi,

Schedule you page in window schedular and it will run automatically.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.