shop_list.php

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

<?php
if($_POST[message] == searchshop){
               $shopname = $_POST[shopname];
			   $result = $conn->query("SELECT * FROM ".$tablepre."shop WHERE shopmode='0' AND shopname LIKE '%$shopname%'");
			   $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."shop WHERE shopmode='0' AND shopname LIKE '%$shopname%' ORDER BY shopid DESC LIMIT ".$page->OffSet());
			   
                                 }
elseif($_GET[action] == "" || $_GET[action] == news){
$sql = "SELECT * FROM ".$tablepre."shop WHERE shopmode='0' ORDER BY shopid 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."shop WHERE shopmode='0' ORDER BY shopid DESC LIMIT ".$page->OffSet());
}
else if($_GET[action] == hot){
$sql = "SELECT * FROM ".$tablepre."shop WHERE shopmode='0' ORDER BY shophit 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."shop WHERE shopmode='0' ORDER BY shophit DESC LIMIT ".$page->OffSet());

}			   
else if($_GET[action] == star){
$sql = "SELECT * FROM ".$tablepre."shop WHERE shopmode='0' ORDER BY shopstar 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."shop WHERE shopmode='0' ORDER BY shopstar DESC LIMIT ".$page->OffSet());
}
elseif($_GET[action] == fromschool){
                                    $schoolid = $_GET[school];
									$result = $conn->query("SELECT * FROM ".$tablepre."shop WHERE shopmode='0' AND shopschool='$schoolid'");
			   $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."shop WHERE shopmode='0' AND shopschool='$schoolid' ORDER BY shopstar DESC LIMIT ".$page->OffSet());
									}
elseif($_GET[action] == fromtype){
                       $typeid = $_GET[type];
					   $result = $conn->query("SELECT * FROM ".$tablepre."shop WHERE shopmode='0' AND shoplei='$typeid'");
			   $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."shop WHERE shopmode='0' AND shoplei='$typeid' ORDER BY shopid DESC LIMIT ".$page->OffSet());  
						          }									
?>

<table width="100%" border="1" bordercolor="#F5EFEA" cellpadding="4" cellspacing="0">
<?php
if($_GET[action] == fromschool){
            echo "<tr><td colspan='8'>&nbsp;&nbsp;[<font color='blue'>";
			echo checklei($_GET[school],$tablepre.school,schoolid,schoolname);
			echo "</font>]&nbsp;内的店铺：</td></tr>";   
                              }
elseif($_GET[action] == fromtype){
            echo "<tr><td colspan='8'>&nbsp;&nbsp;属于[<font color='blue'>";
			echo checklei($_GET[type],$tablepre.shoptype,typeid,typename);
			echo "</font>]&nbsp;的店铺：</td></tr>";  
                                 }							  
?>
<tr align="center">
<td width="17%">店铺名称</td>
<td width="12%">标志</td>
<td width="15%">星级</td>
<td width="12%">掌柜</td>
<td width="10%">站内短信</td>
<td width="14%">交谈</td>
<td width="12%">开店时间</td>
<td width="8%">人气</td>
</tr>
<?php
while ($arr = $result->fetch_assoc())
{

?>
<tr align="center">
<td><a href="show_shop.php?shopid=<?php echo $arr[shopid]; ?>" target="_blank"><?php echo $arr[shopname]; ?></a></td>
<td><a href="show_shop.php?shopid=<?php echo $arr[shopid]; ?>" target="_blank"><img src="upload/shoplogo/<?php echo $arr[shopimg]; ?>" width="50" height="50" border="1"></a></td>
<td class="red"><img src="manage/img/<?php echo selectstar($arr[shopstar]); ?>"></td>
<td class="red"><?php echo $arr[shopowner]; ?></td>
<td><a href="user/user_mail.php?action=write&pmto=<?php echo $arr[shopowner]; ?>" target="_blank"><img src="skin/smallpic/22.gif" border="0" /></a></td>
<td><a target=blank href=tencent://message/?uin=<?php echo checklei($arr[shopowner],$tablepre.user,username,userqq); ?>&Site=www.lovestu.com&Menu=yes><img border="0" SRC=http://wpa.qq.com/pa?p=1:<?php echo checklei($arr[shopowner],$tablepre.user,username,userqq); ?>:7 alt="与店长交谈" /></a></td>
<td><?php echo $arr[shoptime]; ?></td>
<td><?php echo $arr[shophit]; ?></td>
</tr>
<?php
}
?>
<tr>
     <td align="right" colspan="8"><?php echo $showpage; ?>&nbsp;&nbsp;</td>
  </tr>
</table>