PHP与阿里云短信接口对接实际案例中的短信发送机制与消息通道设计

<?php
require 'vendor/autoload.php';

use AlibabaCloudClientAlibabaCloud;
use AlibabaCloudClientExceptionClientException;
use AlibabaCloudClientExceptionServerException;

AlibabaCloud::accessKeyClient('your-access-key-id', 'your-access-key-secret')
    ->regionId('cn-hangzhou')
    ->asDefaultClient();

try {
    $result = AlibabaCloud::rpcRequest()
                          ->product('Dysmsapi')
                          ->scheme('https')
                          ->version('2017-05-25')
                          ->action('SendSms')
                          ->method('POST')
                          ->options([
                                        'query' => [
                                            'PhoneNumbers' => '13000000000',
                                            'SignName'     => '阿里云',
                                            'TemplateCode' => 'SMS_0000001',
                                            'TemplateParam' => '{"code":"123456"}'
                                        ],
                                    ])
                          ->request();
    print_r($result->toArray());
} catch (ClientException $e) {
    echo $e->getErrorMessage() . PHP_EOL;
} catch (ServerException $e) {
    echo $e->getErrorMessage() . PHP_EOL;
}
?>

CREATE TABLE `sms_logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(20) NOT NULL COMMENT '手机号码',
  `template_code` varchar(20) NOT NULL COMMENT '短信模板ID',
  `content` text NOT NULL COMMENT '短信内容',
  `result_code` varchar(20) NOT NULL COMMENT '发送结果编码',
  `result_msg` varchar(255) NOT NULL COMMENT '发送结果消息',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

// 发送短信并将结果保存到数据库中
$result = AlibabaCloud::rpcRequest()
                        ->product('Dysmsapi')
                        ->scheme('https')
                        ->version('2017-05-25')
                        ->action('SendSms')
                        ->method('POST')
                        ->options([
                                      'query' => [
                                          'PhoneNumbers' => '13000000000',
                                          'SignName'     => '阿里云',
                                          'TemplateCode' => 'SMS_0000001',
                                          'TemplateParam' => '{"code":"123456"}'
                                      ],
                                  ])
                        ->request();
                        
// 将发送结果保存到数据库中
if ($result['Code'] == 'OK') {
  // 发送成功
  $resultCode = 'success';
  $resultMsg = '短信发送成功';
} else {
  // 发送失败
  $resultCode = 'fail';
  $resultMsg = $result['Message'];
}

// 将发送结果保存到数据库
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'your_username', 'your_password');
$stmt = $pdo->prepare("INSERT INTO sms_logs (phone_number, template_code, content, result_code, result_msg) 
                      VALUES (:phone_number, :template_code, :content, :result_code, :result_msg)");
$stmt->execute([
    'phone_number'  => '13000000000',
    'template_code' => 'SMS_0000001',
    'content'       => '您的验证码是123456',
    'result_code'   => $resultCode,
    'result_msg'    => $resultMsg
]);