如何自动生成电子邮件脚本，以便在PHP到期日之前将邮件发送到客户端？

Question

I am new to php.I am in need of a script where the reminder must be sent to the client and also to me about the expiry of the website.

The mail should be sent first 60 days before the expiration date. later on 30 days,15 days,7 days and their after continuously till it has been renewed. Also the client name,email id must only be sent to me through email.

I am in need please help me.

Thanks in advance.

Answer 1

Well, you will need to store if you already sent an email that day, but other then that

SELECT DATEDIFF( CURDATE( ) , expire ) AS daysleft, id, user, email
FROM something WHERE 
daysleft='30' 
OR daysleft='60' 
OR daysleft='15'
OR daysleft='7'

something along this line could work, then you say like You have $data->$daysleft left.