$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);
}
}
}
}
查询是有多条数据的！
YXPHP6.0 豪华版
下载
YXPHP6系统可以看做是一个模版平台,而且它又能独立工作. 而且YXPHP6系统也不需要数据库支持. 你可以开发自己的模板,也可以同步官方的模板后进行自己的二次开发,前提是您对YXPHP6要有一定的了解.YXPHP6不仅可以用作企业建站,甚至是blog,只要是您能想到的,YXPHP6几乎都可以胜任. 因为YXPHP6系统本身与模板之间可以说是独立运行的.也就是说,不管你做什么样的网站或者是应用,
回复内容：
$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);
}
}
}
}
查询是有多条数据的！
