1
I have a database in MYSQL where one of the fields informs the status of a particular transaction. For example: status = waiting or status = complete.
I want to do a cron that every 10 minutes takes all clients who are with the status=complete and want to post the returned data to another URL, I will use the same data in another application. I will use Guzzle to send this data, but still do not know how to make the request.
To avoid sending duplicate data, I have the following information in the table, processed=0, as soon as I send the POST and I have a 200 return code, I update the information to processed=1, so the query needs to fetch the data with status=complete and processed=0
I imagine I can do this with foreach, but in some tests here it didn’t work!