<?php
require_once(dirname(__FILE__)."/include/common.inc.php");
require_once(dirname(__FILE__)."/include/datalistcp.class.php");
//以下SQL语句根据自己需要进行修改
$sql = "SELECT `a`.`typename`,`a`.`id` as `tmd`,`b`.`id` as `aid`,`b`.`title`,`b`.`typeid`,`b`.`litpic`,`b`.`description` FROM `dede_archives` as `b` left join `dede_arctype` as `a` on `b`.`typeid`=`a`.`id`
WHERE `a`.`reid`='11' AND `b`.`channel`='6' ORDER BY `b`.`id` DESC" ;
$dlist = new DataListCP();
$dlist->pageSize = 8;
$dlist->SetTemplate(dirname(__FILE__)."/templets/juncheng/en/products.htm");
$dlist->SetSource($sql);
$dlist->Display();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Products - {dede:global.cfg_webname/}</title>
<meta http-equiv="X-UA-Compatible" content="IE=EmulateIE7" />
</head>
<body>
<div class="clear products hidden">
{dede:datalist}
<dl class="clear left marginbottom20 hidden">
<dt class="left marginright10 hidden"><a href="/plus/view.php?aid=<?php echo $fields['aid']?>" title="<?php echo $fields['title']?>"><img src="<?php
if($fields['litpic']==''){$fields['litpic'] = '/templets/juncheng/images/NoProducts.jpg';}
echo $fields['litpic'];
?>" width="150" height="180" /></a></dt>
<dd><span>Product Name:</span><a href="/plus/view.php?aid=<?php echo $fields['aid']?>" title="<?php echo $fields['title']?>" class="grey"><strong><?php echo $fields['title']?></strong></a></dd>
<dd><span>Product Category:</span><a href="/plus/list.php?tid=<?php echo $fields['tmd']?>" title="<?php echo $fields['typename']?>" class="grey"><?php echo $fields['typename']?></a></dd>
<dd><span>Product Description:</span><?php echo $fields['description']?>..</dd>
</dl>
{/dede:datalist}
</div>
<div class="clear pages hidden">{dede:pagelist listitem="info,index,end,pre,next,pageno" listsize="5"/}</div>
<div class="footer center">
<?php
//版权
$dsql->SetQuery("SELECT `langtxt` FROM `dede_mylang` WHERE `id`='6' order by id desc limit 0,1");
$dsql->Execute();
while($row=$dsql->GetArray())
{
echo $row['langtxt'];
}
$dsql->Close();
?>
/*////以下为备用 ,也可以用这个
<?php
//版权
$dsql->SetQuery("SELECT `langtxt` FROM `dede_mylang` WHERE `id`='6' order by id desc limit 0,1");
$dsql->Execute();
while($row=$dsql->GetObject())
{
$newartlist .= "{$row->langtxt}";
}
echo $newartlist;
?>
</div>
</body>
</html>
/*////以上为备用