2023年6月29日发(作者：)

Node实现搜索框进⾏模糊查询本⽂实例为⼤家分享了Node实现搜索框进⾏模糊查询的具体代码，供⼤家参考，具体内容如下⼀、需求点击导航栏中的搜索图，出现搜索框，从⽽进⾏⽂章的模糊查询⼆、建表表添加外键：表表表三、页⾯及样式： <%-include('detachPart/')%> <%-include('detachPart/')%>

<%-include('detachPart/')%>：：.searchclose{ display: none; position: relative; margin: 0.5rem auto; padding: 1rem 0; text-align: center; background-color: white;}.searchclose input:nth-child(1){ width: 25rem; height: 2.2rem; outline: none; font-size: 0.9rem; padding-left: 0.5rem; border: 1px solid silver; box-sizing: border-box; vertical-align: middle;}.searchclose input:nth-child(2){ display: inline-block; width: 10rem; height: 2.2rem; line-height: 2.2rem; background-color: rgb(41, 41, 41);; color: white; vertical-align: middle; border: 1px solid rgb(41, 41, 41); border-style: none; margin-left: -1rem;}.searchclose img{ position: absolute; top: 0; right: 0;}：$(function(){ $(".searchbtn").click(function(){ $(".searchclose").show(); }); $(".closebtn").click(function(){ $(".searchclose").hide(); });});四、MySQL数据：var mysql=require("mysql");var setting=require("./setting");var connection;var connectionmysql=function(){ connection=Connection({ host:, port:, user:, password:, database: });}connectionmysql();

=function(str,callback){ connectionmysql();

(str,function(err,res){ if(err) throw err; callback(res); ();

});}

=function(str,params,callback){ connectionmysql();

(str,params,function(err,res){ if(err) throw err; callback(res); ();

});}

：s={ findTitle:"select * from nav", clickRank:"select id,title from blog order by num desc limit 7", recommendInfo:"select id,title,logo,recommend from blog where recommend=1 limit 8", likeBlog:"select ,title,intro,logo,time,fo, from blog,type,user where = and = and title like ? order by time desc"}：var mysql=require("../MySQL/connection");var sql=require("../MySQL/sql");s={ findTitle:function(){ return new Promise(function(resolve){ (tle,function(result){ resolve((ify(result))); }); }) }, clickRank:function(){ return new Promise(function(resolve){ (ank,function(result){ resolve((ify(result))); }); }); }, recommendInfo:function(){ return new Promise(function(resolve){ (endInfo,function(result){ resolve((ify(result))); }); }); }, likeBlog:function(msg){ return new Promise(function(resolve){ (og,msg,function(result){ resolve((ify(result))); }); }); }}：var promise=require("../MySQL/promise");var url=require("url");s=function(app){ // 搜索框进⾏模糊查找 ("/like",function(req,res){ var likeurl=(,true).; async function getData(){ var res1=await tle(); var res5=await ank(); var res11=await endInfo(); var res21=await og("%"+likeurl+"%"); var allres={ titleindex:0, navres:res1, rankres:res5, recommendres:res11, blogres:res21 } return allres; } getData().then(function(result){ ("like",result); }); });}注：like 路由中的blogres:res21和⾸页中的blogres:res10,所渲染到页⾯中的数据名称需⼀致，在此均为 blogres五、效果展⽰进⾏搜索：搜索结果：以上就是本⽂的全部内容，希望对⼤家的学习有所帮助，也希望⼤家多多⽀持。