$template_url ='';
$SqlStr = ' SELECT `template_url`';
$SqlStr.= ' FROM `'.DB_TABLE_PRE.'view_articlecate` ';
$SqlStr.= ' WHERE `id`='.$cateid;
$SqlStr.= ' LIMIT 1';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()){
$template_url = $MyDatabase->ResultArr [0][0];
}
return($template_url);
}
/**
* 通过文章编号， 获取文章预览地址
* @param $cateid
*/
public static function getPreviewUrl($id){
$template_url ='';
$SqlStr = ' SELECT `template_url`';
$SqlStr.= ' FROM `'.DB_TABLE_PRE.'view_articlelist` ';
$SqlStr.= ' WHERE `id`='.$id;
$SqlStr.= ' LIMIT 1;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()){
$template_url = $MyDatabase->ResultArr [0][0];
}
return($template_url);
}
/**
* 更新HTML文件名
* @param $id 所属id,没有默认值，必须指定
* @param $posttime 提交时间,默认值为当前
*
* @return 更新后的地址
*/
function UpdateHTML($id, $posttime=''){
//如果没有日期，则获取当前时间
if ($posttime==''){
$posttime=time();
}else{
$posttime=strtotime($posttime);
}
$ArticlePath = date("ym",$posttime) . '/'. date("d",$posttime);
if (createFolder(ARTICLEPATH, $ArticlePath)){
$html = ARTICLEURL . $ArticlePath . '/' . date( "His", time() ) . rand( 1000, 9999 ) . '.html';
$MyDatabase=Database::Get();
$ArrField=array('html');
$ArrValue=array($html);
$MyDatabase->Update('article', $ArrField, $ArrValue, '`id`='.$id);
return($html);
}
}
/**
* 生成HTML文件
* @param $id
*/
function HTML($id){
}
/**
* 获取栏目名
*
* @param $id 文章栏目编号
*/
function getCate($cateid){
$level = $this->getLevelById($cateid);
$level_len= strlen($level) / 2 ;
//level列表
$level_str='0';
for ($i=1;$i<=$level_len;$i++){
$level_str.= ','.substr($level,0, 2*$i);
}
$navbar = '<a href="'. SITE_URL .'">首 页</a> >';
$SqlStr = ' SELECT * ';
$SqlStr.= ' FROM `'. DB_TABLE_PRE . 'article_cate`';
$SqlStr.= ' WHERE `level` in ('.$level_str.')';
$SqlStr.= ' ORDER BY `level` ASC';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$html = $DB_Record['id'];
if ($DB_Record['url']!='') $html=$DB_Record['url'];
$navbar.=' <a href="' . SITE_URL . SITE_FOLDER . CATEURL . $html .'/index.html">'. $DB_Record['title'] .'</a> >';
}
}
return $navbar;
}
}
?>
数据库
--
-- 表的结构 `mc_article`
--
CREATE TABLE IF NOT EXISTS `mc_article` (
`id` int(10) unsigned NOT NULL auto_increment COMMENT '编号',
`comment` tinyint(3) unsigned NOT NULL COMMENT '是否留言',
