laravel - Auto edit MySQL data after a given time

Question

We have a form which is stored in draft mode. That means editing any data or deleting the entire form is possible. The beginning to end process is as follows

• When a person tries to submit the form for the first time, that is stored in draft. (the isDraft column is set to 0)

• The user is redirected to another page where s/he can view the Form id (a generated number), name, a few other details and Edit/Delete options.

• The user can click edit button to edit anything, or even delete the form.

• However this will be allowed till a given date (say 15 days from the first submission date). Once that date is passed, the form can no longer be edited or deleted. In case the form isn't deleted, the isDraft column is set to 1.

Thousands of people can submit the form . So ,it is not possible to do it manually.

Our project is done using Laravel v6.2, but I want a general idea as well .

I can use a trait or ajax on the master page, but that is too risky and also, server inaccessibility can delay the process, and some users may get an advantage.

How to do it?

If there is no concrete answer, but rather only discussion , I will remove this post

question from:https://stackoverflow.com/questions/65952785/auto-edit-mysql-data-after-a-given-time

Answer 1

Not sure if I understand it correctly, but I think you like to update the updated_at timestamp automatically. You can run through the Eloquent Models by create a command and just call the save Method on them.

$model->save()