php 文章调用类代码

$str_return='';
//-------------------0------1------2---------3-------4--------5
$SqlStr = 'SELECT `title`, `id`, `reurl`, `html`, `pic1`, `memo` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `cateid`=' . $cateid;
$SqlStr.= ' AND `flag`=' . ARTICLE_FLAG;
$SqlStr.= ' AND `pic1`!=''';
$SqlStr.= ' ORDER BY `order` ASC, `id` DESC';
$SqlStr.= ' LIMIT ' . $limit;
//echo $SqlStr;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$DB_Record_Arr = $MyDatabase->ResultArr;
foreach ( $DB_Record_Arr as $DB_Record ) {
$DB_Record[0] = subString($DB_Record[0], 18);
$DB_Record[5] = subString($DB_Record[5], 56);
$url= $DB_Record[3];
if($DB_Record[2]!='') $url= $DB_Record[2];
$str_return.= '<dl>';
$str_return.= '<dd><a href="'.$url.'"><img src="'.$DB_Record[4].'" width="110" height="85" /></a></dd>';
$str_return.= '<dt><a href="'.$url.'">'.$DB_Record[0].'</a>'.$DB_Record[5].'<a href="'.$url.'" class="view">查看</a></dt>';
$str_return.= '</dl>';
}
}
return $str_return;
}
/**
* 根据ID， 返回下级最大分类。
*
* @param 编号 $id
*
*/
function getSIdById($id){
$ReturnContent='';
//------------------0------1
$SqlStr = 'SELECT `id` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `parentid`=' . $id;
$SqlStr.= ' ORDER BY `level` DESC';
// echo $SqlStr;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$ReturnContent = $MyDatabase->ResultArr [0][0];
}
return $ReturnContent;
}
/**
* 返回栏目标题
* @param $id 栏目编号
*/
function getCateTitleById($id){
$CateTitle='';
//-------------------0
$SqlStr = 'SELECT `title` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$CateTitle = $MyDatabase->ResultArr [0][0];
}
return $CateTitle;
}
/**
* 返回上级栏目ID
* @param $id 栏目编号
*/
function getParentCateIdById($id){
$CateTitle='';
//--------------------0
$SqlStr = 'SELECT `parentid` FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$CateTitle = $MyDatabase->ResultArr [0][0];
}
return $CateTitle;
}
/**
* 根据文章编号，增加一个点击
* @param $id 文章编号
*/
static public function UpdateHits($id){
//-------------------0
$SqlStr = 'UPDATE `' . DB_TABLE_PRE . 'article`';
$SqlStr.= ' SET `hits`=`hits`+1';
$SqlStr.= ' WHERE 1=1';
$SqlStr.= ' AND `id`='.$id;
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;