PHP Script (One short Page) to send an email when the date in the database matches the actual date and after that update the date (plus one week, one month, one year or delete the row in the database).
$10-30 USD
Completed
Posted about 8 years ago
$10-30 USD
Paid on delivery
I need aPHP Script to send an email when the date in the database matches the actual date and after that, update the date (plus one week, one month, one year or delete the row in the database).
Exactly what I need:
I have an existing table with the following fields
table: hl_reminder
fields:
user_id
remember_id
titel,
text,
email,
date,
remind,
sample data:
user_id, 85
remember_id, 284
titel, MY TITEL
text, MYTEXT
email, REMIND-EMAIL
date, 2016/03/31
remind, weekly (OR) yearly (OR) monthly (OR) onetime
What I need is a php script that sends an email when the field $date from the table hl_remind matches the real date!
Email Receiver: $email
Email Subject: $subject (from an include file [login to view URL])
Email Output: $Titel (bold text if possible, $Text (normal text)
Email Sender: $SENDER (from an include file [login to view URL])
---------------------db.inc-----------------------------------
// Define database connection constants
define('DB_HOST', 'localhost');
define('DB_USER', 'xxxxxxx');
define('DB_PASSWORD', 'xxxxxxxx');
define('DB_NAME', 'dbxxxxxxxxxx');
$subject = "your reminder"; // Email Subject
$sender = "info@xxxxxx"; // Sender Email
----------------------------------------------------------------------
Next (when email is sent)
Update $date when $remind = weekly (plus one week)
Update $date when $remind = monthly (plus one month)
Update $date when $remind = yearly (plus one year)
When $remind = onetime and email is sent, delete the row where $date is the actual date and where $remind = onetime?
I cannot give you ftp-access.
Hello, I have completely understand what exactly you wants , actually i have ready demo that matches with your requirement , please give me message so i will explain you more, what the steps i wiil take to finish this.
$22 USD in 1 day
5.0 (6 reviews)
2.9
2.9
15 freelancers are bidding on average $25 USD for this job
Hi Sir,
I can help you, a simple way to trigger recurrent functions is to use chron jobs, I've a script that we can adapt to suit your needs,
best regards,
I am the best coder in PHP, I have checked your project. I can provide same functions. You will be satisfied. I am working in Wipro company as software engineer.
hello ,I have 6+ year's of quality experience in web development industry, and i have worked on various type's of project's like e-commerce, music , sport's community, web-services and etc. in various php plateform like opencart, wordpress, codeigniter, cakephp and after reading your requirement i found it's very easy and i can give you some quality work within given time period, hire me and i won't disappoint you :)
Hi, I am very interested in your project, please consider my bid and send me the details related to your project. I was paying low prices but will give you the job with the highest quality and will help you edit unlimited free future, I hope you choose me for this job. Thank you
I can complete this script for you. I'm looking forward to work with you. You need to tell me if you want to use PHP Mailer or other library, and if you have a personal Mail server or public.
Hi,
I saw Your requirements. Its very simple task. I guess you understand the working of PHP n MySQL from your Project Prescription. Just few lines of code will do this. I can fix this immediately. and I don't need FTP access. I just send you the code from your Project description.
Thanks in Advance :)