ホームページ >バックエンド開発 >PHPチュートリアル >为什么最后一个var_dump()只能打印一个数组

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

WBOY
WBOYオリジナル
2016-06-06 20:45:021055ブラウズ

<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 までご連絡ください。