首頁 >後端開發 >php教程 >为什么最后一个var_dump()只能打印一个数组

为什么最后一个var_dump()只能打印一个数组

WBOY
WBOY原創
2016-06-06 20:45:021046瀏覽

<code>    $orderQuery = "select sum(`goods`.goods_nums) goods_nums,goods.goods_id,goods.goods_array,goods.product_id,goods.goods_price 
    from iwebshop_order `order` 
    join iwebshop_order_goods `goods` 
    on `order`.id = `goods`.order_id 
    where `order`.status = '5' 
    and unix_timestamp(`order`.create_time) 
    between '".$begin."' and '".$end."' 
    group by `goods`.goods_id";
    $njhl = new MYSQL("127.0.0.1","root","","test1");
    $orderResult =  $njhl->query($orderQuery,'select');

    if($orderResult)
    {
        foreach($orderResult as $item)
        {

            $goodsQuery = "select goods_no,huo_no from goods where id = ".$stock['goods_id'];

            $goodsResult = $njhl->query($goodsQuery,'select');

            if($goodsResult)
            {
                foreach($goodsResult as $goods)
                {
                    $goods_no = trim($goods['goods_no']);
                    $goods_huo = trim($goods['huo_no']);
                    $where;
                    if($goods_no)
                    {
                        $goods_no = strlen($goods_no)query($stockQuery,'select');

                    var_dump($stockResult);
                }
            }
        }

    }
</code>

查询是有多条数据的!

回复内容:

<code>    $orderQuery = "select sum(`goods`.goods_nums) goods_nums,goods.goods_id,goods.goods_array,goods.product_id,goods.goods_price 
    from iwebshop_order `order` 
    join iwebshop_order_goods `goods` 
    on `order`.id = `goods`.order_id 
    where `order`.status = '5' 
    and unix_timestamp(`order`.create_time) 
    between '".$begin."' and '".$end."' 
    group by `goods`.goods_id";
    $njhl = new MYSQL("127.0.0.1","root","","test1");
    $orderResult =  $njhl->query($orderQuery,'select');

    if($orderResult)
    {
        foreach($orderResult as $item)
        {

            $goodsQuery = "select goods_no,huo_no from goods where id = ".$stock['goods_id'];

            $goodsResult = $njhl->query($goodsQuery,'select');

            if($goodsResult)
            {
                foreach($goodsResult as $goods)
                {
                    $goods_no = trim($goods['goods_no']);
                    $goods_huo = trim($goods['huo_no']);
                    $where;
                    if($goods_no)
                    {
                        $goods_no = strlen($goods_no)query($stockQuery,'select');

                    var_dump($stockResult);
                }
            }
        }

    }
</code>

查询是有多条数据的!

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn