zhai.php

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

<? include("conn.php");?>
<? include("include/function.php");?>
<? include("include/setup.php");?>
<?
 
 $listtype=$_GET[type];
 if($listtype=="hot24"){
	 $days=1;
 }else{if($listtype=="hot48"){
	 $days=2;
 }else{if($listtype=="week"){
	 $days=7;
 }
?>
		<?
		$rcperpage=12; //每页显示数
		 $page=$_GET[page];
		if(!$page){
			$page=1;
		}
		if($listtype=="new"){
			$sql="select id, title,userid,fromurl, intro from zhai where ispub='1'  order by id desc  limit ".trim(($page-1)*$rcperpage).",$rcperpage";
		}else{
			$sql="select id, title,userid,fromurl, intro,b.zhaiid,b.visits from zhai a, (select zhaiid,count(*) as visits from visit where int(now-VisitTime)<="&days&" group by zhaiid order by count(*) desc) b where id=b.zhaiid and ispub='1'  order by visits desc  limit ".trim(($page-1)*$rcperpage).",$rcperpage";
		}		
		
		$query=mysql_query($sql);
		while($rs=mysql_fetch_array($query)){
			 
			 
				echo("<span class='grayscript'>·</span><a href='/html/".$rs[id].".htm' target='_blank' title='".$rs[intro]."'>".$rs[title]."</a> <span class='other'>(<a href='userzhai.php?zhaiuser=".$rs[userid]."'>".$rs[userid]."</a> ");
				
				
				echo("收藏)</span> <a href=".$rs[fromurl]." target='_blank'><img src='images/icon-link.gif' border='0' alt='网摘链接'></a><br />")
				
				$row=$row+1;
				echo("</td>");
			 
		}
?>