how to Run a line of code after 10 minutes of running another line of code in PHP

[bashabi]

I want my application will send a email after 10 minutes of sending another email.

In my application

• A user completes registration with payment
• Application sends the user a payment confirmation email

Now I want to

• send another email 10 minutes After payment confirmation email with welcome tips

Below is the function where for user setup .

 

public function finishUserSetup($Sub){

    if($Sub == 0){
        $subscription = SubscriptionPlans::where('identifier', '=', "Monthly")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "monthly";
    
    } else{
        $subscription = SubscriptionPlans::where('identifier', '=', "Annually")->first();
        $expiry = date('Y-m-d', strtotime('+' . $subscription->months . ' months'));
        $sub_period = "annually";
    }

    $this->expiry_date = $expiry;
    $this->user_type = "SUB";
    $this->subscription_period = $sub_period;
    $this->update();

    $replaceArray = array(
        'fullname' => $this->forename . " " . $this->surname,
        'subscriptionName' => $subscription->name,
        );
    EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

  }

In the above function the last line of code is the one which sends a payment confirmation email to the user which is

EmailTemplate::findAndSendTemplate("paymentconfirm", $this->email, $this->forename . " " . $this->surname, $replaceArray);

I want to execute the following line of code 10 minutes after the above one

 

EmailTemplate::findAndSendTemplate("WelcomeTips", $this->email, $this->forename . " " . $this->surname, $replaceArray);

 

 

How to do that. that is running the last line of code 10 minutes after  

[Barand]

Here's one way.

When you send a payment confirmation write a record (forename, surname, email) to "confirmation" table

CREATE TABLE `confirmation` (
  `confirm_id` int(11) NOT NULL AUTO_INCREMENT,
  `forename` varchar(45) DEFAULT NULL,
  `surname` varchar(45) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `time_confirmed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `tips_sent` datetime DEFAULT NULL,
  PRIMARY KEY (`confirm_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Set up a cron job to run every 5 minutes. This would

SELECT confirm_id, forename, surname, email
FROM confirmation
WHERE tips_sent IS NULL
      AND NOW() - INTERVAL 10 MINUTE > time_confirmed;

foreach record returned

• Send welcome tips email
• UPDATE confirmation SET tips_sent = NOW() WHERE confirm_id = ?

Edited March 10, 2021 by Barand