php 文章调用类代码

//------------------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;
}
/**
* 根据level， 返回导航信息
* @param $level
*/
function getNavByLevel($level){
$ReturnContent=SITE_NAV;
$ReturnContent.=ARTICLE_NAV;
//$level=substr($level, 0, 2);
//$level='01010101';
$level_list='';
$level_len=strlen($level);
for ($i=2; $i<$level_len;$i+=2){
$level_list.=substr($level,0,$i) . ',';
}
$level_list.=$level;
// DebugStr( $level_list);
$SqlStr = 'SELECT * FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `level` in (' .$level_list . ')';
$SqlStr.= ' ORDER BY `level` ASC;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$levels = $MyDatabase->ResultArr;
foreach ($levels as $level){
$ReturnContent.=' <a href="'.$level['dir'].'">'.$level['title'].' ></a>';
}
}
return $ReturnContent;
}
/**
* 首页专用调用， 根据一个栏目编号， 返回该栏目下面的文章， 其中包括一张图片。
* @param $cateid
*/
function getPartByCateId($cateid){
$strReturn='<dl>';
$id=0;
$SqlStr = 'SELECT * 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 1;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
// DebugStr($SqlStr);
if ($MyDatabase->Query ()) {
$article = $MyDatabase->ResultArr[0];
$id = $article['id'];
$strReturn.='<dd><a href="'.$article['html'].'"><img src="'.$article['pic1'].'" width="145" height="120" /></a></dd>';
}
$strReturn.='<dt>';
//文章列表
$SqlStr = 'SELECT * FROM `'.DB_TABLE_PRE . 'view_article`';
$SqlStr.= ' WHERE `cateid` =' .$cateid;
$SqlStr.= ' AND `flag` ='.ARTICLE_FLAG;
$SqlStr.= ' AND `id` !='.$id;
$SqlStr.= ' ORDER BY `order` ASC, `id` DESC';
$SqlStr.= ' LIMIT 6;';
$MyDatabase=Database::Get();
$MyDatabase->SqlStr = $SqlStr;
if ($MyDatabase->Query ()) {
$articles = $MyDatabase->ResultArr;
$i=1;
foreach ($articles as $article){
if ($i==1){
$strReturn.='<a href="'.$article['html'].'" class="topic">'.subString($article['title'],34).'</a>';
}else{
$strReturn.='<a href="'.$article['html'].'">'.subString($article['title'],50).'</a>';