Send SMS by PHP

Question

I have a SMS gateway that receives data from my form in this pattern:

<?php
include "smsGateway.php";
$smsGateway = new SmsGateway('[email protected]', 'password');

$deviceID = 1;
$numbers = ['[phone]', '[phone]'];
$message = 'Hello World!';

$options = [
'send_at' => strtotime('+10 minutes'), // Send the message in 10 minutes
'expires_at' => strtotime('+1 hour') // Cancel the message in 1 hour if the     message is not yet sent
];

//Please note options is no required and can be left out
$result = $smsGateway->sendMessageToManyNumbers($number, $message, $deviceID, $options);
?>

I send the numbers, by means of a 'SELECT' from my database, print in an input field and send the form. However, the operator does not allow to send more than 15 simultaneous messages. It would be possible to send one by one, but giving only a SEND in the form?

Answer 1

One way to do this is by creating a loop, and a check by sending status:

1) In your bank’s select, create a field: status_envio with the value 0 by default.

2) Then make a select with the condition: WHERE statust_envio=0 LIMIT 15.

3) For each occurrence of 15 upload, update the status of these records to 1.

4) When no more records are found, enter the end of the process.

5) Place at the end of the script execution loop, the printing of a metatag or a javascript with a timeout.

$timeRefresh = '15'; //15 segundos

$url = $_SERVER['SCRIPT_NAME'];

$result = array();
if (count($numbers)) {
   foreach ($numbers as $key => $number) {
       $result[$key] = $smsGateway->sendMessageToManyNumbers($number, $message, $deviceID, $options);
       if ($result[$key]) {
          $update = $smsGateway->updateStatus($number, 1);
       }
   }
  echo "<meta http-equiv=refresh content=\"{$timeRefresh};URL={$url}\">";
} else {
//e reatualize todo o banco novamente com status = 0 se precisar que esse processo seja repetido toda vez que chegar ao final e precisar enviar a página
  $update = $smsGateway->updateStatus(null, 0);
  echo "Fim dos envios!";

}

OBS: Check method must update status:

public function updateStatus($number = null, $status = 0)
{
   $executed = null;

   if ( $number != null ) {
       $SQL = 'UPDATE tabela_sms set statust_envio=:status where number=:number';
       $stmt = $this->db->prepare($SQL);
       $executed = $stmt->execute(['status' => $status, 'number'=>$number]);
   } else {
      //se for nulo, atualiza o status para todos
       $SQL = 'UPDATE tabela_sms set statust_envio=:status where 1';
       $stmt = $this->db->prepare($SQL);
       $executed = $stmt->execute(['status' => $status]);
   }
   return $executed; 
}

Answer 2

Using a repeat loop you would solve this problem as follows:

foreach ($numbers as $number) {
    $result[] = $smsGateway->sendMessageToManyNumbers($number, $message, $deviceID, $options);
}

If there is a time limit for sending Smss, you can add a sleep.