如何将短信发送到数据库条目

ishan Kankane 发表于 Dev

伊山·坎卡内

我能够通过php发送短信，但是每次我要使用相同的脚本时，我都必须提及手机号码，我可以向存储在数据库中的条目发送短信。这是我的代码：

<?php

//Your authentication key`enter code here`
$authKey = "API key";

//Multiple mobiles numbers separated by comma
$mobileNumber = "+919425386214";

//Sender ID,While using route4 sender id should be 6 characters long.
$senderId = "Social";

//Your message to send, Add URL encoding here.
$message = urlencode("Test message");

//Define route 
$route = "04";
//Prepare you post parameters
$postData = array(
    'authkey' => $authKey,
    'mobiles' => $mobileNumber,
    'message' => $message,
    'sender' => $senderId,
    'route' => $route
);
if (isset($_POST['submit']))
{

//API URL
$url="https://control.msg91.com/api/sendhttp.php";

// init the resource
$ch = curl_init();
curl_setopt_array($ch, array(
    CURLOPT_URL => $url,
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_POST => true,
    CURLOPT_POSTFIELDS => $postData
    //,CURLOPT_FOLLOWLOCATION => true
));


//Ignore SSL certificate verification
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);


//get response
$output = curl_exec($ch);

//Print error if any
if(curl_errno($ch))
{
    echo 'error:' . curl_error($ch);
}

curl_close($ch);

echo $output;
}
?>

请帮助，以便我可以将短信发送给与我联系的客户。存储在我的数据库中

生死

您需要执行一些查询代码，以帮助您查看示例代码：-

<?php
error_reporting(E_ALL);
ini_set('display_errors',1);
$mobileNumber = '';
$conn = mysqli_connect('localhost','root','','database name') or die (mysqli_error()); // give connection credentials here

if($conn){
$query = "Select mobile_number From User"; // change table name and column name accordingly.

$result = mysqli_query($conn,$query) or die(mysqli_error($conn));
if(mysqli_num_rows($result) > 0){
   while($row = mysqli_fetch_assoc($result)){
         $mobileNumber .= $row['mobile_number'].',';
   }
}

}
$mobileNumber = substr($mobileNumber,0,strlen($mobileNumber)-1); // now you have all mobile numbers in , seperated form in this variable