union.php

来自「PHP免费网摘程序 详细说明: 安装说明： 1、把文件上穿上去以后」· PHP 代码 · 共 72 行

<? include("conn.php");?>
<? include("include/function.php");?>
<? include("include/setup.php");?>
<? include("include/file.php");?>
<?  
 ob_end_clean();
 
 $rcperpage=10; //每页显示数		
 
 
 //类别最新
    $title="体育";
	$sql="select id,title,userid,fromurl,tags, intro from zhai where tags  like '%$title%' and ispub='1'  order by id desc limit 12";
     $query=mysql_query($sql);
		while($rs=mysql_fetch_array($query)){
					 
				$ty[]=$rs;
		}
 
   //热门标签
  
       $sql="select  tag,sum(num) as num from tags group by tag order by num desc,tag limit 8";
       
       $query=mysql_query($sql);
       while($rs=mysql_fetch_array($query)){
        
      $hottags[]=$rs;
         
       }
    
   
 //推荐用户
 
       $sql="select  userid, zhainum from myuser   order by zhainum desc  limit 10 ";
       
       $query=mysql_query($sql);
       while($rs=mysql_fetch_array($query)){
         
        $gooduser[]=$rs;
         
       }
       
//友情连接
		       $sql="select   * from links where ismain='1' and isshow='1' order by showorder limit 10";
		       
		       $query=mysql_query($sql);
		       while($rs=mysql_fetch_array($query)){
		         
		         $link[]=$rs;
		       }
		          
//最新收藏
		$qr=mysql_query("select   * from zhai where ispub='1'  order by id desc limit 10");
		while($rszhai=mysql_fetch_array($qr)){
		$rszhai[title]=sub($rszhai[title],44);
			$new[]=$rszhai;
		 }
		 
		
		$readtpl='index';
$db_obstart==1 ? ob_start('ob_gzhandler') : ob_start();
			$db_bbsname_a=addslashes($db_bbsname);//模版内用到
			 
 require_once(PrintEot($readtpl));
 $content=ob_get_contents();
 
writeover("union.htm",$content,"rb+",0);
ob_end_clean();
header("Location:union.htm");
	  ;?>