好!欢迎访问迷津渡口 现在时间是: 天气 °C ~ °C

迷津渡口

越感到迷惑 越接近真理

emlog实现全文和标题共同搜索

emlog默认搜索仅搜索标题,有些站长会需要搜索日志全文和标题,小指分享一下方法:

打开 include/controller/search_controller.php ,找到

$sqlSegment = "and title like '%{$keyword}%' order by date desc";

上面代码表示仅搜索标题


若需要仅搜索全文,可替换为:

$sqlSegment = "and content like '%{$keyword}%' order by date desc";


若需要同时搜索全文和标题,可替换为:

$sqlSegment = "and ( title like '%{$keyword}%' or content like '%{$keyword}%' ) order by date desc";


小指需要提醒一下,emlog默认仅搜索标题是比较合理的,因为如果文章太多,搜索会很慢甚至会造成服务器当机,所以站长根据自己的需要决定是否修改搜索方法哦~

点赞2
   支持一下
挤眼 亲亲 咆哮 开心 想想 可怜 糗大了 委屈 哈哈 小声点 右哼哼 左哼哼 疑问 坏笑 赚钱啦 悲伤 耍酷 勾引 厉害 握手 耶 嘻嘻 害羞 鼓掌 馋嘴 抓狂 抱抱 围观 威武 给力
 点赞
 签到
 表情
 图片
 代码
提交评论

清空信息
关闭评论
iamsamcollier
 iamsamcollier 2019-04-25 04:01回复
#161
<a href="http://www.gardensbyruth.com/nike-roshe-two-cuero-premium-vachetta-tan-chaussuresb">nike roshe two cuero premium vachetta tan</a> <a href="http://www.batemanafrica.com/under-armour-curry-1-low-noir-gum-obuvd">under armour curry 1 low noir gum</a> <a href="http://www.tritechems.com/nike-air-max-lunar-1-hvid-r%C3%B8d-hair-chaussuresa">nike air max lunar 1 hvid r酶d hair</a> <a href="http://www.malocalguide.com/nike-roshe-run-hyperfuse-rosso-butya">nike roshe run hyperfuse rosso</a> <a href="http://www.indeeprecords.com/air-max-thea-atomic-rosa-kleiderkreisel-scarpef">air max thea atomic rosa kleiderkreisel</a> <a href="http://www.clearancedept.com/adidas-rose-773-ii-maschio-basketbtutti-scarpa-zone-butyf">adidas rose 773 ii maschio basketbtutti scarpa zone</a>
iamsamcollier http://www.iamsamcollier.com/
villacafaggio
 villacafaggio 2019-04-24 17:46回复
#160
<a href="http://www.tmhits.net/air-jordan-retro-4.5-negro-plata-scarpee">air jordan retro 4.5 negro plata</a> <a href="http://www.trailspotters.net/air-max-90-royal-bl%C3%A5-and-hvit-butye">air max 90 royal bl氓 and hvit</a> <a href="http://www.trenchwars.net/herren-nike-lunar-ldv-mid-trail-laufen-schuhe-butyf">herren nike lunar ldv mid trail laufen schuhe</a> <a href="http://www.trionfodigalatea.net/air-jordan-9-retro-charcoal-for-vendita-used-schuhea">air jordan 9 retro charcoal for vendita used</a> <a href="http://www.tunnelcity.net/air-jordan-12-retro-low-wolf-gris-jack-chaussuresa">air jordan 12 retro low wolf gris jack</a> <a href="http://www.tvbkorea.net/nike-lebron-12-orange-s%C3%B8lv-obuva">nike lebron 12 orange s酶lv</a>
villacafaggio http://www.villacafaggio.net/
jrelselaw
 jrelselaw 2019-04-24 03:23回复
#159
<a href="http://www.mwartsdrama.com/mens-nike-air-max-lunar-1-red-white-shoesi">mens nike air max lunar 1 red white</a> <a href="http://www.meshmotors.com/herren-nike-air-max-tn-lila-rot-schuhei">herren nike air max tn lila rot</a> <a href="http://www.aspenmedisys.com/mujeres-air-max-90-em-todas-rojo-zapatosk">mujeres air max 90 em todas rojo</a> <a href="http://www.smartiesland.com/nike-air-force-1-bl%C3%A5-junior-skoi">nike air force 1 bl氓 junior</a> <a href="http://www.emcetolerie.com/mennns-nike-air-max-87-sb-gr%C3%B8nn-lilla-obuvl">mennns nike air max 87 sb gr酶nn lilla</a> <a href="http://www.lapaktoko.com/air-jordan-retro-6-all-yellow-shoesh">air jordan retro 6 all yellow</a>
jrelselaw http://www.jrelselaw.com/
volcom camo hat
 volcom camo hat 2019-04-23 14:27回复
#158
<a href="http://www.frankfurtstar.com/mens-nike-pittsburgh-steelers-17-joe-gilliam-limited-olivecamo-2017-salute-to-service-nfl-jersey-nflt">mens nike pittsburgh steelers 17 joe gilliam limited olivecamo 2017 salute to service nfl jersey</a> <a href="http://www.letsgosafar.com/mujeres-ralph-lauren-mesh-polo-caqui-negro-polor">mujeres ralph lauren mesh polo caqui negro</a> <a href="http://www.wennmarkets.com/nike-cortez-classic-39-runningf">nike cortez classic 39</a> <a href="http://www.jordanfemmes.com/prada-mens-2017-sneakers-outlet-prada064-pradar">prada mens 2017 sneakers outlet prada064</a> <a href="http://www.abctables.com/air-jordan-retro-9-grey-red-shoesa">air jordan retro 9 grey red</a> <a href="http://www.wozafriday.com/nike-lunar-hyperdunk-2013-mineral-teal-gr%C3%BCn-glow-kurpesa">nike lunar hyperdunk 2013 mineral teal gr眉n glow</a>
volcom camo hat http://www.upbigfoot.com/volcom-camo-hat-hatr
cnovas
 cnovas 2019-04-23 05:46回复
#157
<a href="http://www.teamdalarna.com/mens-nike-air-max-tailwind-7-grey-red-shoesi">mens nike air max tailwind 7 grey red</a> <a href="http://www.syairshamyoun.com/air-jordan-melo-schwarz-lila-schuhei">air jordan melo schwarz lila</a> <a href="http://www.fizalisfresh.com/nike-lebron-ambassador-9-rojo-negro-zapatosk">nike lebron ambassador 9 rojo negro</a> <a href="http://www.fsscas.com/kvinders-air-jordan-retro-2-alle-lyser%C3%B8d-skoi">kvinders air jordan retro 2 alle lyser酶d</a> <a href="http://www.imagimp.com/kvinners-asics-gel-noosa-tri-8-oransje-bl%C3%A5-obuvl">kvinners asics gel noosa tri 8 oransje bl氓</a> <a href="http://www.burmamaritime.com/nike-kaishi-run-womens-black-shoesh">nike kaishi run womens black</a>
cnovas http://www.cnovas.com/
merleflugge
 merleflugge 2019-04-22 04:43回复
#156
<a href="http://www.sumumcatering.com/gray-and-schwarz-nike-cortez-schuheh">gray and schwarz nike cortez</a> <a href="http://www.amsinconline.com/converse-all-star-low-tops-red-shoesk">converse all star low tops red</a> <a href="http://www.cavestt.com/michael-kors-mercer-clutch-mkh">michael kors mercer clutch</a> <a href="http://www.deshiresult.com/adidas-zx-flux-gull-gr%C3%A5-obuvi">adidas zx flux gull gr氓</a> <a href="http://www.quentsons.com/nike-roshe-grigio-and-oro-scarpek">nike roshe grigio and oro</a> <a href="http://www.steugenesband.com/purple-adidas-wrestling-shoes-shoesi">purple adidas wrestling shoes</a>
[url=http://www.merleflugge.com/]merleflugge[/url]
fotokompass
 fotokompass 2019-04-22 04:19回复
#155
<a href="http://www.houstonujc.com/nike-youth-o-j-howard-limited-red-jersey-tampa-bay-buccaneers-nfl-80-rush-vapor-untouchable-nflr">nike youth o j howard limited red jersey tampa bay buccaneers nfl 80 rush vapor untouchable</a> <a href="http://www.jetsonpress.com/mens-wilbert-montgomery-limited-camo-nike-jersey-nfl-philadelphia-eagles-31-2018-salute-to-service-nflw">mens wilbert montgomery limited camo nike jersey nfl philadelphia eagles 31 2018 salute to service</a> <a href="http://www.masadablog.com/nike-roshe-run-femminile-nero-cool-grigio-bianca-rosa-foil-schuheg">nike roshe run femminile nero cool grigio bianca rosa foil</a> <a href="http://www.soknorealtor.com/kd-7-cave-lilla-hyper-grape-scarpeg">kd 7 cave lilla hyper grape</a> <a href="http://www.donnaemendoza.com/nike-flynit-max-sort-bl%C3%A5-kurpesf">nike flynit max sort bl氓</a> <a href="http://www.erneyapi.com/adidas-john-wall-3-dark-bl%C3%A5-schuheg">adidas john wall 3 dark bl氓</a>
fotokompass http://www.fotokompass.com/
axxisdrilling
 axxisdrilling 2019-04-22 01:50回复
#154
<a href="http://www.sumumcatering.com/m%C3%A6nd-nike-kobe-9-gr%C3%A5-sort-hvid-skok">m忙nd nike kobe 9 gr氓 sort hvid</a> <a href="http://www.amsinconline.com/air-max-2014-alle-schwarz-schuheh">air max 2014 alle schwarz</a> <a href="http://www.cavestt.com/completely-black-converse-shoesk">completely black converse</a> <a href="http://www.deshiresult.com/nike-free-run-3.0-v6-m%C3%A6nd-sort-bl%C3%A5-skol">nike free run 3.0 v6 m忙nd sort bl氓</a> <a href="http://www.quentsons.com/nike-kaishi-run-gr%C3%A5-and-hvit-obuvk">nike kaishi run gr氓 and hvit</a> <a href="http://www.steugenesband.com/nike-free-3.0-maschio-grigio-bianca-scarpei">nike free 3.0 maschio grigio bianca</a>
axxisdrilling http://www.axxisdrilling.com/
xthbgc
 xthbgc 2019-04-19 22:34回复
#153
<a href="http://www.laketreepress.com/nike-kobe-icon-gr%C3%B8n-skol">nike kobe icon gr酶n</a> <a href="http://www.prohaarklinik.com/ralph-lauren-gingham-short-sleeve-shirt-poloh">ralph lauren gingham short sleeve shirt</a> <a href="http://www.bonfanticare.com/nike-kobe-8-orange-grey-shoesi">nike kobe 8 orange grey</a> <a href="http://www.antoniopagni.com/womens-nike-free-tr-red-yellow-shoesp">womens nike free tr red yellow</a> <a href="http://www.wcshosting.com/kvinners-nike-air-max-90-all-rosa-obuvl">kvinners nike air max 90 all rosa</a> <a href="http://www.biddingstream.com/herre-nike-flyknit-lunar-1-lilla-guld-skoj">herre nike flyknit lunar 1 lilla guld</a>
xthbgc http://www.xthbgc.com/
chrisglahn
 chrisglahn 2019-04-19 03:49回复
#152
<a href="http://www.kafsabimoradi.com/frau-nike-air-max-2019-off-wei%C3%9F-triple-schwarz-schuhek">frau nike air max 2019 off wei脽 triple schwarz</a> <a href="http://www.henryglegg.com/nike-city-sandal-iii-dark-bl%C3%A5-gul-24-35-skoi">nike city sandal iii dark bl氓 gul 24 35</a> <a href="http://www.theillitches.com/nike-zoom-tout-out-gris-chaussuresh">nike zoom tout out gris</a> <a href="http://www.thomsank.com/new-york-mets-under-armour-mlb-twist-closer-cap-hatl">new york mets under armour mlb twist closer cap</a> <a href="http://www.youdaanl.com/nike-air-force-1-high-blanc-prix-chaussuresh">nike air force 1 high blanc prix</a> <a href="http://www.sactopalooza.com/thea-nike-air-max-negro-zapatosk">thea nike air max negro</a>
chrisglahn http://www.chrisglahn.com/
顶部留言底部
 00:00/00:00
我想和你虚度时光 - 花房姑娘(9)
  1. 我想和你虚度时光
  2. 花房姑娘
  3. 恋恋风尘
  4. 我喜爱一切不彻底的事物
  5. 我的心里是满的
  6. Long Way
  7. 给少年的歌
  8. 晴日共剪窗
  9. 天上的月你的脸