最新的list.php的代码,做起来应该很轻松了
[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]?phpbr>
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]?phpbr>
C#的时间正则表达式
在次简化 et 的程序设计
