ajax实现搜索热词下拉列表

<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <meta name="Generator" content="EditPlus®">
  <meta name="Author" content="">
  <meta name="Keywords" content="">
  <meta name="Description" content="">
  <title>Document</title>
<script type="text/javascript" src="http://www.0931gc.com/cssjs_7503/jquery-1.4.4.min.js"></script>
<script>
function showlist(value){
$('#querystring').val(value);
setTimeout("$('#showbox').hide();",300);
}
function keyup(string){
if(string.length==0){
  $('#showbox').hide();
  }else{
  $.post("hotword.php",{querystring:""+string+""},function(data){
  if(data.length>0){
      $('#showbox').show();
 $('#showlist').html(data);
 }
    })
  }
}
</script>
  <style>
  #showbox{
  width:200px;
  position:relative;
  background-color:#212427;
  margin:10px 0px;
  color:green;
  border:2px solid #000;
  border-radius:5%;
  }
  #showlist{
  margin:0px;
  padding:0px;
  }
  #showlist li{
  cursor:pointer;
  }
  #showlist li:hover{
  background-color:#fff;
  }
  </style>
 </head>
 <body>
  <form>
  <input type="text" value="" id="querystring" name="querystring" οnkeyup="keyup(this.value)" οnblur="showlist()"/><input type="submit" value="查询"/>
  <div id="showbox" class="showbox" style="display:none;">
  <div id="showlist" class="showslist"></div>
  </div>
  </form>
 </body>

</html>

/*******************************php****************************************/

<?php
$conn=mysql_connect("localhost","root","123456");
if(!$conn){
die("数据库连接失败".mysql_error());
}
mysql_select_db('hotword');
mysql_query('set names utf8');
$queryString=$_POST['querystring'];
$sql="select value from hotword where value like '".$queryString."%' limit 10";
$res=mysql_query($sql);
if($res){
while($rows=mysql_fetch_assoc($res)){
 $value=$rows['value'];
 echo'<li onClick="showlist(\''.$value.'\')">'.$value.'</li>';
}
}
?>

/******************************mysql******************************************/

/*
Navicat MySQL Data Transfer


Source Server         : skdede
Source Server Version : 50527
Source Host           : localhost:3306
Source Database       : test


Target Server Type    : MYSQL
Target Server Version : 50527
File Encoding         : 65001


Date: 2015-04-14 09:39:36
*/


SET FOREIGN_KEY_CHECKS=0;


-- ----------------------------
-- Table structure for `hotword`
-- ----------------------------
DROP TABLE IF EXISTS `hotword`;
CREATE TABLE `hotword` (
  `id` int(6) NOT NULL AUTO_INCREMENT,
  `value` varchar(250) CHARACTER SET gbk DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=281 DEFAULT CHARSET=uft8;


-- ----------------------------
-- Records of hotword
-- ----------------------------
INSERT INTO `hotword` VALUES ('260', '痔疮');
INSERT INTO `hotword` VALUES ('1', 'Afghanistan');
INSERT INTO `hotword` VALUES ('2', 'Aringland Islands');
INSERT INTO `hotword` VALUES ('3', 'Albania');
INSERT INTO `hotword` VALUES ('4', 'Algeria');
INSERT INTO `hotword` VALUES ('5', 'American Samoa');
INSERT INTO `hotword` VALUES ('6', 'Andorra');
INSERT INTO `hotword` VALUES ('7', 'Angola');
INSERT INTO `hotword` VALUES ('8', 'Anguilla');
INSERT INTO `hotword` VALUES ('9', 'Antarctica');
INSERT INTO `hotword` VALUES ('10', 'Antigua and Barbuda');
INSERT INTO `hotword` VALUES ('11', 'Argentina');
INSERT INTO `hotword` VALUES ('12', 'Armenia');
INSERT INTO `hotword` VALUES ('13', 'Aruba');
INSERT INTO `hotword` VALUES ('14', 'Australia');
INSERT INTO `hotword` VALUES ('15', 'Austria');
INSERT INTO `hotword` VALUES ('16', 'Azerbaijan');
INSERT INTO `hotword` VALUES ('17', 'Bahamas');
INSERT INTO `hotword` VALUES ('18', 'Bahrain');
INSERT INTO `hotword` VALUES ('19', 'Bangladesh');
INSERT INTO `hotword` VALUES ('20', 'Barbados');
INSERT INTO `hotword` VALUES ('21', 'Belarus');
INSERT INTO `hotword` VALUES ('22', 'Belgium');
INSERT INTO `hotword` VALUES ('23', 'Belize');
INSERT INTO `hotword` VALUES ('24', 'Benin');
INSERT INTO `hotword` VALUES ('25', 'Bermuda');
INSERT INTO `hotword` VALUES ('26', 'Bhutan');
INSERT INTO `hotword` VALUES ('27', 'Bolivia');
INSERT INTO `hotword` VALUES ('28', 'Bosnia and Herzegovina');
INSERT INTO `hotword` VALUES ('29', 'Botswana');
INSERT INTO `hotword` VALUES ('30', 'Bouvet Island');
INSERT INTO `hotword` VALUES ('31', 'Brazil');
INSERT INTO `hotword` VALUES ('32', 'British Indian Ocean territory');
INSERT INTO `hotword` VALUES ('33', 'Brunei Darussalam');
INSERT INTO `hotword` VALUES ('34', 'Bulgaria');
INSERT INTO `hotword` VALUES ('35', 'Burkina Faso');
INSERT INTO `hotword` VALUES ('36', 'Burundi');
INSERT INTO `hotword` VALUES ('37', 'Cambodia');
INSERT INTO `hotword` VALUES ('38', 'Cameroon');
INSERT INTO `hotword` VALUES ('39', 'Canada');
INSERT INTO `hotword` VALUES ('40', 'Cape Verde');
INSERT INTO `hotword` VALUES ('41', 'Cayman Islands');
INSERT INTO `hotword` VALUES ('42', 'Central African Republic');
INSERT INTO `hotword` VALUES ('43', 'Chad');
INSERT INTO `hotword` VALUES ('44', 'Chile');
INSERT INTO `hotword` VALUES ('45', 'China');
INSERT INTO `hotword` VALUES ('46', 'Christmas Island');
INSERT INTO `hotword` VALUES ('47', 'Cocos (Keeling) Islands');
INSERT INTO `hotword` VALUES ('48', 'Colombia');
INSERT INTO `hotword` VALUES ('49', 'Comoros');
INSERT INTO `hotword` VALUES ('50', 'Congo');
INSERT INTO `hotword` VALUES ('51', 'Congo');
INSERT INTO `hotword` VALUES ('52', ' Democratic Republic');
INSERT INTO `hotword` VALUES ('53', 'Cook Islands');
INSERT INTO `hotword` VALUES ('54', 'Costa Rica');
INSERT INTO `hotword` VALUES ('55', 'Ivory Coast (Ivory Coast)');
INSERT INTO `hotword` VALUES ('56', 'Croatia (Hrvatska)');
INSERT INTO `hotword` VALUES ('57', 'Cuba');
INSERT INTO `hotword` VALUES ('58', 'Cyprus');
INSERT INTO `hotword` VALUES ('59', 'Czech Republic');
INSERT INTO `hotword` VALUES ('60', 'Denmark');
INSERT INTO `hotword` VALUES ('61', 'Djibouti');
INSERT INTO `hotword` VALUES ('62', 'Dominica');
INSERT INTO `hotword` VALUES ('63', 'Dominican Republic');
INSERT INTO `hotword` VALUES ('64', 'East Timor');
INSERT INTO `hotword` VALUES ('65', 'Ecuador');
INSERT INTO `hotword` VALUES ('66', 'Egypt');
INSERT INTO `hotword` VALUES ('67', 'El Salvador');
INSERT INTO `hotword` VALUES ('68', 'Equatorial Guinea');
INSERT INTO `hotword` VALUES ('69', 'Eritrea');
INSERT INTO `hotword` VALUES ('70', 'Estonia');
INSERT INTO `hotword` VALUES ('71', 'Ethiopia');
INSERT INTO `hotword` VALUES ('72', 'Falkland Islands');
INSERT INTO `hotword` VALUES ('73', 'Faroe Islands');
INSERT INTO `hotword` VALUES ('74', 'Fiji');
INSERT INTO `hotword` VALUES ('75', 'Finland');
INSERT INTO `hotword` VALUES ('76', 'France');
INSERT INTO `hotword` VALUES ('77', 'French Guiana');
INSERT INTO `hotword` VALUES ('78', 'French Polynesia');
INSERT INTO `hotword` VALUES ('79', 'French Southern Territories');
INSERT INTO `hotword` VALUES ('80', 'Gabon');
INSERT INTO `hotword` VALUES ('81', 'Gambia');
INSERT INTO `hotword` VALUES ('82', 'Georgia');
INSERT INTO `hotword` VALUES ('83', 'Germany');
INSERT INTO `hotword` VALUES ('84', 'Ghana');
INSERT INTO `hotword` VALUES ('85', 'Gibraltar');
INSERT INTO `hotword` VALUES ('86', 'Greece');
INSERT INTO `hotword` VALUES ('87', 'Greenland');
INSERT INTO `hotword` VALUES ('88', 'Grenada');
INSERT INTO `hotword` VALUES ('89', 'Guadeloupe');
INSERT INTO `hotword` VALUES ('90', 'Guam');
INSERT INTO `hotword` VALUES ('91', 'Guatemala');
INSERT INTO `hotword` VALUES ('92', 'Guinea');
INSERT INTO `hotword` VALUES ('93', 'Guinea-Bissau');
INSERT INTO `hotword` VALUES ('94', 'Guyana');
INSERT INTO `hotword` VALUES ('95', 'Haiti');
INSERT INTO `hotword` VALUES ('96', 'Heard and McDonald Islands');
INSERT INTO `hotword` VALUES ('97', 'Honduras');
INSERT INTO `hotword` VALUES ('98', 'Hong Kong');
INSERT INTO `hotword` VALUES ('99', 'Hungary');
INSERT INTO `hotword` VALUES ('100', 'Iceland');
INSERT INTO `hotword` VALUES ('101', 'India');
INSERT INTO `hotword` VALUES ('102', 'Indonesia');
INSERT INTO `hotword` VALUES ('103', 'Iran');
INSERT INTO `hotword` VALUES ('104', 'Iraq');
INSERT INTO `hotword` VALUES ('105', 'Ireland');
INSERT INTO `hotword` VALUES ('106', 'Israel');
INSERT INTO `hotword` VALUES ('107', 'Italy');
INSERT INTO `hotword` VALUES ('108', 'Jamaica');
INSERT INTO `hotword` VALUES ('109', 'Japan');
INSERT INTO `hotword` VALUES ('110', 'Jordan');
INSERT INTO `hotword` VALUES ('111', 'Kazakhstan');
INSERT INTO `hotword` VALUES ('112', 'Kenya');
INSERT INTO `hotword` VALUES ('113', 'Kiribati');
INSERT INTO `hotword` VALUES ('114', 'Korea (north)');
INSERT INTO `hotword` VALUES ('115', 'Korea (south)');
INSERT INTO `hotword` VALUES ('116', 'Kuwait');
INSERT INTO `hotword` VALUES ('117', 'Kyrgyzstan');
INSERT INTO `hotword` VALUES ('118', 'Lao People\'s Democratic Republic');
INSERT INTO `hotword` VALUES ('119', 'Latvia');
INSERT INTO `hotword` VALUES ('120', 'Lebanon');
INSERT INTO `hotword` VALUES ('121', 'Lesotho');
INSERT INTO `hotword` VALUES ('122', 'Liberia');
INSERT INTO `hotword` VALUES ('123', 'Libyan Arab Jamahiriya');
INSERT INTO `hotword` VALUES ('124', 'Liechtenstein');
INSERT INTO `hotword` VALUES ('125', 'Lithuania');
INSERT INTO `hotword` VALUES ('126', 'Luxembourg');
INSERT INTO `hotword` VALUES ('127', 'Macao');
INSERT INTO `hotword` VALUES ('128', 'Macedonia');
INSERT INTO `hotword` VALUES ('129', 'Madagascar');
INSERT INTO `hotword` VALUES ('130', 'Malawi');
INSERT INTO `hotword` VALUES ('131', 'Malaysia');
INSERT INTO `hotword` VALUES ('132', 'Maldives');
INSERT INTO `hotword` VALUES ('133', 'Mali');
INSERT INTO `hotword` VALUES ('134', 'Malta');
INSERT INTO `hotword` VALUES ('135', 'Marshall Islands');
INSERT INTO `hotword` VALUES ('136', 'Martinique');
INSERT INTO `hotword` VALUES ('137', 'Mauritania');
INSERT INTO `hotword` VALUES ('138', 'Mauritius');
INSERT INTO `hotword` VALUES ('139', 'Mayotte');
INSERT INTO `hotword` VALUES ('140', 'Mexico');
INSERT INTO `hotword` VALUES ('141', 'Micronesia');
INSERT INTO `hotword` VALUES ('142', 'Moldova');
INSERT INTO `hotword` VALUES ('143', 'Monaco');
INSERT INTO `hotword` VALUES ('144', 'Mongolia');
INSERT INTO `hotword` VALUES ('145', 'Montserrat');
INSERT INTO `hotword` VALUES ('146', 'Morocco');
INSERT INTO `hotword` VALUES ('147', 'Mozambique');
INSERT INTO `hotword` VALUES ('148', 'Myanmar');
INSERT INTO `hotword` VALUES ('149', 'Namibia');
INSERT INTO `hotword` VALUES ('150', 'Nauru');
INSERT INTO `hotword` VALUES ('151', 'Nepal');
INSERT INTO `hotword` VALUES ('152', 'Netherlands');
INSERT INTO `hotword` VALUES ('153', 'Netherlands Antilles');
INSERT INTO `hotword` VALUES ('154', 'New Caledonia');
INSERT INTO `hotword` VALUES ('155', 'New Zealand');
INSERT INTO `hotword` VALUES ('156', 'Nicaragua');
INSERT INTO `hotword` VALUES ('157', 'Niger');
INSERT INTO `hotword` VALUES ('158', 'Nigeria');
INSERT INTO `hotword` VALUES ('159', 'Niue');
INSERT INTO `hotword` VALUES ('160', 'Norfolk Island');
INSERT INTO `hotword` VALUES ('161', 'Northern Mariana Islands');
INSERT INTO `hotword` VALUES ('162', 'Norway');
INSERT INTO `hotword` VALUES ('163', 'Oman');
INSERT INTO `hotword` VALUES ('164', 'Pakistan');
INSERT INTO `hotword` VALUES ('165', 'Palau');
INSERT INTO `hotword` VALUES ('166', 'Palestinian Territories');
INSERT INTO `hotword` VALUES ('167', 'Panama');
INSERT INTO `hotword` VALUES ('168', 'Papua New Guinea');
INSERT INTO `hotword` VALUES ('169', 'Paraguay');
INSERT INTO `hotword` VALUES ('170', 'Peru');
INSERT INTO `hotword` VALUES ('171', 'Philippines');
INSERT INTO `hotword` VALUES ('172', 'Pitcairn');
INSERT INTO `hotword` VALUES ('173', 'Poland');
INSERT INTO `hotword` VALUES ('174', 'Portugal');
INSERT INTO `hotword` VALUES ('175', 'Puerto Rico');
INSERT INTO `hotword` VALUES ('176', 'Qatar');
INSERT INTO `hotword` VALUES ('177', 'Runion');
INSERT INTO `hotword` VALUES ('178', 'Romania');
INSERT INTO `hotword` VALUES ('179', 'Russian Federation');
INSERT INTO `hotword` VALUES ('180', 'Rwanda');
INSERT INTO `hotword` VALUES ('181', 'Saint Helena');
INSERT INTO `hotword` VALUES ('182', 'Saint Kitts and Nevis');
INSERT INTO `hotword` VALUES ('183', 'Saint Lucia');
INSERT INTO `hotword` VALUES ('184', 'Saint Pierre and Miquelon');
INSERT INTO `hotword` VALUES ('185', 'Saint Vincent and the Grenadines');
INSERT INTO `hotword` VALUES ('186', 'Samoa');
INSERT INTO `hotword` VALUES ('187', 'San Marino');
INSERT INTO `hotword` VALUES ('188', 'Sao Tome and Principe');
INSERT INTO `hotword` VALUES ('189', 'Saudi Arabia');
INSERT INTO `hotword` VALUES ('190', 'Senegal');
INSERT INTO `hotword` VALUES ('191', 'Serbia and Montenegro');
INSERT INTO `hotword` VALUES ('192', 'Seychelles');
INSERT INTO `hotword` VALUES ('193', 'Sierra Leone');
INSERT INTO `hotword` VALUES ('194', 'Singapore');
INSERT INTO `hotword` VALUES ('195', 'Slovakia');
INSERT INTO `hotword` VALUES ('196', 'Slovenia');
INSERT INTO `hotword` VALUES ('197', 'Solomon Islands');
INSERT INTO `hotword` VALUES ('198', 'Somalia');
INSERT INTO `hotword` VALUES ('199', 'South Africa');
INSERT INTO `hotword` VALUES ('200', 'South Georgia and the South Sandwich Islands');
INSERT INTO `hotword` VALUES ('201', 'Spain');
INSERT INTO `hotword` VALUES ('202', 'Sri Lanka');
INSERT INTO `hotword` VALUES ('203', 'Sudan');
INSERT INTO `hotword` VALUES ('204', 'Suriname');
INSERT INTO `hotword` VALUES ('205', 'Svalbard and Jan Mayen Islands');
INSERT INTO `hotword` VALUES ('206', 'Swaziland');
INSERT INTO `hotword` VALUES ('207', 'Sweden');
INSERT INTO `hotword` VALUES ('208', 'Switzerland');
INSERT INTO `hotword` VALUES ('209', 'Syria');
INSERT INTO `hotword` VALUES ('210', 'Taiwan');
INSERT INTO `hotword` VALUES ('211', 'Tajikistan');
INSERT INTO `hotword` VALUES ('212', 'Tanzania');
INSERT INTO `hotword` VALUES ('213', 'Thailand');
INSERT INTO `hotword` VALUES ('214', 'Togo');
INSERT INTO `hotword` VALUES ('215', 'Tokelau');
INSERT INTO `hotword` VALUES ('216', 'Tonga');
INSERT INTO `hotword` VALUES ('217', 'Trinidad and Tobago');
INSERT INTO `hotword` VALUES ('218', 'Tunisia');
INSERT INTO `hotword` VALUES ('219', 'Turkey');
INSERT INTO `hotword` VALUES ('220', 'Turkmenistan');
INSERT INTO `hotword` VALUES ('221', 'Turks and Caicos Islands');
INSERT INTO `hotword` VALUES ('222', 'Tuvalu');
INSERT INTO `hotword` VALUES ('223', 'Uganda');
INSERT INTO `hotword` VALUES ('224', 'Ukraine');
INSERT INTO `hotword` VALUES ('225', 'United Arab Emirates');
INSERT INTO `hotword` VALUES ('226', 'United Kingdom');
INSERT INTO `hotword` VALUES ('227', 'United States of America');
INSERT INTO `hotword` VALUES ('228', 'Uruguay');
INSERT INTO `hotword` VALUES ('229', 'Uzbekistan');
INSERT INTO `hotword` VALUES ('230', 'Vanuatu');
INSERT INTO `hotword` VALUES ('231', 'Vatican City');
INSERT INTO `hotword` VALUES ('232', 'Venezuela');
INSERT INTO `hotword` VALUES ('233', 'Vietnam');
INSERT INTO `hotword` VALUES ('234', 'Virgin Islands (British)');
INSERT INTO `hotword` VALUES ('235', 'Virgin Islands (US)');
INSERT INTO `hotword` VALUES ('236', 'Wallis and Futuna Islands');
INSERT INTO `hotword` VALUES ('237', 'Western Sahara');
INSERT INTO `hotword` VALUES ('238', 'Yemen');
INSERT INTO `hotword` VALUES ('239', 'Zaire');
INSERT INTO `hotword` VALUES ('240', 'Zambia');
INSERT INTO `hotword` VALUES ('241', 'Zimbabwe');
INSERT INTO `hotword` VALUES ('242', 'zhichuang');
INSERT INTO `hotword` VALUES ('250', '上海肛泰');
INSERT INTO `hotword` VALUES ('251', '上海肛泰医院');
INSERT INTO `hotword` VALUES ('252', '上海肛泰肛肠医院');
INSERT INTO `hotword` VALUES ('254', '杭州肛泰医院');
INSERT INTO `hotword` VALUES ('255', '杭州痔疮医院');
INSERT INTO `hotword` VALUES ('256', '天津肛泰医院');
INSERT INTO `hotword` VALUES ('257', '南宁肛泰肛肠医院');
INSERT INTO `hotword` VALUES ('258', '兰州肛泰肛肠医院');
INSERT INTO `hotword` VALUES ('259', '痔疮医院');
INSERT INTO `hotword` VALUES ('261', '肛周脓肿');
INSERT INTO `hotword` VALUES ('262', '便秘');
INSERT INTO `hotword` VALUES ('263', '便血');
INSERT INTO `hotword` VALUES ('264', '肛门异物');
INSERT INTO `hotword` VALUES ('265', '肛裂');
INSERT INTO `hotword` VALUES ('266', '内痔');
INSERT INTO `hotword` VALUES ('267', '外痔');
INSERT INTO `hotword` VALUES ('268', '急性肠炎');
INSERT INTO `hotword` VALUES ('269', '慢性肠炎');
INSERT INTO `hotword` VALUES ('270', '肛瘘');
INSERT INTO `hotword` VALUES ('271', '肛泰');
INSERT INTO `hotword` VALUES ('272', '医博');
INSERT INTO `hotword` VALUES ('273', '便血');
INSERT INTO `hotword` VALUES ('274', '肛门瘙痒');
INSERT INTO `hotword` VALUES ('275', '大便困难');
INSERT INTO `hotword` VALUES ('276', '腹泻');
INSERT INTO `hotword` VALUES ('277', '腹胀');
INSERT INTO `hotword` VALUES ('278', '直肠炎');
INSERT INTO `hotword` VALUES ('279', '结肠炎');
INSERT INTO `hotword` VALUES ('280', '肛泰疗法');

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值