在php中用json_encode打印foreach循环

我是php的新手。所以它可能是非常基础的,但我不知道。因此,我希望在php中使用json_encode()输出如下所示。

"option": [
    {
      "poOptionGroup": "11",
      "optGrpID": "11",
      "optGrpName": "Choose Backing Material"
    },
    {
      "optID": "40",
      "optName": "Black (Plexiglass)",
      "optPriceDiff": "0"
    },
    {
      "optID": "41",
      "optName": "Clear (Plexiglass)",
      "optPriceDiff": "18"
    },
    {
      "optID": "218",
      "optName": "Neon Stand Off",
      "optPriceDiff": "18"
    },
    {
      "optID": "219",
      "optName": "White Plastic",
      "optPriceDiff": "18"
    }
  ],
  "option": [
    {
      "poOptionGroup": "13",
      "optGrpID": "13",
      "optGrpName": "Any notes you want to include with your order"
    },
    {
      "optID": "174",
      "optName": "NO Thanks",
      "optPriceDiff": "0"
    },
    {
      "optID": "175",
      "optName": "YES OUTDOOR",
      "optPriceDiff": "170"
    }
  ],
  "SPIN3": [
    {
      "poOptionGroup": "56",
      "optGrpID": "56",
      "optGrpName": "Upgrade to OUTDOOR"
    },
    {
      "optID": "44",
      "optName": "",
      "optPriceDiff": "20.02"
    }
  ]

为此,我有两个嵌套的foreach循环。具体如下:

$product=array();   
        foreach($query as $q){
            $product['optGrpID']= $q['optGrpID'];
            $product['optGrpName'] = $q['optGrpName'];
            $product['poOptionGroup'] = $q['poOptionGroup'];
            $opt_id=$product['optGrpID'];
                $string=  sql("select optID, optName, optPriceDiff from options where optGroup='$opt_id' ");
                foreach ($string as $k=>$s){
                    $product['options']['optID']=$s['optID'];
                    $product['options']['optName']=$s['optName'];
                    $product['options']['optPriceDiff']=$s['optPriceDiff'];
                }
        }       

那么,我如何才能实现这个期望的输出呢?请帮帮忙。任何帮助都将不胜感激。

转载请注明出处:http://www.mingyanggongyi.com/article/20230526/2390954.html