Lengkap

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).

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 [url removed, login to view])

Email Output: $Titel (bold text if possible, $Text (normal text)

Email Sender: $SENDER (from an include file [url removed, login to view])

---------------------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.

Kemahiran: MySQL, PHP

Lihat lagi: sent one, receiver update, define send, database constants, day month year codeigniter, week plus, macro slide month year, month year dropdown date picker jquery, joomla row delete component, vba default day month year, choose month year javascript, javascript listbox day month year asp, php mysql display days selected month year, mysql update array multiple row

Tentang Majikan:
( 19 ulasan ) Kitzingen, Germany

ID Projek: #10097681

Dianugerahkan kepada:

phppiyushrana

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 Lagi

$22 USD dalam sehari
(3 Ulasan)
2.7

16 pekerja bebas membida secara purata $27 untuk pekerjaan ini

onedeepen

Hello, Your requirements can easily be fulfilled by using "Cron Tabs". Please check my reviews. regards, Deepen

$30 USD dalam sehari
(99 Ulasan)
6.6
phpprogramming

Ready to start now. I have great experience in php, mysql, smarty, jquery, css, CakePHP, CodeIgniter, yii, opencart, cubecart, wordpress. [login to view URL] [login to view URL] [login to view URL] ht Lagi

$55 USD dalam sehari
(171 Ulasan)
6.6
$25 USD dalam sehari
(54 Ulasan)
5.2
deepakgoyal92

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.

$30 USD dalam sehari
(13 Ulasan)
4.6
kanyan

Hi , I can do it.I will do it as you [login to view URL] come in chat so we can discuss about project. You will get impressed by my work.I can start work now. Awaiting for response. Thanks & Regards Kanyan (Web Lagi

$25 USD dalam sehari
(33 Ulasan)
4.1
rambanstola

lets start and finnish by tomorrow.. i have already completed similar kind of project last week and this task is very familiar to me

$35 USD dalam sehari
(10 Ulasan)
3.9
ervivekit

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 lik Lagi

$30 USD dalam sehari
(9 Ulasan)
2.8
$30 USD dalam sehari
(6 Ulasan)
3.0
$25 USD dalam sehari
(2 Ulasan)
2.3
jgmez

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,

$23 USD dalam 3 hari
(3 Ulasan)
2.3
radiations3

Hi, I am an experienced web and mobile developer. Here are few sites that I have created. I am only sending you best ones instead of huge list, I can share with you more websites if you are interested in looking int Lagi

$30 USD dalam sehari
(1 Ulasan)
2.0
adnanahmed0599

Hi I am highly interested to do this project. I will make you happy.I don’t need any upfront or milestone payment. Pay me when you will happy. Looking forward. Thanks

$30 USD dalam sehari
(0 Ulasan)
0.0
kumarsuyash94

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 unlim Lagi

$10 USD dalam 2 hari
(0 Ulasan)
0.0
kevingcfcb88

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.

$30 USD dalam sehari
(0 Ulasan)
0.0
garethnel

Hi, I work with PHP and MySQL everyday, so I can help you out quickly. If not FTP, what access can you give me to your file? Kind regards Gareth

$15 USD dalam sehari
(0 Ulasan)
0.0
shakthik92

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 F Lagi

$20 USD dalam sehari
(0 Ulasan)
0.0