php 文章调用类代码

$MyDatabase->ExecuteQuery ();
}
/**
* 根据文章编号，返回点击数
* @param $id 文章编号
*/
static public function GetHits($id){
$ReturnContent='';
//-------------------0
$SqlStr = 'SELECT `hits` FROM `' . DB_TABLE_PRE . 'article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
// var_dump($SqlStr);
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
}
return $ReturnContent;
}
/**
* 根据编号， 返回内容
* @param $id 文章编号
*/
function getContentById($id){
$ReturnContent='';
//-------------------0
$SqlStr = 'SELECT `content` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
}
return $ReturnContent;
}
/**
* 根据编号， 返回地址
* @param $id 文章编号
*/
function getUrlById($id){
$ReturnContent='';
//------------------0
$SqlStr = 'SELECT `reurl` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
if($ReturnContent==''){
$ReturnContent='article_details.php?id='.$id;
}
}
return $ReturnContent;
}
/**
* 根据编号， 返回静态页面地址
* @param $id 文章编号
*/
function getHTMLById($id){
$ReturnContent='';
//------------------0
$SqlStr = 'SELECT `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $ReturnContent = $MyDatabase->ResultArr [0][0];
return $ReturnContent;
}
/**
* 根据编号， 返回上一页
* @param 编号 $id
* @param 栏目编号 $cateid
*/
function getPrevById($id, $cateid){
$ReturnContent='没有文章';
//------------------0
$SqlStr = 'SELECT `title`, `html` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`<'.$id;
$SqlStr.= ' AND `cateid`='.$cateid;
$SqlStr.= ' AND `flag`=' . ARTICLE_FLAG;
$SqlStr.= ' ORDER BY `order` ASC, `id` desc';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) $ReturnContent = '<a href="'.$MyDatabase->ResultArr [0][1].'">'. subString($MyDatabase->ResultArr [0][0], 100) . '</a>';
return $ReturnContent;
}
/**
* 根据编号， 返回下一页
*
* @param 编号 $id
* @param 栏目编号 $cateid
*/
function getNextById($id, $cateid){
$ReturnContent='没有文章';