佛山酒店网站建站_品牌设计vi_虹桥门户网app_杭州网站建设哪家技术好
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});});">