PHP中的Foreach循环 - 全部或全部

Question

In a foreach loop, say I wanted to do the following

foreach($items as $item)
{

  // charge a user for purchasing an item - IS BEING DONE THROUGH AN API CALL WITH STRIPE
  // ie: \Stripe\Charge::create(...);

  // save some info to a database
  // using Laravel for this project so this is within a DB::transaction(...);


  // send a notification email to the buyer
  // Emails are being queued to avoid slowing down the request
  // ie: Mail::queue(...);
}

I would like an all or nothing situation to occur. For example, if an error occurs during the iteration, then NONE of the items are charged, no information is saved to the database, and the buyer does not get a notification email. However, if the foreach loop successfully iterates over each item, then charge the user, save info to database, and send notification email. How do I do this?

Answer 1

I would recommend using Transactions and notifying the buyer at the end.

Mysqli Example:

$dbConn->begin_transaction();

try{

    foreach($ítems as $item){
        //Whatever you are going to do
    }

    if($dbConn->commit()){

    //Notify buyer about all the transactions, the user doesn't receives the notification unless the commit was succesful

   }

catch(Exception ex){
    $dbConn->rollback();
}

Additionally you could verify the return values of the mysqli functions, I Just wanted to focus on the transaction use.