doucuoyan0426 2016-08-26 13:25
浏览 22

PHP - 如何创建搜索功能搜索查询是否匹配任何值

I am Trying to make search function on my website i use GET

So i want if user search "How To develop php script in a few seconds With mysql"

It shouldn't mind how long or short or Ascending or descending the search is like if the post title that exists it table is "developing php With mysql" So far 'develop, PHP, and, mysql' exist in any title i want it To list all post having such title

So i use

mysql_query("SELECT * FROM blog,forum WHERE (titleLIKE '%".$_GET['search']."%')");

The result only bring the one that match how it is writing or only if the word before Space match like "develop" or "php"

I will like To do it like google own which doesn't mind your spelling or how it is written To make display of look alike search

I tried but don't work

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 python的qt5界面
    • ¥15 无线电能传输系统MATLAB仿真问题
    • ¥50 如何用脚本实现输入法的热键设置
    • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
    • ¥30 深度学习,前后端连接
    • ¥15 孟德尔随机化结果不一致
    • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
    • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
    • ¥15 谁有desed数据集呀
    • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100