php 文章调用类代码

//时间格式化
if ($posttime_format!=''){
$posttime=date($posttime_format, $posttime);
}else {
$posttime=date('Y-m-d H:i', $posttime);
}
//替换各个内容
//标题
$Arr_Search = array('{id}', '{title_full}', '{title}', '{title2}', '{titlestrip}', '{memo}', '{html}', '{hits}', '{posttime}', '{catetitle}', '{catedir}', '{pic}', '{pic1}', '{pic2}', '{loop}', '{catedesc}');
$Arr_Replace = array($id, $title_full, $title, $title2, $titlestrip, $memo, $html, $hits, $posttime, $catetitle, $catedir, $pic, $pic1, $pic2, $loop++, $catedesc);
$Str_Loop=str_replace($Arr_Search, $Arr_Replace, $Str_Loop);
$ReturnString.=$Str_Loop;
}
}
//用完清空
$this->Clear();
return $ReturnString;
}
/**
* 返回栏目里面的html
*/
function DefaultHtml(){
$html='';
$this->InitSql();
//-------------------0
$SqlStr = 'SELECT `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.=$this->SqlCateId;//栏目
$SqlStr.=$this->SqlFlag;//状态
$SqlStr.=$this->SqlOrder;//排序
$SqlStr.=$this->SqlLimit;//显示个数
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$html = $MyDatabase->ResultArr [0][0];
}
return $html;
}
/**
* 获取栏目地址
* @param $id 栏目编号
*/
static public function getCateHTML($id){
$html = '';
$SqlStr = 'SELECT `dir` FROM `'.DB_TABLE_PRE . 'article_cate`';
$SqlStr.= ' WHERE `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$html = $MyDatabase->ResultArr [0][0];
}
return $html;
}
/**
* 返回栏目标题
*/
function getCateTitle(){
$CateTitle='';
//-------------------0
$SqlStr = 'SELECT `title` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.=$this->SqlCateTitleId; //栏目
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$CateTitle = $MyDatabase->ResultArr [0][0];
}
return $CateTitle;
}
/**
* 获取文章日期返回一个以 2011-1 这种类型的列表链接
*/
function getArticListDate(){
//栏目编号
$CateId=$this->CateId;
if (strpos($CateId, ',')) {
$this->SqlCateId=' AND `cateid` in ('.$CateId.')';
} elseif ($CateId>0) {
$this->SqlCateId=' AND `cateid` ='.$CateId;
}
$cateList='';
$intCount=0;
$strSearch=''; //搜索年月
$strMonth=''; //月名
//获取今天的年-月
$year=date("Y",time());
$month=date("m",time());
//今年
$SqlStr = 'SELECT COUNT( * ) from `'.DB_TABLE_PRE . 'view_article`'.' WHERE DATE_FORMAT(`posttime`, '%Y')=''.$year.''';
//栏目
$SqlStr.=$this->SqlCateId;
$MyDatabase->SqlStr = $SqlStr;
$MyDatabase=Database::Get();
if ($MyDatabase->Query ()) {
$intCount = $MyDatabase->ResultArr [0][0];