='$fromtime' " : "" ;
$sql .= ($totime)? " and a.createdate<='$totime' " : "" ;
$sql .= " order by a.id desc";
$msg = "提交的条件：标题包含'$keywords'";
break;
case "brief":
$needfield = " a.magazineid,a.magpath,a.isspath,a.brief,a.title,a.createdate,a.id ";
$sql = " from bt_column_article a where ( a.brief like '%".$keywords."%' or a.title like '%".$keywords."%') ";
$sql .= ($magazineid) ? " and a.magazineid='$magazineid'" : "";
$sql .= ($fromtime)? " and a.createdate>='$fromtime' " : "" ;
$sql .= ($totime)? " and a.createdate<='$totime' " : "" ;
$sql .= " order by a.id desc";
$msg = "提交的条件：智能包含'$keywords'";
break;
case "words":
$needfield = " a.magazineid, a.magpath,a.isspath,a.brief,a.title,a.createdate,a.id ";
$sql = " from bt_column_article a,bt_article b where b.id=a.articleid and b.keywords like '%".$keywords."%' ";
$sql .= ($magazineid) ? " and a.magazineid='$magazineid'" : "";
$sql .= ($fromtime)? " and a.createdate>='$fromtime' " : "" ;
$sql .= ($totime)? " and a.createdate<='$totime' " : "" ;
$sql .= " order by a.id desc";
$msg = "提交的条件：关键字包含'$keywords'";
break;
case "author":
$needfield = " a.magazineid, a.magpath,a.isspath,a.brief,a.title,a.createdate,a.id ";
$sql = " from bt_column_article a,bt_article b where b.id=a.articleid and b.author like '%".$keywords."%' ";
$sql .= ($magazineid) ? " and a.magazineid='$magazineid'" : "";
$sql .= ($fromtime)? " and a.createdate>='$fromtime' " : "" ;
$sql .= ($totime)? " and a.createdate<='$totime' " : "" ;
$sql .= " order by a.id desc";
$msg = "提交的条件：作者包含'$keywords'";
break;
case "all":
if(trim($keywords))
{
$needfield = " a.magazineid, a.magpath,a.isspath,a.brief,a.title,a.createdate,a.id ";
$sql = " from bt_column_article a,bt_article b where ( (b.id=a.articleid and ( b.author like '%".$keywords."%' or b.keywords like '%".$keywords."%' ) ) or a.title like '%".$keywords."%' or a.brief like '%".$keywords."%' ) ";
$sql .= ($magazineid) ? " and magazineid='$magazineid'" : "";
$sql .= ($fromtime)? " and a.createdate>='$fromtime' " : "" ;
$sql .= ($totime)? " and a.createdate<='$totime' " : "" ;
$sql .= " order by a.id desc";
}
/* else
{
$sql = "select magazineid, magpath,isspath,brief,title,createdate,id from bt_column_article where id>0 ";
$sql .= ($magazineid) ? " and magazineid='$magazineid'" : "";
$sql .= ($fromtime)? " and createdate>='$fromtime' " : "" ;
$sql .= ($totime)? " and createdate<='$totime' " : "" ;
$sql .= " order by id desc";
}*/
$msg = "提交的条件：所有包含'$keywords'";
break;
}
if(!$totalnum)
{
$sql2 = "select distinct count(a.id) as tid ".$sql;
$totalnums = $DB_site->query_first($sql2);
$totalnum = $totalnums[tid];
$totalpages = intval($totalnum/$intLineNum);
if( !($totalnum%$intLineNum) ) $totalpages = $totalpages+1;
if($totalpages<=0) $totalpages=1;
}
// else
// {
// $sql = " select DISTINCT ".$needfield.$sql;
// }
$sqlinfo = "select DISTINCT ".$needfield.$sql." limit $start,$intLineNum";
// print $sqlinfo;
$result = $DB_site->query($sqlinfo);
$rowsNum = $DB_site->num_rows($result);
/*
if($intGotoPage){
$intOffset=($intGotoPage-1)*$intLineNum;
}
$intShowLine=$intLineNum;
$intLineFrom=$intOffset+1;
$intLineTo=$intLineFrom+$intShowLine -1;
if($rowsNum<$intLineTo) {
$intLineTo=$rowsNum;
$intShowLine=$rowsNum-$intLineFrom+1;
}*/
?>
--'.$totalpages.' --'.$intLineNum; ?> | |
| "; # $totalpages=($rowsNum-$rowsNum%$intLineNum)/$intLineNum; # if($rowsNum%$intLineNum) $totalpages+=1; for($i=1;$i<$intWhileNum+1;$i++){ $intOffsetNum=($intStartPage+($i-1))*$intLineNum; $intShowPage=($intStartPage+$i); if($intSelfLine==$intStartPage+$i){ #当前页不做联接 $return.=" ".$intShowPage." "; }else{ if($intShowPage<=$totalpages){ $return.=" ".$intShowPage.""; } } } $return.=" | "; $next_page=$intSelfLine+1; #下一页的页数 $return.="