我正在用这个PHP查询数组。
的PHP
$query = mssql_query(" SELECT count(startdate) as incept, month(startdate) as month, year(startdate) as year
FROM tblUser
WHERE startdate >= convert(varchar(20),'$val1',121) AND startdate <= convert(varchar(20),'$val2',121)
GROUP BY month(startdate), year(startdate)
ORDER BY year(startdate) ASC, month(startdate) ASC ");
while ($data = mssql_fetch_array($query)) {
$name = $data['year'];
$data = array($data['month'],$data['incept']);
$case[$data['year']] = array('name' => $name, 'data' => $data);
}
我想将上述查询存储在以下结构中,并将其传递给json。
$case = array(
'2011' => array(
'name' => 2011,
'data' => array(
array('0', 166),
array('1', 132),
..
array('5', 160)
)
),
'2012' => array(
'name' => 2012,
'data' => array(
array('0', 142),
...
array('5', 163)
)
),
'2013' => array(
'name' => 2013,
'data' => array(
array('0', 156),
...
array('6', 198)
)
)
)
有什么方法可以生成这种格式吗?谢谢
循环内:
if (!isset($case[$data['year']])) {
$case[$data['year']] = array(
'name' => $data['year'],
'data' => array()
);
}
$case[$data['year']]['data'][] = array(
$data['month'],
$data['incept']
);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句