In Progress

PHP script to be used by cronjob to alter records in MySQL

A simple PHP script to be executed with a cronjob.

The script is to check the MySQL database for records that are 3 days old (or whatever set by the user in the script) and if a record is at the 4th day archive the record by altering a certain field in the record.

The database is for handling licenses. Licenses could be obtained but not activated until users activate them. This part is handled by an existing script.

A license gets activated when a user activates his license (starts using his license). This part is handled by an existing script.

Database might require some alteration, like when an existing record license status changes from 'inactive' to 'active' database should be able to timestamp the activation date in a field. Thus, allowing calculations for 3 days and then de-activate the license by archiving the record.

The script will be used by a cronjob on a unix server on a daily basis, to monitor licenses that are 3 days old (or whatever days is set in script)

Skills: MySQL, PHP

See more: timestamp, database calculations, alter, cronjob daily, mysql users, php script server, mysql date field, mysql record, license script, mysql check, mysql date days, php calculations, day php date, date days php, monitor server status, used, archiving, mysql status, php record, script alter, activation check, script monitor, php mysql script changes, database will used, server status script php simple

About the Employer:
( 2 reviews ) Laval, Canada

Project ID: #1137796

Awarded to:

yvayse01

Can do this script in no time. Check pm

$30 USD in 0 days
(4 Reviews)
2.4

34 freelancers are bidding on average $59 for this job

toinnisfree

quick pro help. ftp and escrow required.

$50 USD in 1 day
(611 Reviews)
8.1
webqueue

We are sincerely read your requirements and are ready to endow with the solution as per your [url removed, login to view] can assure you that with the help of expert development team,we will provide you high level of satisfaction an More

$50 USD in 2 days
(139 Reviews)
7.1
zeke

Ready to start immediately and finish within a hour. Best Regards, Zeke

$30 USD in 0 days
(171 Reviews)
7.1
morff

I'm skilled webdeveloper and administrator with strong knowledge of PHP/MySQL and i will gladly work for you on this project. Please feel free to ask me any question or to send me more information via PM, thanks.

$30 USD in 1 day
(190 Reviews)
6.8
Sphinks

Let's do it now!

$30 USD in 0 days
(88 Reviews)
6.6
mitrasubir

Hi, I can understand your requirement. Please let me know if you have any queries. Regrds KD

$200 USD in 3 days
(38 Reviews)
6.6
shihan033010

Hi i am ready to start and will complete very quickly.

$30 USD in 0 days
(241 Reviews)
6.4
LuigiWidmore

Hi sir , Please check PM. You'll find it interesting. Thank you.

$30 USD in 1 day
(79 Reviews)
6.2
tonykim100

Hello sir! I am ready to start your work right now. Please refer your pmb. Thanks.

$30 USD in 1 day
(115 Reviews)
6.2
garygoog

I am experienced programmer .I can work for you .

$50 USD in 1 day
(54 Reviews)
5.9
jsaman

I'm interested into doing this for you. Regards, John

$60 USD in 3 days
(75 Reviews)
5.6
hemantrps

Hello, I have over 5 years of development experience. I would like to discuss your requirements in further details. Please check your PM. Cheers, Hemant

$30 USD in 1 day
(18 Reviews)
5.6
adibr70

Hello, I can do that. Please check your PMB. Adrian

$30 USD in 3 days
(30 Reviews)
5.5
getndone

Please check pm

$30 USD in 0 days
(42 Reviews)
5.5
mike25

Please check your inbox for some remarks. Regards, Mike

$50 USD in 2 days
(25 Reviews)
4.8
websoft2009

Hello, I am ready to start.

$200 USD in 1 day
(18 Reviews)
4.7
kommandant

check your pm

$30 USD in 0 days
(23 Reviews)
4.8
crazenators

Hi, We have go through the Project requirement and ready to do this project for you. Please check your PMB

$160 USD in 4 days
(7 Reviews)
4.7
smartskill

hi i m a php mysql developer haveing 5 yrs work experience area of experience 1. magento 2. wordpress 3. smarty 4. ajax Check PM for details

$70 USD in 3 days
(6 Reviews)
3.4
hadi2f

Hi, please check your PMB for some details. Thanks

$30 USD in 1 day
(9 Reviews)
3.3