mation_list.php

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

<table width="100%" border="1" bordercolor="#F5EFEA" cellpadding="4" cellspacing="0">
<?php
if($_GET[action] == "" || $_GET[action] == news){
$sql = "SELECT * FROM ".$tablepre."news ORDER BY newsid DESC";
$result = $conn->query($sql);
$total=0;
while($akr=$result->fetch_assoc()){
       $total++;
	   }           
               $page = new ShowPage;   
               $page->PageSize = 20;  
			   $page->mode = "action=news&";  
               $page->Total = $total;   
               $page->LinkAry = array();                    
               $showpage = $page->ShowLink();
$result = $conn->query("SELECT * FROM ".$tablepre."news ORDER BY newsid DESC LIMIT ".$page->OffSet());
?>
<tr align="center" class="red">
<td width="8%">序号</td>
<td width="46%">新闻标题</td>
<td width="10%">状态</td>
<td width="25%">发表时间</td>
<td width="11%">人气</td>
</tr>
<?php
while($arr = $result->fetch_assoc())
{
?>
<tr align="center">
<td><?php echo $arr[newsid]; ?></td>
<td align="left">&nbsp;&nbsp;<a href="show_mation.php?action=news&newsid=<?php echo $arr[newsid]; ?>" target="_blank"><?php echo $arr[newsname]; ?></a></td>
<td>
<?php
$nowtime = date('Y-m');
$oldtime = substr($arr[newstime],0,7);
$nowday = date('d');
$oldday = substr($arr[newstime],8,2);
if($nowtime == $oldtime){
if($nowday - $oldday<4){
echo "<img src='skin/smallpic/new.gif' />";
}
else{
echo "<img src='skin/smallpic/25.gif' />";
}
}else{
echo "<img src='skin/smallpic/25.gif' />";
}
?>


</td>
<td><?php echo $arr[newstime]; ?></td>
<td><?php echo $arr[newshit]; ?></td>
</tr>
<?php
}
?>


<?php
}
else if($_GET[action] == ann){
$sql = "SELECT * FROM ".$tablepre."announce ORDER BY annid DESC";
$result = $conn->query($sql);
$total=0;
while($akr=$result->fetch_assoc()){
       $total++;
	   }            
               $page = new ShowPage;   
               $page->PageSize = 20;   
			   $page->mode = "action=ann&"; 
               $page->Total = $total;   
               $page->LinkAry = array();                    
               $showpage = $page->ShowLink();
$result = $conn->query("SELECT * FROM ".$tablepre."announce ORDER BY annid DESC LIMIT ".$page->OffSet());
?>
<tr align="center" class="red">
<td width="8%">序号</td>
<td width="46%">公告标题</td>
<td width="10%">状态</td>
<td width="25%">发表时间</td>
<td width="11%">人气</td>
</tr>
<?php
while($arr = $result->fetch_assoc())
{
?>
<tr align="center">
<td><?php echo $arr[annid]; ?></td>
<td align="left">&nbsp;&nbsp;<a href="show_mation.php?action=ann&annid=<?php echo $arr[annid]; ?>" target="_blank"><?php echo $arr[annname]; ?></a></td>
<td><?php
$nowtime = date('Y年m月');
$oldtime = substr($arr[anntime],0,10);
$nowday = date('d');
$oldday = substr($arr[anntime],11,2);
if($nowtime == $oldtime){
if($nowday - $oldday<3){
echo "<img src='skin/smallpic/new.gif' />";
}
else{
echo "<img src='skin/smallpic/25.gif' />";
}
}else{
echo "<img src='skin/smallpic/25.gif' />";
}
?></td>
<td><?php echo $arr[anntime]; ?></td>
<td><?php echo $arr[annhit]; ?></td>
</tr>
<?php
}
?>

</table>
<table width="100%" border="1" bordercolor="#F5EFEA" cellpadding="4" cellspacing="0">

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

?>
<tr align="center" class="red">
<td width="6%">序号</td>
<td width="45%">新闻标题</td>
<td width="8%">状态</td>
<td width="11%">所属店铺</td>
<td width="22%">发表时间</td>
<td width="8%">人气</td>
</tr>
<?php
while($arr = $result->fetch_assoc())
{
?>
<tr align="center">
<td><?php echo $arr[shnid]; ?></td>
<td align="left">&nbsp;&nbsp;<a href="show_mation.php?action=shn&shnid=<?php echo $arr[shnid]; ?>" target="_blank"><?php echo $arr[shntitle]; ?></a></td>
<td>
<?php
$nowtime = date('Y年m月');
$oldtime = substr($arr[shntime],0,10);
$nowday = date('d');
$oldday = substr($arr[shntime],11,2);
if($nowtime == $oldtime){
if($nowday - $oldday<3){
echo "<img src='skin/smallpic/new.gif' />";
}
else{
echo "<img src='skin/smallpic/25.gif' />";
}
}else{
echo "<img src='skin/smallpic/25.gif' />";
}
?>
</td>
<td><?php echo checklei($arr[newsowner],$tablepre.shop,shopowner,shopname); ?></td>
<td><?php echo $arr[shntime]; ?></td>
<td><?php echo $arr[shnhit]; ?></td>
</tr>
<?php
}
?>

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

?>
<tr align="center" class="red">
<td width="6%">序号</td>
<td width="45%">公告标题</td>
<td width="8%">状态</td>
<tD>所属店铺</tD>
<td width="22%">发表时间</td>
<td width="8%">人气</td>
</tr>
<?php
while($arr = $result->fetch_assoc())
{
?>
<tr align="center">
<td><?php echo $arr[shannid]; ?></td>
<td align="left">&nbsp;&nbsp;<a href="show_mation.php?action=shann&shannid=<?php echo $arr[shannid]; ?>" target="_blank"><?php echo $arr[shanntitle]; ?></a></td>
<td>
<?php
$nowtime = date('Y年m月');
$oldtime = substr($arr[shanntime],0,10);
$nowday = date('d');
$oldday = substr($arr[shanntime],11,2);
if($nowtime == $oldtime){
if($nowday - $oldday<3){
echo "<img src='skin/smallpic/new.gif' />";
}
else{
echo "<img src='skin/smallpic/25.gif' />";
}
}else{
echo "<img src='skin/smallpic/25.gif' />";
}
?>
</td>
<td><?php echo checklei($arr[annowner],$tablepre.shop,shopowner,shopname); ?></td>
<td><?php echo $arr[shanntime]; ?></td>
<td><?php echo $arr[shannhit]; ?></td>
</tr>
<?php
}
}
?>
<tr>
     <td align="right" colspan="5"><?php echo $showpage; ?>&nbsp;&nbsp;</td>
  </tr>
</table>