希望你好。我有一個(gè)查詢，結(jié)果如下：我需要這是一個(gè)多數(shù)組來將它顯示在數(shù)據(jù)表中，如下所示：Article, Products, Supname, Week1, Week2, Week3, Week4, Week5, Week6, and so on1 Product 1 Supplier 1 0,27 0,6 0,36 0,58 0,78 0,32 and so on我用 PDO 得到了所有結(jié)果，因?yàn)槲覀兪褂玫氖?SQL 服務(wù)器，我創(chuàng)建數(shù)組的代碼是這樣的：$pos = 0;$x = 0; $End = count($getAll);$html = array();$html2 = array(); while ($x <= 53) { if ($x == 0) { $html[] = array('Articleno' => $getAll[$pos+1]["ArtNo"], 'Name' => ''.$getAll[$pos+1]["Product"], 'Supname' => $getAll[$pos+1]["Levnamn"]); } $html2 = array('M'.$getAll[$pos]["Weekno"] => $getAll[$pos]["Qty"].' , '.$getAll[$pos]["Sold"]); $html = array_merge($html, $html2); $x++; $pos++; if ($x == 53){ $x=0; } if ($pos==$End){ $x=70; } }結(jié)果還差得遠(yuǎn)，我嘗試了很多不同的解決方案，但這是最接近的一個(gè)。我缺少 product2 的 alla 周信息。最多可填充 150 種產(chǎn)品。有什么建議 ？
1 回答
慕蓋茨4494581
TA貢獻(xiàn)1850條經(jīng)驗(yàn) 獲得超11個(gè)贊
您可以像這樣構(gòu)建數(shù)組：
$stm = $pdo->query('your SQL query');
$output = [];
while($row = $stm->fetch(PDO::FETCH_ASSOC))
{
$ident = $row['Articleno'].';'.$row['Product'].';'.$row['Supname'];
$ref = &$output[$ident];
if(!is_array($ref))
{
$ref['Article'] = $row['Articleno'];
$ref['Product'] = $row['Product'];
$ref['Supname'] = $row['Supname'];
$ref['Week1'] = [0,0];
$ref['Week2'] = [0,0];
$ref['Week3'] = [0,0];
$ref['Week4'] = [0,0];
$ref['Week5'] = [0,0];
$ref['Week6'] = [0,0];
}
$weekNo = $row['Weekno'];
$ref['Week'.$weekNo] = [$row['Qty'], $row['Sold']];
}
echo json_encode(array_values($output));
- 1 回答
- 0 關(guān)注
- 137 瀏覽
添加回答
舉報(bào)
0/150
提交
取消