Home  >  Article  >  Backend Development  >  数组处理问题,求优化

数组处理问题,求优化

WBOY
WBOYOriginal
2016-06-23 13:42:32855browse

有一个这样查询出来的数组。

$result = [	['month'=>08,'price'=>218],	['month'=>12,'price'=>140],];


最终需要转换成一个字符串,用于前台js
格式类似:[49.9, 71.5, 106.4, 129.2, 144.0, 176.0, 135.6, 148.5, 216.4, 194.1, null, null]
显示的是每月的销售情况,没有值就为null
比如一月份的price为49.9 

我的做法:
感觉有点麻烦,求优化

        //先构造类似  ['01'=>0,'02'=>0 .... '12'=>0]  这种格式的数组        $fullMonth = [];        for($i=1;$i<=12;$i++){            $fullMonth[str_pad($i,2,'0',STR_PAD_LEFT)] = 0;        }        //  遍历数组  对应月份有值就放到新建的数组里        $i = 0;        foreach($fullMonth as $month=>$value){            foreach($result as $record){                if($month == $record['month']){                    $fullMonth[$month] = $record['price'];                }            }            $i++;        }        return '[' . implode(',',$fullMonth) . ']';


回复讨论(解决方案)

为什么不用json格式?

$result = [    ['month'=>08,'price'=>218],    ['month'=>12,'price'=>140],];echo json_encode($result); // [{"month":0,"price":218},{"month":12,"price":140}]


      New Document  
08,'price'=>218], ['month'=>12,'price'=>140], ]; ?>

$r = array_fill(0, 12, null);$result = [    ['month'=> '08', 'price'=> 218],    ['month'=> '12', 'price'=> 140],];foreach($result as $v) {  $r[$v['month'] - 1] = $v['price'];}echo json_encode($r);
[null,null,null,null,null,null,null,218,null,null,null,140]

进一步询问
已知

$res = [[y=>'2014-12-03','item'=>263],[y=>'2014-12-04','item'=>168]];

让变成如下格式
[            {y: '2014-12-01', item: null},            {y: '2014-12-02', item: null},            {y: '2014-12-03', item: 263},            {y: '2014-12-04', item: 168},            {y: '2014-12-05', item: null},             .....             {y: '2014-12-31', item1:null},]

y加上引?,??才不?有notice

'2014-12-03','item'=>263],['y'=>'2014-12-04','item'=>168]];echo json_encode($res, JSON_PRETTY_PRINT);?>


[    {        "y": "2014-12-03",        "item": 263    },    {        "y": "2014-12-04",        "item": 168    }]

??

'2014-12-03','item'=>263],['y'=>'2014-12-04','item'=>168]];$tmp = array();foreach($res as $v){	$tmp[$v['y']] = $v['item'];}$start = 1;$end = 31;$result = array();for($i=$start; $i<=$end; $i++){	$key = date('Y-m-d',strtotime('2014-12-'.$i));	$item = null;	if(isset($tmp[$key])){		$item = $tmp[$key];	}	array_push($result, array('y'=>$key,'item'=>$item));}echo json_encode($result, JSON_PRETTY_PRINT);?>


[    {        "y": "2014-12-01",        "item": null    },    {        "y": "2014-12-02",        "item": null    },    {        "y": "2014-12-03",        "item": 263    },    {        "y": "2014-12-04",        "item": 168    },    {        "y": "2014-12-05",        "item": null    },    {        "y": "2014-12-06",        "item": null    },    {        "y": "2014-12-07",        "item": null    },    {        "y": "2014-12-08",        "item": null    },    {        "y": "2014-12-09",        "item": null    },    {        "y": "2014-12-10",        "item": null    },    {        "y": "2014-12-11",        "item": null    },    {        "y": "2014-12-12",        "item": null    },    {        "y": "2014-12-13",        "item": null    },    {        "y": "2014-12-14",        "item": null    },    {        "y": "2014-12-15",        "item": null    },    {        "y": "2014-12-16",        "item": null    },    {        "y": "2014-12-17",        "item": null    },    {        "y": "2014-12-18",        "item": null    },    {        "y": "2014-12-19",        "item": null    },    {        "y": "2014-12-20",        "item": null    },    {        "y": "2014-12-21",        "item": null    },    {        "y": "2014-12-22",        "item": null    },    {        "y": "2014-12-23",        "item": null    },    {        "y": "2014-12-24",        "item": null    },    {        "y": "2014-12-25",        "item": null    },    {        "y": "2014-12-26",        "item": null    },    {        "y": "2014-12-27",        "item": null    },    {        "y": "2014-12-28",        "item": null    },    {        "y": "2014-12-29",        "item": null    },    {        "y": "2014-12-30",        "item": null    },    {        "y": "2014-12-31",        "item": null    }]

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn