最新置顶头条文章标题加摘要显示的效果,把以下代码复制到module.php里面,如需调用分类置顶文章请把top='y'改为sortop='y'即可- <?php
* p' x3 P( o! S: u5 U6 P! k - //首页置顶头条,不带图片
% ^# u5 V* L% v/ Q; u4 y - function sheli_zdLog() {/ }& O; }" E% f( o. w
- $db = MySql::getInstance();2 u( g4 I9 H9 e9 F7 k
- $sql = "SELECT gid,title,content,date FROM ".DB_PREFIX."blog WHERE type='blog' and top='y' ORDER BY `top` DESC ,`date` DESC LIMIT 0,1";
; p% e( K5 S$ F% g6 @/ p1 t - $list = $db->query($sql);0 _3 `/ h' K) n5 ^1 e# E+ {) g
- while($row = $db->fetch_array($list)){
% k. a. T7 u( U! B% `' ^- ^& A8 J - //$row['content'] = htmlspecialchars($row['content']); m9 j0 U( T" e2 s
- $row['content'] = strip_TAGs($row['content']);?>0 e: ~5 Y" y5 k; X! I
- <h1><a href="<?php echo Url::log($row['gid']); ?>" title="<?php echo $row['title']; ?>" target="_blank"><?php echo $row['title']; ?></a></h1>; v6 D' ^8 F& I4 U7 a2 ]
- <span class="note"><?php echo mb_substr($row['content'],0,85,'utf-8'); ?>...</span><a href="<?php echo Url::log($row['gid']); ?>" target="_blank">阅读全文>></a>
4 g' w. D. W+ M4 F5 W: f - <?php } ?>
0 p& o1 ~; ~% K - <?php } ?>
复制代码 如果需要带图片请使用下面代码放入module.php中,如需调用首页置顶文章请把sortop='y'改为top='y'即可- <?php //分类置顶头条,带图片
1 i2 O$ W1 r: T8 X - function sheli_zdLog(){ $db = MySql::getInstance(); $sql = $db->query ("SELECT * FROM ".DB_PREFIX."blog inner join ".DB_PREFIX."sort WHERE hide='n' AND type='blog' AND sortop='y' AND sortid=sid order by date DESC limit 0,5"); while($row = $db->fetch_array($sql)){ if (!empty($row['excerpt'])){ preg_match_all("/\<img.*?src\="(.*?)"[^>]*>/i", $row['excerpt'], $match); if(empty($match[0][0])) { preg_match_all("/\<img.*?src\="(.*?)"[^>]*>/i", $row['content'], $match); } }else{ preg_match_all("/\<img.*?src\="(.*?)"[^>]*>/i", $row['content'], $match); } $logpost = !empty($row['excerpt']) ? $row['excerpt'] : ''.$row['content'].''; $num = rand(1,3); $img = isset($match[0][0]) ? $match[0][0] : '<img src="'.TEMPLATE_URL.'images/shuyong_net/'.$num.'.jpg">'; $date = gmdate('Y年m月d日', $row['date']); $content = strip_tags($logpost,''); $content = mb_substr($content,0,250,'utf-8');$comment = ($row['comnum'] != 0) ? '被吐槽<span>'.$row['comnum'].'</span>次' : '暂无吐槽'; $gid = $row['gid']; $tag = $db -> query("SELECT * FROM ".DB_PREFIX."tag WHERE gid LIKE '%,$gid,%'"); $out .='9 ~6 i$ v% j& y- Z# q* p2 f" O
- <div class="flash_img2">' C! k0 ?5 ~4 O( G4 C
- <div class="hdp_img"><a href="'.Url::log($row['gid']).'" title="'.$row['title'].'" >'.$img.'</a></div>
7 D' q1 v3 p6 O2 X# h' `( m - <div class="hdp"><h4><a href="'.Url::log($row['gid']).'" title="'.$row['title'].'">'.$row['title'].'</a></h4>
9 t: _) g- b9 v& Q1 Q4 b - <h5>日期:'.$date.' 分类:<a href="'.Url::sort($row['sortid']).'" title="查看 '.$row['sortname'].' 中的全部文章" rel="category tag">'.$row['sortname'].'</a> 共被围观 '.$row['views'].' 次 '.$comment.'</h5> # e. ?- v# ?( l9 M, {
- <h6>'.$content.'...</h6></div></div>& y* r+ r+ n5 M8 x$ Z
- '; } echo $out; }?>
复制代码 以上未提供CSS代码,请自行折腾7 A) S4 Y: N f$ a. P) p
|