Changing Fields in Database

Question

Hi! I created a database with a table of Treinamentos who owns Nome, Validade and Status as fields, but when the current date passes from the expiration date the field status, that is 1 for active and 0 for inactive, need to change to 0.

I’m having difficulties to do this procedure automatically, and I saw that I can do it both in the bank and with php on the web page I’m creating, but I haven’t had success yet. Could someone help me?

Answer 1

You can create a PHP routine for this:

mysqli_query($conn, "UPDATE Treinamentos SET status = 0 WHERE DATE(NOW()) >= Validade");