PHP date calculation and simple MySQL query

I have a MySQL table with about 25k users and growing. A part of those users pay a yearly fee to use our service.

During the first few months of 2013 we used Paypal but later switched to a different creditcard company to accept payments. So we have 2 extra fields in the userDB: PayPalPaidDate and CreditCardPaidDate.

PayPalPaidDate had the date and time in this format: 2013-01-05T06:07:55Z and sometimes also: 18:37:09 Jan 19, 2013 PST. The PayPal API did that.

CreditCardPaidDate has the date and time in this format: 30-05-13 22:41:22 (This is the European standard as in: 30th of May 2013

Both string can be easily converted to Unix timestamps with PHP5 strtotime, I tested that already.

So I need a PHP script which can be run as a cronjob every day which grabs all users who have a certain type of account role (6,7 or 8 are paid accounts) from the MySQL database and then calculates if the paid date was over a year ago. When a year (or more, some account have already expired) has passed it should clear out the paypal and creditcard paid dates in MySQL and reset the account role to roleID 1.

It should then send out an e-mail to that users about this action. (I can supply the HTML and Plain Text for that).

The second thing I need is a script (or all in one script, thats up to the programmer) which sees an account is about to expire in 28 days (4 weeks) and sends out an e-mail to that user saying they need to upgrade or their account will be reset to normal as of date xxxxx. It should do this 4 weeks in advance, 1 week in advance and then 1 day in advance. Users should never get more than 3 emails and the fourth being the expiration e-mail discussed above.

I need to run this script as a cronjob so it's vital that users do not get bombed with emails everytime the script has run. So the script has to check if

If you need more info please contact me!

Taidot: MySQL, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: pst to html, php string to html, send query, mysql query, jan reset, php5 api, simple check date, converted mysql, paypal script api php, date calculation, advance mysql, php api date, check table mysql script, mysql pst, 2013 query, php mysql database query, query text mysql, pst mysql, mysql date days, paypal fee api

Tietoa työnantajasta:
( 1 arvostelu ) Hoofddorp, Netherlands

Projektin tunnus: #5273421

Myönnetty käyttäjälle:


I am very expirienced developer that can do all this job. I will add new field or create additional table in database to make sure that your users do not get more emails than they should. I will need sample database wi Lisää

€100 EUR 3 päivässä
(6 Arvostelua)

33 freelanceria on tarjonnut keskimäärin 158€ tähän työhön


Hi, Here's my bid to implement the solution for you. Let me know if you have any questions before we proceed.

€257 EUR 3 päivässä
(272 arvostelua)

1. Crowd Funding Site In these days we are already near to finish a full CMS based crowd funding site which is a clone of kickstarter but we implemented many unique features in this project to distinguish it from kic Lisää

€190 EUR 3 päivässä
(98 arvostelua)

Hi, I checked your details and almost understand your requirements. Can you please come to chat with me for discussing more with your requirements. Thanks Inspirad

€242 EUR 5 päivässä
(358 arvostelua)

Hello There Greetings of the Day! We have reviewed your requirement and understood it very well. we would like to quote down some sample of our work so that you can have an idea about working proficiency. http: Lisää

€154 EUR 3 päivässä
(240 arvostelua)

i am a skilled mysql and php developer. i can write the cronjob for you to check the expiry dates. i am a skilled mysql and php developer. i can write the cronjob for you to check the expiry dates.

€84 EUR 3 päivässä
(416 arvostelua)

Easy project for me. FTP and Mysql access required for development and setup. Will be completed in 2-3 days. Lets start. Thanks

€155 EUR 3 päivässä
(160 arvostelua)

Hello there, Can you please provide more details about the [login to view URL] will help me adjusting my bid. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON ME. THANKS, AJIT

€210 EUR 3 päivässä
(274 arvostelua)

Hi, We are experts in php/mysql. We have done many projects like this. Ready to start now. Thanks. ..

€105 EUR 3 päivässä
(226 arvostelua)

Hello Sir, Let us finalize this task, Kindly share details and let us finalize this task, We have done some custom complex script. Sir, We are waiting for your kind reply. Kind Regards Team Webicent

€147 EUR 3 päivässä
(38 arvostelua)

HI Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us Lisää

€111 EUR 3 päivässä
(34 arvostelua)

Hello Sir, I am Trinkal Juneja worked on 2K+ custom projects, from custom module to designing template, custom payment integration, Shipping, Import and Export, Customized product module, social media integration, Lisää

€210 EUR 2 päivässä
(148 arvostelua)

Hello Sir, I can complete this work in a day. I'm a PHP/MySQL programmer having more than 8 years experience. I would like to have a long term relationship with you. I'll be always available for making any updates y Lisää

€138 EUR 1 päivässä
(135 arvostelua)

Dear Sir/Madam, I am a 5+ years experienced professional with huge experience in PhP and MySQL. I have written several cron scripts that run almost every minute on the server to perform various things. I am prett Lisää

€111 EUR 1 päivässä
(26 arvostelua)

Hi, I have done similar thing for the website cckmedia. I have created a cronjob for sending emails before 1 week, and on the day and after expiration clearing the data. I can do this task easily for you. Let me kn Lisää

€144 EUR 3 päivässä
(42 arvostelua)

Hi, We have gone through your requirements,we have some clarifications,could you please available for a discussion. We have 9 years of experience,We are experts in Oscommerce, zencart, X-cart, wordpress, joomla , M Lisää

€257 EUR 3 päivässä
(41 arvostelua)

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project Lisää

€190 EUR 5 päivässä
(63 arvostelua)

Hi I am a experienced web developer and Customizer. I would like to offer my services for this job. Regards

€155 EUR 2 päivässä
(151 arvostelua)

I have done exactly similar work in past. I can do this for you rightaway and create and setup the cronjob in your Cpanel. Let me know, if you are interested.

€66 EUR 3 päivässä
(84 arvostelua)

PHP / mySQL expert - I can help build the subscription notification cron job script along with the mass email to users, not a problem.

€315 EUR 7 päivässä
(33 arvostelua)

Dear there, I read your requirement and found that we can do this job easily. As per description I believe you need following things: 1) Check users which has more than a year of payment (check for specific role Lisää

€200 EUR 4 päivässä
(36 arvostelua)