百度提交入口_wap网站_万网空间管理_做网站爱

router.get('/search', function(request, response) {var fetchSql="";if(request.query.source != "所有网站"){//sql字符串和参数var fetchSql = "select title,source_name,publish_date,url " +"from fetches where source_name like '%" + request.query.source+"%'";// console.log(fetchSql);var keywords = request.query.title.split(" ");for(var i=0;i<keywords.length;i++){fetchSql+="and title like '%"+ keywords[i] + "%'";}}else{var keywords = request.query.title.split(" ");var fetchSql = "select title,source_name,publish_date,url from fetches"// console.log(fetchSql);for(var i=0;i<keywords.length;i++){if(i == 0){fetchSql+=" where title like '%"+ keywords[i] + "%'";}else{fetchSql+="and title like '%"+ keywords[i] + "%'";}}}console.log(request.query.sorted);if(request.query.sorted == '默认'){fetchSql += ";";} else if(request.query.sorted == '顺序'){fetchSql += " order by publish_date;";}else{fetchSql +=" order by publish_date desc;";}console.log(fetchSql);mysql.query(fetchSql, function(err, result, fields) {var res = result;regExp = /(\d{4})-(\d{2})-(\d{2})/for (var i = 0;i<res.length;i++){tmp = (res[i]);res[i].publish_date = regExp.exec(JSON.stringify(res[i].publish_date))[0];}response.json({message:'data',result:result});});
				   网上商城购物系统石家庄搜索引擎优化网站建设要多少钱怎样青岛网站维护宁波外贸网站建设多用户版商城系统安徽网站优化站长交流武汉网站公司牡丹江网络推广网页设计师联盟国外网站建设wap自助建站北京网站推广哈尔滨网络推广濮阳做网站的公司汕头网络推广网站推广公司网站优化公司网页设计湘潭seo哈尔滨建站多少钱高端app开发德州关键词优化flash网站制作上海seo企业cms长沙seo顾问定制微信小程序桂林网站排名分销商城系统