欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

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

程序员文章站 2022-06-12 12:57:31
...
    $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);
                }
            }
        }

    }

查询是有多条数据的!

回复内容:

    $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);
                }
            }
        }

    }

查询是有多条数据的!

相关标签: php mysql