如果达到截止日期，laravel php会更新数据库中的所有行吗？

Question

How to update all records in a column every minute?

I have this example:

I borrowed a book at(9/1/2016) and the deadline of my borrowed book is on (9/2/2016), when the deadline has passed and i still didn't return the book after 1 week ill have a total penalty of 7 points. 1 point per day for not returning a book.

For example today is 9/4/2016 my total penalty points is 2 points

borroweddate| deadline | penalty
------      | ------   |---------
9/1/2016    | 9/2/2016 |    2

It's hard to explain sorry please help me.

Answer 1

You can use cron to run your command/script. If you want to schedule your command minutely you can use:

* * * * * php /path/to/your/scriptcommand >> /dev/null 2>&1

For laravel apps you can use laravel task scheduling, but you still need cron to run your command. You can use laravel scheduling minutely with this:

    $schedule->call(function () {
        DB::table('your_table')->update(['table_field' => 'some_value' ]);
    })->everyMinute();