Ajax快速显示搜索结果程序

<?php //* Ajax快速搜索结果程序 - Ajax Quick Search Results //* Copyright 2008 - 2010 闻泰网络 //* http://www.weentech.com $minimum_length = 3; // 在搜索输入框中键入多少个字符后，开始进行Ajax查询. 要求和ajax_search.js文件中的设置的值保持一致 $result_limits = 6; // 当搜索结果数量大于此数目时，快速结果显示框底部显示“更多搜索结果”的图片和链接 $search_mode = 'OR'; // 设置为 'OR' 表示只要匹配一个关键词，设置为 'AND' 表示要匹配所有关键词 $rootpath = './../'; // 网站的根目录 if (isset($_GET['ween_search_query']) && strlen($_GET['ween_search_query']) >= 3) { $search_keywords = sqlsafefilter($_REQUEST['ween_search_query']); }else{ exit(); } //以下是两个函数 function EscapeEntity($string) { return str_replace(array('&', '"', '<', '>'), array( '&amp;','&quot;', '&lt;', '&gt;'), $string); } // sqlsafefilter()函数过滤非法的MYSQL查询，这里比较严格，可根据自己的需要删减过滤的字符 function sqlsafefilter( $source ) { $entities_match = array(',',';','$','!','@','#','%','^','&','*','_','(',')','+','{','}','|',':','"','<','>','?','[',']','\\',"'",'.','/','*','+','~','`','='); $entities_replace = array(' ',' ','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','',''); return str_replace($entities_match, $entities_replace, trim($source)); } // 以下搜索代码是示例，需要根据自己的网站系统所使用的数据库查询函数等定制 if(file_exists($rootpath . 'includes/core.php')){ define('IN_WEENCOMPANY', true); if(isset($_GET['lang']) AND (!isset($_COOKIE['weenCompany_forelang']) OR $_COOKIE['weenCompany_forelang'] != $_GET['lang'])) { $lang = strtolower($_GET['lang']); if($lang == 'cn' OR $lang == 'en'){ setcookie("weenCompany_forelang", $lang, 0, "/"); Header("Location: $_SERVER[REQUEST_URI]"); exit(); } } include($rootpath . 'includes/core.php'); if($sitedefaultlang == 'en') { $forelang='en'; }else{ $forelang='cn'; } $keywords = explode (' ', $search_keywords); if(strtoupper($search_mode) == 'OR'){ $boolean_type = 'OR'; }else{ $boolean_type = 'AND'; } $query_where .= '('; foreach ($keywords as $key => $value) { $query_where .= " (title LIKE '%".$value."%' OR description LIKE '%".$value."%' OR specification LIKE '%".$value."%' OR priceship LIKE '%".$value."%') " . $boolean_type; } unset ($keywords); $query_where = rtrim ($query_where, ' ' . $boolean_type); $query_where .= ')'; $get_datas = $DB->query("SELECT imageid, title, images, price, rating FROM " . TABLE_PREFIX . "m17_products WHERE activated = '1' AND ".$query_where." ORDER BY datecreated DESC LIMIT " . ($result_limits + 1) . ""); //($result_limits + 1)表示只搜索比限制的多一个就可以了，搜索多了也不显示 $search_counts = $DB->get_num_rows($get_datas); if ($search_counts <1) { exit(); } $view_all = ''; if ($search_counts > $result_limits) { $view_all = sprintf(' view_all="%s"', EscapeEntity(sprintf('<a href="%ssearch.php?ween_search_query=%s">%s</a>', $rootpath, $search_keywords, '.'))); } echo '<?xml version="1.0"?>'."\n"; echo sprintf('<results type="%s" result_count="%s"%s>'."\n", '快速搜索结果:', $search_counts, $view_all); while($data = $DB->fetch_array($get_datas)) { echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity($data['title']), EscapeEntity(sprintf('价格: %s元', $data['price'])), EscapeEntity('show.php?id='.$data['imageid']), EscapeEntity('images/'.$data['images']), EscapeEntity(sprintf('images/IcoRating%s.gif', int($data['rating'])))); } echo "</results>\n"; exit(); } // 以上搜索代码需要根据自己的网站系统所使用的数据库查询函数等定制 // 以下代码是显示测试数据，无实际用途，当使用上面的实际搜索代码时，以下代码需要删除 $view_all = ''; $search_counts = 7; if ($search_counts > $result_limits) { $view_all = sprintf(' view_all="%s"', EscapeEntity(sprintf('<a href="%ssearch.php?ween_search_query=%s">%s</a>', $rootpath, $search_keywords, '.'))); } echo '<?xml version="1.0"?>'."\n"; echo sprintf('<results type="%s" result_count="%s"%s>'."\n", '快速搜索结果:', 118, $view_all); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('weenCompany 中英文闻名企业网站系统'), EscapeEntity('价格: 380元'), EscapeEntity('show.php?id=3'), EscapeEntity('images/s3.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 2))); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('ween MP4高级播放器'), EscapeEntity('价格: 11元'), EscapeEntity('show.php?id=1'), EscapeEntity('images/s1.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 0))); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('ween P8商用笔记本电脑'), EscapeEntity('价格: 1220元'), EscapeEntity('show.php?id=2'), EscapeEntity('images/s2.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 1))); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('ween 高级电脑背包'), EscapeEntity('价格: 96元'), EscapeEntity('show.php?id=4'), EscapeEntity('images/s4.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 3))); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('ween 高保真耳麦'), EscapeEntity('价格: 127元'), EscapeEntity('show.php?id=5'), EscapeEntity('images/s5.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 4))); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('ween 宽屏笔记本电脑'), EscapeEntity('价格: 9680元'), EscapeEntity('show.php?id=6'), EscapeEntity('images/s6.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 5))); echo sprintf('<result title="%s" price="%s" url="%s" image="%s" ratingimg="%s" />'."\n", EscapeEntity('ween MP3播放器'), EscapeEntity('价格: 780元'), EscapeEntity('show.php?id=7'), EscapeEntity('images/s7.jpg'), EscapeEntity(sprintf('images/IcoRating%s.gif', 5))); echo "</results>\n"; // 以上代码是显示测试数据，无实际用途，当使用上面的实际搜索代码时，以上代码需要删除 ?>