看PHP如何实现多关键字加亮_PHP教程

php中文网
发布: 2016-07-20 10:58:13
原创
824人浏览过

项目结构:

\

开始搜索:   这里搜索关键字("大""这")

\

搜索结果:  高亮显示

\

项目所需数据库结构:

\

实现代码:

立即学习PHP免费学习笔记(深入)”;

conn.php

腾讯智影-AI数字人
腾讯智影-AI数字人

基于AI数字人能力,实现7*24小时AI数字人直播带货,低成本实现直播业务快速增增,全天智能在线直播

腾讯智影-AI数字人 73
查看详情 腾讯智影-AI数字人
<ol class="dp-c"><li class="alt"><span><span><?php  </span></span></li><li class="alt"><span class="vars">$conn</span><span> = @ mysql_connect(</span><span class="string">"localhost"</span><span>, </span><span class="string">"root"</span><span>, </span><span class="string">""</span><span>) </span><span class="keyword">or</span><span> </span><span class="keyword">die</span><span>(</span><span class="string">"数据库链接错误"</span><span>);  </span></li><li><span>mysql_select_db(</span><span class="string">"form"</span><span>, </span><span class="vars">$conn</span><span>);  </span></li><li class="alt"><span>mysql_query(</span><span class="string">"set names 'gbk'"</span><span>);   </span></li><li><span>?> </span></li></ol>
登录后复制

searchAndDisplayWithColor.php

  
<ol class="dp-c"><li class="alt"><span><span><?php  </span></span></li><li><span class="keyword">include</span><span> </span><span class="string">'conn.php'</span><span>;  </span></li><li class="alt"><span>?>  </span></li><li><span><table width=500 align=</span><span class="string">"center"</span><span>>  </span></li><li class="alt"><span>     <form action=</span><span class="string">""</span><span> method=</span><span class="string">"get"</span><span>>  </span></li><li><span>     <tr>  </span></li><li class="alt"><span>         <td>关键字:<input type=</span><span class="string">"text"</span><span> name=</span><span class="string">"keyWord"</span><span> />  </span></li><li><span>         <input type=</span><span class="string">"submit"</span><span> value=</span><span class="string">"搜索"</span><span> /></td>  </span></li><li class="alt"><span>     </tr>  </span></li><li><span>     </form>  </span></li><li class="alt"><span> </table>  </span></li><li><span>   </span></li><li class="alt"><span> <table width=500 border=</span><span class="string">"0"</span><span> align=</span><span class="string">"center"</span><span> cellpadding=</span><span class="string">"5"</span><span> </span></li><li><span>     cellspacing=</span><span class="string">"1"</span><span> bgcolor=</span><span class="string">"#add3ef"</span><span>>  </span></li><li class="alt"><span>     <?php  </span></li><li><span>     </span><span class="comment">//关键字不为空的时候才执行相关搜索 </span><span> </span></li><li class="alt"><span>     </span><span class="keyword">if</span><span>(</span><span class="vars">$_GET</span><span>[</span><span class="string">'keyWord'</span><span>]){  </span></li><li><span>     </span><span class="comment">//用空格符把关键字分割开 </span><span> </span></li><li class="alt"><span>     </span><span class="vars">$key</span><span>=</span><span class="func">explode</span><span>(</span><span class="string">' '</span><span>, </span><span class="vars">$_GET</span><span>[keyWord]);  </span></li><li><span>     </span><span class="vars">$sql</span><span>=</span><span class="string">"select * from message where title like '$key[0]' or title like '$key[1]' or content like '$key[0]' or content like '%$key[1]%'"</span><span>;  </span></li><li class="alt"><span>     </span><span class="vars">$query</span><span>=mysql_query(</span><span class="vars">$sql</span><span>);  </span></li><li><span>     </span><span class="keyword">while</span><span> (</span><span class="vars">$row</span><span>=mysql_fetch_array(</span><span class="vars">$query</span><span>)){  </span></li><li class="alt"><span>         </span><span class="comment">//替换关键字,并且把关键字高亮显示 </span><span> </span></li><li><span>         </span><span class="vars">$row</span><span>[title]=preg_replace(</span><span class="string">"/$key[0]/i"</span><span>, </span><span class="string">"<font color=red><b>$key[0]</b></font>"</span><span>, </span><span class="vars">$row</span><span>[title]);  </span></li><li class="alt"><span>         </span><span class="vars">$row</span><span>[title]=preg_replace(</span><span class="string">"/$key[0]/i"</span><span>, </span><span class="string">"<font color=red><b>$key[1]</b></font>"</span><span>, </span><span class="vars">$row</span><span>[title]);  </span></li><li><span>         </span><span class="vars">$row</span><span>[content]=preg_replace(</span><span class="string">"/$key[0]/i"</span><span>, </span><span class="string">"<font color=red><b>$key[0]</b></font>"</span><span>, </span><span class="vars">$row</span><span>[content]);  </span></li><li class="alt"><span>         </span><span class="vars">$row</span><span>[content]=preg_replace(</span><span class="string">"/$key[1]/i"</span><span>, </span><span class="string">"<font color=red><b>$key[1]</b></font>"</span><span>, </span><span class="vars">$row</span><span>[content]);  </span></li><li><span>         ?>  </span></li><li class="alt"><span>   </span></li><li><span>     <tr bgcolor=</span><span class="string">"#eff3ff"</span><span>>  </span></li><li class="alt"><span>         <td>标题:<font color=</span><span class="string">"black"</span><span>><?=</span><span class="vars">$row</span><span>[title]?></font> 用户:<font color=</span><span class="string">"black"</span><span>><?=</span><span class="vars">$row</span><span>[user] ?></font>  </span></li><li><span>         <div align=</span><span class="string">"right"</span><span>><a href=</span><span class="string">"preEdit.php?id=<?=$row[id]?>"</span><span>>编辑</a>  |  <a  </span></li><li class="alt"><span>             href=</span><span class="string">"delete.php?id=<?=$row[id]?>"</span><span>>删除</a></div>  </span></li><li><span>         </td>  </span></li><li class="alt"><span>     </tr>  </span></li><li><span>     <tr bgColor=</span><span class="string">"#ffffff"</span><span>>  </span></li><li class="alt"><span>         <td>内容:<?=</span><span class="vars">$row</span><span>[content]?></td>  </span></li><li><span>     </tr>  </span></li><li class="alt"><span>     <tr bgColor=</span><span class="string">"#ffffff"</span><span>>  </span></li><li><span>         <td>  </span></li><li class="alt"><span>         <div align=</span><span class="string">"right"</span><span>>发表日期:<?=</span><span class="vars">$row</span><span>[lastdate]?></div>  </span></li><li><span>         </td>  </span></li><li class="alt"><span>     </tr>  </span></li><li><span>     <?php }  </span></li><li class="alt"><span>     }  </span></li><li><span>     ?>  </span></li><li class="alt"><span> </table> </span></li></ol>
登录后复制

说明:在这个小程序中,有一点不足之处在于,只能同时搜索两个关键字,并且中间用空格" "隔开,如果只是搜索一个关键字,如:"大"
显示的时候会出现乱码 ……^|_|^,这是由于下面代码的结果:

<ol class="dp-c"><li class="alt"><span><span> </span><span class="comment">//用空格符把关键字分割开 </span><span> </span></span></li><li><span> </span><span class="vars">$key</span><span>=</span><span class="func">explode</span><span>(</span><span class="string">' '</span><span>, </span><span class="vars">$_GET</span><span>[keyWord]); </span></li></ol>
登录后复制

如果要改进的话,在这里的后面就要做一下判断了。


www.bkjia.comtruehttp://www.bkjia.com/PHPjc/445701.htmlTechArticle项目结构: 498)this.width=498;' onmousewheel = 'javascript:return big(this)' height="183" alt="\" width="274" src="http://www.bkjia.com/uploadfile/2013/0904/2013090409540695...
相关标签:
php
PHP速学教程(入门到精通)
PHP速学教程(入门到精通)

PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!

下载
来源:php中文网
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn
最新问题
开源免费商场系统广告
热门教程
更多>
最新下载
更多>
网站特效
网站源码
网站素材
前端模板
关于我们 免责申明 举报中心 意见反馈 讲师合作 广告合作 最新更新 English
php中文网:公益在线php培训,帮助PHP学习者快速成长!
关注服务号 技术交流群
PHP中文网订阅号
每天精选资源文章推送
PHP中文网APP
随时随地碎片化学习

Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号