searchzhai1.php

PHP免费网摘程序 详细说明: 安装说明： 1、把文件上穿上去以后

<? include("conn.php");?>
<? include("include/function.php");?>
<? include("include/setup.php");?>
<? include("head.php");?>
<?
 
 $sort=$_GET['sort'];
 $title=$_GET[title];
?>
<table width="760" align="center">
  <tr>
    <td><table width="500" height="27"  border="0" cellpadding="0" cellspacing="0">
        <tr align="center">
             <td width="80" class="bgtitley"><a href="listzhai.php?type=hot24"  >24小时点击</a></td>
          <td width="80" class="bgtitley"><a href="listzhai.php?type=hot48"  >48小时点击</a></td>
          <td width="80" class="bgtitley"><a href="listzhai.php?type=week"  >周热点点击</a></td>
          <td width="80" class="bgtitley"><a href="listzhai.php?type=new"  >最 新 收 藏</a></td>
          <td width="80" class="bgtitley"><a href="myzhai.php"  >我 的 收 藏</a></td>
          <td width="80" class="bgtitlen"><a href="searchzhai.php?sort=<? echo $sort;?>&title=<? echo $title;?>"  ><? echo $sort;?>收藏</a></td>
          <td class="bgtail">&nbsp;</td>
        </tr>
    </table></td>    
  </tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="610"><table width="100%" border="0" cellspacing="3">
		<?
		$rcperpage=30;  
		 
		
 
 
 
				
		$page=$_GET[page];
		if(!$page){
			$page=1;
		}
		if($sort=="标签"){
			$sql="select id, title,userid,fromurl,tags, intro from zhai where tags  like '%$title%' and ispub='1'  order by id desc limit ".trim(($page-1)*$rcperpage).",$rcperpage";
		$tsql="select count(*) as c from zhai where tags  like '%$title%' and ispub='1'";
		
		}else{
			$sql="select id, title,userid,fromurl,tags, intro from zhai where title like '%$title%' and ispub='1'  order by id desc limit ".trim(($page-1)*$rcperpage).",$rcperpage";
		    $tsql="select count(*) as c from zhai where title like '%$title%' and ispub='1'   ";
		 }
		 
		 $pgcount=$_GET[pacount];
		 if(!$pgcount){
		 $tqr=mysql_query($tsql);
		 $total=mysql_fetch_array($tqr);
		 
		 
		 $pgcount=floor((chop($total[0])-1)/$rcperpage)+1; 
		 }
		 
		 
     $qr=mysql_query($sql);
		while($rs=mysql_fetch_array($qr)){
		 
				echo("<tr>");
				echo("<td><span class='grayscript'>?¤</span><a href='/html/".$rs[id].".htm' target='_blank' title='".$rs[intro]."'>".$rs[title]."</a> <span class='grayscript'>(<a href='userzhai.php?zhaiuser=".$rs[userid]."'>".$rs[userid]."</a> ");
				
				
				echo("收藏)</span> <a href=".$rs[fromurl]." target='_blank'><img src='images/icon-link.gif' width='13' height='11' border='0'  ></a></td>");
				 
				$row=$row+1;
				echo("</tr>");
			}
		 
		
		if($row<$rcperpage){
			for($i=0;$i<($rcperpage-$row);$i++){
				echo("<tr>");
				echo("<td>&nbsp;</td>");
				echo("</tr>");
			}
			}
 
		;?>	
		<tr align="right">
			<td></br>第 <? echo $page;?> 页 共 <? echo $pgcount;?> 页
			<?			
			if($page>1){
				echo(" <a href='searchzhai.php?sort=".$sort."&title=$title&page=1&pgcount=$pgcount'>第一页</a>");
				echo(" <a href='searchzhai.php?sort=".$sort."&title=$title&pgcount=$pgcount&page=".($page-1)."'>上一页</a>");
			}else{
				echo(" 第一页");
				echo(" 上一页");
			}
			if($page < $pgcount){
				echo(" <a href='searchzhai.php?sort=".$sort."&title=$title&pgcount=$pgcount&page=".($page+1)."'>下一页</a>");
				echo(" <a href='searchzhai.php?sort=".$sort."&title=$title&pgcount=$pgcount&page=".$pgcount."'>最末页</a>");
			}else{

				echo(" 下一页");
				echo(" 最末面");
			}			
			;?>				
		  </td>
		</tr>          
    </table></td>
    <td width="150">&nbsp;</td>
  </tr>
</table>
<? include("bottom.php");?>