goods_list.php

LOVESTUdio多校园交易系统 VER 4.0基于3.0开发

<?php
if($_POST[message] == searchgoods){
             $goodsname = $_POST[goodsname];
			$result = $conn->query("SELECT * FROM ".$tablepre."goods WHERE goodsname LIKE '%$goodsname%'");   
			  $total=0;
			   while($akr = $result->fetch_assoc()){
			   $total++;
			   }
               $page = new ShowPage;   
               $page->PageSize = 10;   
               $page->Total = $total;   
               $page->LinkAry = array();                    
               $showpage = $page->ShowLink();
$result = $conn->query("SELECT * FROM ".$tablepre."goods WHERE goodsname LIKE '%$goodsname%' ORDER BY goodsid DESC LIMIT ".$page->OffSet());

}
elseif($_GET[action] == "" || $_GET[action] == news){
$sql = "SELECT * FROM ".$tablepre."goods ORDER BY goodsid DESC";
$result = $conn->query($sql);
$total=0;
			   while($akr = $result->fetch_assoc()){
			   $total++;
			   }          
               $page = new ShowPage;   
               $page->PageSize = 10;   
               $page->Total = $total;   
               $page->LinkAry = array();                    
               $showpage = $page->ShowLink();
$result = $conn->query("SELECT * FROM ".$tablepre."goods ORDER BY goodsid DESC LIMIT ".$page->OffSet());
}
else if($_GET[action] == hot){
$sql = "SELECT * FROM ".$tablepre."goods ORDER BY goodshit DESC";
$result = $conn->query($sql);
$total=0;
			   while($akr = $result->fetch_assoc()){
			   $total++;
			   }           
               $page = new ShowPage;   
               $page->PageSize = 10;   
               $page->Total = $total;   
               $page->LinkAry = array();                    
               $showpage = $page->ShowLink();
$result = $conn->query("SELECT * FROM ".$tablepre."goods ORDER BY goodshit DESC LIMIT ".$page->OffSet());

}			   
else if($_GET[action] == mode){
$sql = "SELECT * FROM ".$tablepre."goods ORDER BY goodsmode DESC";
$result = $conn->query($sql);
$total=0;
			   while($akr = $result->fetch_assoc()){
			   $total++;
			   }           
               $page = new ShowPage;   
               $page->PageSize = 10;   
               $page->Total = $total;   
               $page->LinkAry = array();                    
               $showpage = $page->ShowLink();
$result = $conn->query("SELECT * FROM ".$tablepre."goods ORDER BY goodsmode DESC LIMIT ".$page->OffSet());
}

?>
<table width="100%" border="1" bordercolor="#F5EFEA" cellpadding="4" cellspacing="0">
<tr align="center">
<td width="30%">商品名称</td>
<td width="11%">图片</td>
<td width="11%">价格</td>
<td width="11%">议价</td>
<td width="8%">数量</td>
<td width="21%">上架时间</td>
<td width="8%">人气</td>
</tr>
<?php
while ($arr = $result->fetch_assoc())
{

?>
<tr align="center">
<td><a href="show_goods.php?goodsid=<?php echo $arr[goodsid]; ?>" target="_blank"><?php echo $arr[goodsname]; ?></a></td>
<td><a href="show_goods.php?goodsid=<?php echo $arr[goodsid]; ?>" target="_blank"><img src="upload/goodsimg/<?php echo $arr[goodsimg]; ?>" width="50" height="50" border="1" /></a></td>
<td class="red"><?php echo $arr[goodsprice]; ?>元</td>
<td class="red"><?php echo selectpricetype($arr[goodsyijia]); ?></td>
<td><?php echo $arr[goodsnum]; ?></td>
<td><?php echo $arr[goodstime]; ?></td>
<td><?php echo $arr[goodshit]; ?></td>
</tr>
<?php
}
?>
<tr>
     <td align="right" colspan="7"><?php echo $showpage; ?>&nbsp;&nbsp;</td>
  </tr>
</table>