在开发短信群发项目时,短信接口数据接收为 json 格式,需要将数据库查询获得的遍历数组提取键值后再转为 json 数据格式,通过以下方式来实现:
数组数据:
<?php $sms_list = array ( array ( "phoneNumber" => 13500000000, "SignName" => "SignName1", "TemplateCode" => "SMS_165000001" ), array ( "phoneNumber" => 13600000000, "SignName" => "SignName2", "TemplateCode" => "SMS_165000002" ), array ( "phoneNumber" => 13700000000, "SignName" => "SignName3", "TemplateCode" => "SMS_165000003" ), array ( "phoneNumber" => 13800000000, "SignName" => "SignName4", "TemplateCode" => "SMS_165000004" ) );
处理方法:
// 获取手机号 json 数据 $phoneNumber = array_column($sms_list, phoneNumber); $phoneNumber_json = json_encode($phoneNumber); echo $phoneNumber_json; echo '<br>'; // 获取签名 json 数据 $SignNamer = array_column($sms_list, SignName); $SignNamer_json = json_encode($SignNamer); echo $SignNamer_json; echo '<br>'; // 获取短信模板 json 数据 $TemplateCode = array_column($sms_list, TemplateCode); $TemplateCode_json = json_encode($TemplateCode); echo $TemplateCode_json; echo '<br>';
输出结果:
[13500000000,13600000000,13700000000,13800000000] ["SignName1","SignName2","SignName3","SignName4"] ["SMS_165000001","SMS_165000002","SMS_165000003","SMS_165000004"]