当前位置:Gxlcms > PHP教程 > 为什么最后一个var_dump()只能打印一个数组

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

时间:2021-07-01 10:21:17 帮助过:19人阅读

    $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)<10?str_pad($goods_no, 10,'0',STR_PAD_LEFT):$goods_no;
                        $where = "info.item_no = '".$goods_no."'";
                    }
                    else
                    {
                        $goods_huo = strlen($goods_huo)<5?str_pad($goods_huo, 5,'0',STR_PAD_LEFT):$goods_huo;
                        $where = "info.item_huo = '".$goods_huo."'";
                    }

                    $stockQuery = "select * from info join stock on stock.item_no = info.item_no where ".$where;
                    $hsh = new MYSQL("127.0.0.1","root","","test2");
                    $stockResult = $hsh->query($stockQuery,'select');

                    var_dump($stockResult);
                }
            }
        }

    }

查询是有多条数据的!

回复内容:

    $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)<10?str_pad($goods_no, 10,'0',STR_PAD_LEFT):$goods_no;
                        $where = "info.item_no = '".$goods_no."'";
                    }
                    else
                    {
                        $goods_huo = strlen($goods_huo)<5?str_pad($goods_huo, 5,'0',STR_PAD_LEFT):$goods_huo;
                        $where = "info.item_huo = '".$goods_huo."'";
                    }

                    $stockQuery = "select * from info join stock on stock.item_no = info.item_no where ".$where;
                    $hsh = new MYSQL("127.0.0.1","root","","test2");
                    $stockResult = $hsh->query($stockQuery,'select');

                    var_dump($stockResult);
                }
            }
        }

    }

查询是有多条数据的!

人气教程排行