Laravel的Twilio API

Question

I'm using twilio to send messages to what's app I tested it and it's working. I need help for the message to be send every 1hr if the database table of products have products with status 0.

For instance example if there is products with status 0, a message is sent and if they are still products with status 0 after 1hr message is sent until they aren't products.

Thank you

//Controller

 public function pendingNotification() {
        $products   = Product::where('status', 0)->get();

        if ($products->any()) {
            $sid    = env('SID'); 
            $token  = env('AUTH_TOKEN'); 
            $twilio = new Client($sid, $token);
            $message = $twilio->messages 
                  ->create("whatsapp:[phone]", // to 
                           array( 
                               "from" => "whatsapp:[phone]",       
                               "body" => "Hello, you have pending products" 
                           ) 
                  ); 
        print($message->sid);
        }
    }

Answer 1

I would suggest you to have a look at scheduler on the laravel documentation: https://laravel.com/docs/5.7/scheduling

Your code will look similar to the following:

$schedule->command('analytics:report')
         ->hourly()
         ->runInBackground();