最新的list.php的代码,做起来应该很轻松了 不指定

Else , 2008/06/26 15:46 , 代码片段,演示也有 , Comments(0) , Reads(1558) , Via Original
[codes=php]require_once("data/conn.php");  
require_once("class/cuku.php");
$db = new Dirver();  
$ck = new Cuku();
$time_start = $ck->getmicrotime();
$db->DBLink($db_server,$db_username,$db_password,$db_name);
#以上是mysql数据库文件的设置
include("public.php");  
//声明类
#得到这个分类的id
$Php2Html_FileUrl = $_SERVER["REQUEST_URI"];
$Php2Html_UrlString = str_replace("/", "", strrchr($Php2Html_FileUrl, "/"));
$sid=intval(intval($Php2Html_UrlString));//Integer type variable conversion
  if (!intval($sid))
  {
    $sid=intval($_GET['id']);
    if(!intval($sid))
    {
      $sid=3;
    }
  }
#显示网站大类
    
  $subarr=$db->rows("SELECT id,catname,pcatid FROM ck_cat where id=$sid and view=1 order by list asc");        
  $arr=$db->rows(sprintf("SELECT id,catname FROM ck_cat where id=%d and view=1 order by list asc",$subarr[pcatid]));  
  $catmenus=$ck->et_list("SELECT id,catname,content FROM ck_cat where pcatid=0 and view=1 order by list asc",0);

#列出当前面的其它分类
  $sub_menu=$db->query(sprintf("SELECT id,catname,content FROM ck_cat
                   WHERE pcatid=%d and view=1
                   ORDER BY list ASC",$arr[id]));
#分页显示

    //处理分页
    
  $list=$ck->et_page("select id,countruby as jsq,title,left(`datetime`,10) as `time`,countruby,left(content,500) as content from ck_ruby where menu=$sid order by id desc",20);
  $pageinfo=$ck->et_pageinfo();

  //连载
$tl->set_file('list');
$tl->n();
$time = $ck->getmicrotime()-$time_start;
$tl->p('list');
$db->close();
?>[/codes]
Tags:
Add a comment

Nickname

Site URI

Email

Enable HTML Enable UBB Enable Emots Hidden Remember [Login] [Register]