How to make auto update into mysql through php

Question

We have a table in database called validity and update 'inactive' automatically into database when validity will expire by current date

validity_from | validity_to | status
------------------------------------
28-05-2019    | 28-06-2019  | active
------------------------------------

How can i achieve this function in php

Please suggest and help me.

Why do you want to store this redundant information in the first place? The validity of any record can be determined on the fly whenever you read the data. Much less chance of things going sideways, because such an “automatic update” might fail at some point. — 04FS, May 28 '19 at 07:03

score 0 · Answer 1 · answered May 28 '19 at 06:55

0

you can create a cron job that runs in background and update 'status' filed accordingly

answered May 28 '19 at 06:55

Shailendra Gohil

How can i do that. Do you have any references for that? – Rahul Kumar Sharma May 28 '19 at 06:56
check this link hope it will help you `https://stackoverflow.com/questions/18737407/how-to-create-cron-job-using-php ` `https://code.tutsplus.com/tutorials/managing-cron-jobs-with-php--net-19428` – Shailendra Gohil May 28 '19 at 06:58

1 Answers1