PHP数组和json_encode(用逗号分隔)
PHP array and json_encode (separated with comma)
我真的很想把PHP数组转换成JavaScript数组,并把它转换成正确的格式。这就是我的
我的PHP数组存储在$data
中(这来自SQL服务器查询),我正在使用json_encode
将其转换为JavaScript数组。
这是代码$javaarray = json_encode($data);
当我echo
时,结果就是我得到的
{"VERTICAL":"PROVISIONING","dcount":381890}
{"VERTICAL":"BILL DELIVERY","dcount":171169}
{"VERTICAL":"BILLING","dcount":45197}
{"VERTICAL":"RISK AND CREDIT","dcount":51533}
{"VERTICAL":"CUSTOMER ACCOUNTING","dcount":136097}
{"VERTICAL":"AIRTEL MONEY","dcount":7826}
{"VERTICAL":"ANALYTICS","dcount":2946}
{"VERTICAL":"CONTROLS","dcount":5615}
现在,我只想获得dcount
部分,以以下格式将其反馈给我的jQuery函数
[381890,171169,45197,51533,136097,7826,2946,5615]
我试着使用implode(), join()
,但不知何故,我甚至没有接近上面的格式。
我正在张贴
$array = array($data);
print_r($array);
结果也是
Array ( [0] => Array ( [VERTICAL] => PROVISIONING [dcount] => 381890 ) ) Array ( [0] => Array ( [VERTICAL] => BILL DELIVERY [dcount] => 171169 ) ) Array ( [0] => Array ( [VERTICAL] => BILLING [dcount] => 45197 ) ) Array ( [0] => Array ( [VERTICAL] => RISK AND CREDIT [dcount] => 51533 ) ) Array ( [0] => Array ( [VERTICAL] => CUSTOMER ACCOUNTING [dcount] => 136097 ) ) Array ( [0] => Array ( [VERTICAL] => AIRTEL MONEY [dcount] => 7826 ) ) Array ( [0] => Array ( [VERTICAL] => ANALYTICS [dcount] => 2946 ) ) Array ( [0] => Array ( [VERTICAL] => CONTROLS [dcount] => 5615 ) )
试试这样的
$dcounts = array();
foreach ($data as $row) {
$dcounts[] = $row['dcount'];
}
$javaarray = json_encode($dcounts);
$dcounts = json_encode(array_map(function($v) { return $v['dcount'] }, $javaarray));
$data = '{"VERTICAL":"PROVISIONING","dcount":381890}
{"VERTICAL":"BILL DELIVERY","dcount":171169}
{"VERTICAL":"BILLING","dcount":45197}
{"VERTICAL":"RISK AND CREDIT","dcount":51533}
{"VERTICAL":"CUSTOMER ACCOUNTING","dcount":136097}
{"VERTICAL":"AIRTEL MONEY","dcount":7826}
{"VERTICAL":"ANALYTICS","dcount":2946}
{"VERTICAL":"CONTROLS","dcount":5615}';
//split data into array
$keywords = preg_split("/['n]+/", $data);
//convert into proper json format
$jsonobject = implode(',',$keywords);
$jsonobject = '['.$jsonobject.']';
//convert json into array
$array = json_decode($jsonobject);
//for each and save dcount value
$dcount = array();
foreach($array as $row){
$dcount[] = $row->dcount;
}
//again convert dcount values into json
$dcountjson = json_encode($dcount);
print_r($dcountjson);
相关文章:
- javascript函数内部的代码用逗号而不是分号分隔
- 可以't用回车符分隔那个字符串
- 计算输入中有多少逗号分隔的字符串
- 选择带有空格分隔单词的元素
- 尝试使用Javascript正则表达式来获取“&"分隔文本,无论它是否's是最后一个值
- 使用JavaScript分析分隔文本行
- 比较逗号分隔的字符串
- 用分隔符分隔具有多个整数值的字符串的Javascript"重试错误的值
- Javascript-Regex,用于逗号分隔的字母数字
- 使用jquery过滤逗号分隔的span文本
- 在javascript中用逗号分隔的字符串分割值
- 如何在java脚本中用单引号写逗号分隔的值
- 如何将逗号分隔的列表转换为<ul>列表
- 输入只允许6位数字,逗号分隔后,允许角js中的另外6位数字
- 如何从由“”分隔的字符串中提取最后一个文本|&”;
- 匹配由单个空格分隔的单词,单词的开头或结尾不能有空格
- JS将分隔符分隔的字符串转换为数组元素
- jQuery:如何添加<br/>在不同的字符串中换行以分隔2中的句子
- 匹配正则表达式不分隔大写或不大写
- 使用 javascript 传递逗号分隔的变量