1Next >
pktsandy | 发表于:10-09-17 09:39 [添加收藏] 楼主 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
类4 BLOG中的!如果不明白看看我的BLOG吧!随便推广一下:
Ta最近还发表过
[分享]
MYSQL5.5的中文手册
(19-03-22)
[分享]
留言的修改版
(18-02-26)
[分享]
KC PHP源代码剖析(慢慢补充)
(16-02-18)
[使用]
新闻内容页的分页
(14-08-24)
[使用]
货栈评论JS动态翻页
(13-11-08)
随机阅读
[建议]
这次我们KC 升级之后有帖内回复模式和 @ 功能没有?
(14-07-07)
[疑问]
K9的功能
(13-08-27)
[使用]
找个美工不错的建个普通企业网站
(12-06-25)
[其他]
电脑机箱没了哈
(12-05-21)
[分享]
kingcms5.1 asp版修改搜索页列表显示样式
(12-04-26)
|
pktsandy | 发表于:10-09-17 09:41 沙发 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
不明白怎么调用的看我写的另一篇:
文章的相关记录SQL语句 http://www.kingcms.com/forums/Share/t11119/ 这个只要开启dbquery模块就可以了 |
pktsandy | 发表于:10-09-17 09:45 板凳 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
如果你用的不是MySQL只要对应手册找关于null的判断即可.KC PHP的kpath的列定义不允许NULL.当当前文章是第一条或最后一条时上一条或下一条为NULL
|
pktsandy | 发表于:10-09-17 10:35 4楼 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
templateinsidearticle[page]default.htm
<h1>{king:title/}</h1> <p> 来源: {king:_source split="|"} <a href="{king:_source_2/}" target="_blank">{king:_source_1/}</a> {/king:_source} 作者:{king:_author/} 热度:{king:hit/} 日期:{king:date formatdate="y-m-d, h:i A"/} <div id="article_navi"> <ul> {king:dbquery query="SELECT MAX(p.kid) AS ID,ktitle,IFNULL(kpath,'')AS path FROM king__article p WHERE p.kid<(king:kid/) and p.listid=(select listid from king__article where kid=(king:kid/)) UNION SELECT MIN(n.kid) AS ID,ktitle,IFNULL(kpath,'')AS path FROM king__article n WHERE n.kid>(king:kid/) and n.listid=(select listid from king__article where kid=(king:kid/))"} <li><a href="{king:path/}">{king:ktitle/}</a></li> {/king:dbquery} </ul> </div> ... 用一幅宽500px高35的背景图+下面的CSS #article_navi{float:left;width:100%;border:1px solid #ddd;} #article_navi ul{float:left;margin:0;padding:0;list-style:none;height:35px;width:500px;background-image:url(_r1_c1.gif);} #article_navi ul li{float:left;width:200px;padding:10px 0 0 50px;} 效果图如下: |
pktsandy | 发表于:10-09-17 14:59 编辑于:09-17 16:48 5楼 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
非图片背景版:
<div id="article_navi"><ul> {king:dbquery query="SELECT MAX(p.kid) AS ID,p.ktitle,IFNULL(p.kpath,'')AS path,pd.pd_ID AS PID FROM king__article p,(select listid AS m_id,kid AS pd_ID from king__article where kid=(king:kid/)) pd WHERE p.kid<pd.pd_ID and p.listid=pd.m_id UNION SELECT MIN(n.kid) AS ID,n.ktitle,IFNULL(n.kpath,'')AS path,nd.nd_ID AS PID FROM king__article n,(select listid AS m_id,kid AS nd_ID from king__article where kid=(king:kid/)) nd WHERE n.kid>nd.nd_ID and n.listid=nd.m_id"} <?php $prom_title=({king:ID/}<{king:PID/})?"上一篇":"下一篇"; if(!is_null("{king:ktitle/}")){ echo "<li>".$prom_title.": <a href="{king:path/}">{king:ktitle/}</a></li>"; }?> {/king:dbquery} </ul></div> |
pktsandy | 发表于:10-09-17 15:04 6楼 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
SQL语句的可读版
SELECT MAX(p.kid) AS ID, p.ktitle, IFNULL(p.kpath,'')AS path, pd.pd_ID AS PID FROM king__article p, (select listid AS m_id,kid AS pd_ID from king__article where kid=11) pd WHERE p.kid<pd.pd_ID and p.listid=pd.m_id UNION SELECT MIN(n.kid) AS ID, n.ktitle, IFNULL(n.kpath,'')AS path, nd.nd_ID AS PID FROM king__article n, (select listid AS m_id,kid AS nd_ID from king__article where kid=11) nd WHERE n.kid>nd.nd_ID and n.listid=nd.m_id; |
pktsandy | 发表于:10-09-17 15:08 7楼 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
|
pktsandy | 发表于:10-09-18 07:50 8楼 [回复] #Top# |
---|---|
人气:1181
积分:3438
金币:29313
|
即使你用有背景的图片来显示上一篇和下一篇也推荐用下面的SQL。
这条SQL需要的开销比较大: SELECT MAX(p.kid) AS ID, ktitle, IFNULL(kpath,'')AS path FROM king__article p WHERE p.kid<(king:kid/) and p.listid=(select listid from king__article where kid=(king:kid/)) UNION SELECT MIN(n.kid) AS ID, ktitle, IFNULL(kpath,'')AS path FROM king__article n WHERE n.kid>(king:kid/) and n.listid=(select listid from king__article where kid=(king:kid/)) |
1Next >