我的数据库获得代码
function get_user_orders($user_id, $num = 10, $start = 0, $status = '',$extension = '')
{
/* 取得订单列表 */
$arr = array();
$where = '';
if ($extension == '')
{
$where .= " AND extension_code = '' ";
}
else
{
$where .= " AND extension_code = '$extension' ";
}
if($status != '')
{
if($status == '1') /* 等待付款 */
{
$where .= " AND order_status = '1' and shipping_status='0' and pay_status='0' ";
}
if($status == '2') /* 等待确认 */
{
$where .= " AND order_status = '1' and pay_status='2' and shipping_status <= '1' ";
}
if($status == '3') /* 完成订单 */
{
$where .= " AND order_status = '1' and shipping_status='2' and pay_status='2'";
}
}
$sql = "SELECT order_id, order_sn, order_status, shipping_status, pay_status, add_time, consignee, " .
"(goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee ".
" FROM " .$GLOBALS['ecs']->table('order_info') .
" WHERE user_id = '$user_id' ". $where .
"ORDER BY order_status, pay_status, shipping_status, add_time DESC";
$res = $GLOBALS['db']->SelectLimit($sql, $num, $start); while ($row = $GLOBALS['db']->fetchRow($res))
{
if ($row['order_status'] == 0)
{
$row['handler'] = "<a href=\"user.php?act=cancel_order&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_cancel']."')) return false;\">取消订单</a><br/><a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. "\">立即支付</a>";
}
else
{
if ($row['order_status'] == 1)
{
if ($row['pay_status'] == 2)
{
/* 对配送状态的处理 */
if ($row['shipping_status'] == 2)
{
@$row['handler'] = "<span style=\"color:Red;\">交易完成</span>";
}
else
{
if ($row['shipping_status'] == 1)
{
@$row['handler'] = "<a href=\"user.php?act=affirm_received&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_received']."')) return false;\">确认收货</a><br/><a href=\"user.php?act=account_raply&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['account_raply']."')) return false;\">申请退货</a>";
}
else
{
@$row['handler'] = "等待发货<br/><a href=\"user.php?act=account_raply&order_id=" .$row['order_id']. "\">申请退款</a>";
}
}
}
else
{
@$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. "\">立即支付</a><br/><a href=\"user.php?act=account_raply&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['account_raply']."')) return false;\">取消订单</a>";
}
}
else
{
@$row['handler'] = "<span style=\"color:Red;\">交易取消</span>";
}
}
/* order_status:1正常订单 2取消订单 3退货订单 */
/* pay_status:0、1等待付款 2付款完成 3申请退款 4完成退款 */
/* shipping_status:0等待发货 1等待确认 2确认收货 3申请退货 4退货完成 */
$row['shipping_status'] = ($row['shipping_status'] == SS_SHIPPED_ING) ? SS_PREPARING : $row['shipping_status'];
$row['order_status'] = ($row['order_status'] == 3) ? "退货订单" . ',' .(($row['pay_status'] > 2) ? (($row['pay_status'] == 4) ? "退货完成" :"申请退款"):"") : ($row['order_status'] == 2)? "取消订单" : (($row['pay_status'] < 2)? "等待付款" : (($row['shipping_status'] == 0) ? "等待发货" : (($row['shipping_status'] == 1) ? "等待确认" : "确认收货"))); $sql1 = "SELECT o.order_id, o.goods_id, q.goods_img, q.goods_name " .
" FROM " .$GLOBALS['ecs']->table('order_goods') . " AS o " .
" LEFT JOIN " .$GLOBALS['ecs']->table('goods') ." AS q ON o.goods_id = q.goods_id " .
" WHERE o.order_id = '" .$row['order_id']. "'";
$res1 = $GLOBALS['db']->getAll($sql1);
$img_all = '';
while ($row1 = $GLOBALS['db']->fetchRow($res1))
{
$img_all .="<div><a href=\"goods.php?id=" .$row1['goods_id']. "\" target=\"_blank\"><img src=\"" .get_image_path($row1['goods_id'], $row1['goods_img']). "\" width=\"80\" title=\"" .$row1['goods_name']. "\"></a></div>";
}
@$row['img_all'] = isset($img_all) ? $img_all : "无值";
$arr[] = array('order_id' => $row['order_id'],
'order_sn' => $row['order_sn'],
'consignee' => $row['consignee'],
'order_time' => local_date($GLOBALS['_CFG']['time_format'], $row['add_time']),
'order_status' => $row['order_status'],
'total_fee' => price_format($row['total_fee'], false),
'img' => $row['img_all'],
'handler' => $row['handler']);
} return $arr;
}前台页面绑定
$smarty->assign('orders', $orders);<!--{foreach from=$orders item=orderlist name="orderlist"}-->
<tr>
<td><a href="user.php?act=order_detail&order_id={$orderlist.order_id}">{$orderlist.order_sn}</a></td>
<td>
{$orderlist.img}
</td>
<td>{$orderlist.consignee}</td>
<td><div>{$orderlist.total_fee}</div></td>
<td><div>{$orderlist.order_time}</div></td>
<td>{$orderlist.order_status}</td>
<td>{$orderlist.handler}</td>
</tr>
<!--{/foreach}-->
其他都正常显示出来,就是在里面重新写的一个查询循环生成的{$orderlist.img}这个显示不出来
function get_user_orders($user_id, $num = 10, $start = 0, $status = '',$extension = '')
{
/* 取得订单列表 */
$arr = array();
$where = '';
if ($extension == '')
{
$where .= " AND extension_code = '' ";
}
else
{
$where .= " AND extension_code = '$extension' ";
}
if($status != '')
{
if($status == '1') /* 等待付款 */
{
$where .= " AND order_status = '1' and shipping_status='0' and pay_status='0' ";
}
if($status == '2') /* 等待确认 */
{
$where .= " AND order_status = '1' and pay_status='2' and shipping_status <= '1' ";
}
if($status == '3') /* 完成订单 */
{
$where .= " AND order_status = '1' and shipping_status='2' and pay_status='2'";
}
}
$sql = "SELECT order_id, order_sn, order_status, shipping_status, pay_status, add_time, consignee, " .
"(goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee ".
" FROM " .$GLOBALS['ecs']->table('order_info') .
" WHERE user_id = '$user_id' ". $where .
"ORDER BY order_status, pay_status, shipping_status, add_time DESC";
$res = $GLOBALS['db']->SelectLimit($sql, $num, $start); while ($row = $GLOBALS['db']->fetchRow($res))
{
if ($row['order_status'] == 0)
{
$row['handler'] = "<a href=\"user.php?act=cancel_order&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_cancel']."')) return false;\">取消订单</a><br/><a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. "\">立即支付</a>";
}
else
{
if ($row['order_status'] == 1)
{
if ($row['pay_status'] == 2)
{
/* 对配送状态的处理 */
if ($row['shipping_status'] == 2)
{
@$row['handler'] = "<span style=\"color:Red;\">交易完成</span>";
}
else
{
if ($row['shipping_status'] == 1)
{
@$row['handler'] = "<a href=\"user.php?act=affirm_received&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['confirm_received']."')) return false;\">确认收货</a><br/><a href=\"user.php?act=account_raply&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['account_raply']."')) return false;\">申请退货</a>";
}
else
{
@$row['handler'] = "等待发货<br/><a href=\"user.php?act=account_raply&order_id=" .$row['order_id']. "\">申请退款</a>";
}
}
}
else
{
@$row['handler'] = "<a href=\"user.php?act=order_detail&order_id=" .$row['order_id']. "\">立即支付</a><br/><a href=\"user.php?act=account_raply&order_id=" .$row['order_id']. "\" onclick=\"if (!confirm('".$GLOBALS['_LANG']['account_raply']."')) return false;\">取消订单</a>";
}
}
else
{
@$row['handler'] = "<span style=\"color:Red;\">交易取消</span>";
}
}
/* order_status:1正常订单 2取消订单 3退货订单 */
/* pay_status:0、1等待付款 2付款完成 3申请退款 4完成退款 */
/* shipping_status:0等待发货 1等待确认 2确认收货 3申请退货 4退货完成 */
$row['shipping_status'] = ($row['shipping_status'] == SS_SHIPPED_ING) ? SS_PREPARING : $row['shipping_status'];
$row['order_status'] = ($row['order_status'] == 3) ? "退货订单" . ',' .(($row['pay_status'] > 2) ? (($row['pay_status'] == 4) ? "退货完成" :"申请退款"):"") : ($row['order_status'] == 2)? "取消订单" : (($row['pay_status'] < 2)? "等待付款" : (($row['shipping_status'] == 0) ? "等待发货" : (($row['shipping_status'] == 1) ? "等待确认" : "确认收货"))); $sql1 = "SELECT o.order_id, o.goods_id, q.goods_img, q.goods_name " .
" FROM " .$GLOBALS['ecs']->table('order_goods') . " AS o " .
" LEFT JOIN " .$GLOBALS['ecs']->table('goods') ." AS q ON o.goods_id = q.goods_id " .
" WHERE o.order_id = '" .$row['order_id']. "'";
$res1 = $GLOBALS['db']->getAll($sql1);
$img_all = '';
while ($row1 = $GLOBALS['db']->fetchRow($res1))
{
$img_all .="<div><a href=\"goods.php?id=" .$row1['goods_id']. "\" target=\"_blank\"><img src=\"" .get_image_path($row1['goods_id'], $row1['goods_img']). "\" width=\"80\" title=\"" .$row1['goods_name']. "\"></a></div>";
}
@$row['img_all'] = isset($img_all) ? $img_all : "无值";
$arr[] = array('order_id' => $row['order_id'],
'order_sn' => $row['order_sn'],
'consignee' => $row['consignee'],
'order_time' => local_date($GLOBALS['_CFG']['time_format'], $row['add_time']),
'order_status' => $row['order_status'],
'total_fee' => price_format($row['total_fee'], false),
'img' => $row['img_all'],
'handler' => $row['handler']);
} return $arr;
}前台页面绑定
$smarty->assign('orders', $orders);<!--{foreach from=$orders item=orderlist name="orderlist"}-->
<tr>
<td><a href="user.php?act=order_detail&order_id={$orderlist.order_id}">{$orderlist.order_sn}</a></td>
<td>
{$orderlist.img}
</td>
<td>{$orderlist.consignee}</td>
<td><div>{$orderlist.total_fee}</div></td>
<td><div>{$orderlist.order_time}</div></td>
<td>{$orderlist.order_status}</td>
<td>{$orderlist.handler}</td>
</tr>
<!--{/foreach}-->
其他都正常显示出来,就是在里面重新写的一个查询循环生成的{$orderlist.img}这个显示不出来
显然是路径不对,你看一下网页源代码