second_list.php

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

<?php
if($_POST[message] == searchsecond){
          $sectype = $_POST[sectype];
		  $secschool = $_POST[secschool];
		  $secname = $_POST[secname];
		  $result = $conn->query("SELECT * FROM ".$tablepre."second WHERE secondlei='$sectype' AND secondschool='$secschool' AND secondname LIKE '%$secname%'");
		  $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."second WHERE secondlei='$sectype' AND secondschool='$secschool' AND secondname LIKE '%$secname%' ORDER BY secondid DESC LIMIT ".$page->OffSet());
		  
	
	 }
elseif($_GET[action] == "" || $_GET[action] == news){
$sql = "SELECT * FROM ".$tablepre."second ORDER BY secondid 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."second ORDER BY secondid DESC LIMIT ".$page->OffSet());
}
else if($_GET[action] == hot){
$sql = "SELECT * FROM ".$tablepre."second ORDER BY secondhit 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."second ORDER BY secondhit DESC LIMIT ".$page->OffSet());

}			   
elseif($_GET[action] == fromtype){
                       $typeid = $_GET[type];
					   $result = $conn->query("SELECT * FROM ".$tablepre."second WHERE secondtp='$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."second WHERE secondtp='$typeid' ORDER BY secondid DESC LIMIT ".$page->OffSet());

								  }
?>
<table width="100%" border="1" bordercolor="#F5EFEA" cellpadding="2" cellspacing="0">
<?php
if($_GET[action] == fromtype){
            echo "<tr><td colspan='6'>  属于[<font color='blue'>";
			echo checklei($_GET[type],$tablepre.sectype,sectpid,sectpname);
			echo "</font>] 的二手信息：</td></tr>";  
                                 }							  
?>
<tr align="center">
<td width="7%">状态</td>
<td width="7%">类型</td>
<td width="44%">二手标题</td>
<td width="18%">所在地点</td>
<td width="15%">发布时间</td>
<td width="9%">人气</td>
</tr>
<?php
while ($arr = $result->fetch_assoc())
{

?>
<tr align="center">
<td>
<?php
$nowtime = date('Y年m月');
$oldtime = substr($arr[secondtime],0,10);
$nowday = date('d');
$oldday = substr($arr[secondtime],10,2);
if($nowtime == $oldtime){
if($nowday - $oldday<3){
echo "<img src='skin/smallpic/24.gif' />";
}
else{
echo "<img src='skin/smallpic/23.gif' />";
}
}else{
echo "<img src='skin/smallpic/23.gif' />";
}
?>
</td>
<td>[<?php echo mationlei($arr[secondlei]); ?>]</td>
<td align="left">&nbsp;&nbsp;<a href="show_second.php?secid=<?php echo $arr[secondid]; ?>" target="_blank"><?php echo $arr[secondname]; ?></a></td>
<td><?php echo checklei($arr[secondschool],$tablepre.school,schoolid,schoolname); ?></td>
<td><?php echo substr($arr[secondtime],0,14); ?></td>
<td><?php echo $arr[secondhit]; ?></td>
</tr>
<?php
}
?>
<tr>
     <td align="right" colspan="7"><?php echo $showpage; ?>&nbsp;&nbsp;</td>
  </tr>
</table>