jqueryphp百度搜索框智能提示效果

index.html文件,保保存成index.htm,代码如下:

 
 
 
 
 
 
 
 
 
 
 
 
   
   
 
    Type your county: 
    
 
     
   
 
   
 
     
    
 
       
    
 
   
 
   
 
 
 
 
php文件,代码如下:
0) { 
    $sql= "SELECT value FROM countries WHERE value LIKE &＃39;".$queryString."%&＃39; LIMIT 10"; 
    $query = mysql_query($sql); 
    while ($result = mysql_fetch_array($query,MYSQL_BOTH)){      
     $value=$result[&＃39;value&＃39;]; 
     echo &＃39;
&＃39;.$value.&＃39;
&＃39;; 
    } 
   }
?>

sql.sql把这里复制保存到你的数据库,代码如下:

-- phpMyAdmin SQL Dump 
-- version 3.3.5 
-- http://www.phpmyadmin.net 
-- 
-- 主机: localhost 
-- 生成日期: 2010 年 12 月 09 日 02:36 
-- 服务器版本: 5.0.22 
-- PHP 版本: 5.2.14 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; 
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; 
/*!40101 SET @OLD_COLLATION_COnNECTION=@@COLLATION_CONNECTION */; 
/*!40101 SET NAMES utf8 */; 
-- 
-- 数据库: `autoComplete` 
-- 
-- -------------------------------------------------------- 
-- 
-- 表的结构 `countries` 
-- 
CREATE TABLE IF NOT EXISTS `countries` ( 
  `id` int(6) NOT NULL auto_increment, 
  `value` varchar(250) NOT NULL default &＃39;&＃39;, 
  PRIMARY KEY  (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=243 ; 
-- 
-- 转存表中的数据 `countries` 
-- 
INSERT INTO `countries` (`id`, `value`) VALUES 
(1, &＃39;Afghanistan&＃39;), 
(2, &＃39;Aringland Islands&＃39;), 
(3, &＃39;Albania&＃39;), 
(4, &＃39;Algeria&＃39;), 
(5, &＃39;American Samoa&＃39;), 
(6, &＃39;Andorra&＃39;), 
(7, &＃39;Angola&＃39;), 
(8, &＃39;Anguilla&＃39;), 
(9, &＃39;Antarctica&＃39;), 
(10, &＃39;Antigua and Barbuda&＃39;), 
(11, &＃39;Argentina&＃39;), 
(12, &＃39;Armenia&＃39;), 
(13, &＃39;Aruba&＃39;), 
(14, &＃39;Australia&＃39;), 
(15, &＃39;Austria&＃39;), 
(16, &＃39;Azerbaijan&＃39;), 
(17, &＃39;Bahamas&＃39;), 
(18, &＃39;Bahrain&＃39;), 
(19, &＃39;Bangladesh&＃39;), 
(20, &＃39;Barbados&＃39;), 
(21, &＃39;Belarus&＃39;), 
(22, &＃39;Belgium&＃39;), 
(23, &＃39;Belize&＃39;), 
(24, &＃39;Benin&＃39;), 
(25, &＃39;Bermuda&＃39;), 
(26, &＃39;Bhutan&＃39;), 
(27, &＃39;Bolivia&＃39;), 
(28, &＃39;Bosnia and Herzegovina&＃39;), 
(29, &＃39;Botswana&＃39;), 
(30, &＃39;Bouvet Island&＃39;), 
(31, &＃39;Brazil&＃39;), 
(32, &＃39;British Indian Ocean territory&＃39;), 
(33, &＃39;Brunei Darussalam&＃39;), 
(34, &＃39;Bulgaria&＃39;), 
(35, &＃39;Burkina Faso&＃39;), 
(36, &＃39;Burundi&＃39;), 
(37, &＃39;Cambodia&＃39;), 
(38, &＃39;Cameroon&＃39;), 
(39, &＃39;Canada&＃39;), 
(40, &＃39;Cape Verde&＃39;), 
(41, &＃39;Cayman Islands&＃39;), 
(42, &＃39;Central African Republic&＃39;), 
(43, &＃39;Chad&＃39;), 
(44, &＃39;Chile&＃39;), 
(45, &＃39;China&＃39;), 
(46, &＃39;Christmas Island&＃39;), 
(47, &＃39;Cocos (Keeling) Islands&＃39;), 
(48, &＃39;Colombia&＃39;), 
(49, &＃39;Comoros&＃39;), 
(50, &＃39;Congo&＃39;), 
(51, &＃39;Congo&＃39;), 
(52, &＃39; Democratic Republic&＃39;), 
(53, &＃39;Cook Islands&＃39;), 
(54, &＃39;Costa Rica&＃39;), 
(55, &＃39;Ivory Coast (Ivory Coast)&＃39;), 
(56, &＃39;Croatia (Hrvatska)&＃39;), 
(57, &＃39;Cuba&＃39;), 
(58, &＃39;Cyprus&＃39;), 
(59, &＃39;Czech Republic&＃39;), 
(60, &＃39;Denmark&＃39;), 
(61, &＃39;Djibouti&＃39;), 
(62, &＃39;Dominica&＃39;), 
(63, &＃39;Dominican Republic&＃39;), 
(64, &＃39;East Timor&＃39;), 
(65, &＃39;Ecuador&＃39;), 
(66, &＃39;Egypt&＃39;), 
(67, &＃39;El Salvador&＃39;), 
(68, &＃39;Equatorial Guinea&＃39;), 
(69, &＃39;Eritrea&＃39;), 
(70, &＃39;Estonia&＃39;), 
(71, &＃39;Ethiopia&＃39;), 
(72, &＃39;Falkland Islands&＃39;), 
(73, &＃39;Faroe Islands&＃39;), 
(74, &＃39;Fiji&＃39;), 
(75, &＃39;Finland&＃39;), 
(76, &＃39;France&＃39;), 
(77, &＃39;French Guiana&＃39;), 
(78, &＃39;French Polynesia&＃39;), 
(79, &＃39;French Southern Territories&＃39;), 
(80, &＃39;Gabon&＃39;), 
(81, &＃39;Gambia&＃39;), 
(82, &＃39;Georgia&＃39;), 
(83, &＃39;Germany&＃39;), 
(84, &＃39;Ghana&＃39;), 
(85, &＃39;Gibraltar&＃39;), 
(86, &＃39;Greece&＃39;), 
(87, &＃39;Greenland&＃39;), 
(88, &＃39;Grenada&＃39;), 
(89, &＃39;Guadeloupe&＃39;), 
(90, &＃39;Guam&＃39;), 
(91, &＃39;Guatemala&＃39;), 
(92, &＃39;Guinea&＃39;), 
(93, &＃39;Guinea-Bissau&＃39;), 
(94, &＃39;Guyana&＃39;), 
(95, &＃39;Haiti&＃39;), 
(96, &＃39;Heard and McDonald Islands&＃39;), 
(97, &＃39;Honduras&＃39;), 
(98, &＃39;Hong Kong&＃39;), 
(99, &＃39;Hungary&＃39;), 
(100, &＃39;Iceland&＃39;), 
(101, &＃39;India&＃39;), 
(102, &＃39;Indonesia&＃39;), 
(103, &＃39;Iran&＃39;), 
(104, &＃39;Iraq&＃39;), 
(105, &＃39;Ireland&＃39;), 
(106, &＃39;Israel&＃39;), 
(107, &＃39;Italy&＃39;), 
(108, &＃39;Jamaica&＃39;), 
(109, &＃39;Japan&＃39;), 
(110, &＃39;Jordan&＃39;), 
(111, &＃39;Kazakhstan&＃39;), 
(112, &＃39;Kenya&＃39;), 
(113, &＃39;Kiribati&＃39;), 
(114, &＃39;Korea (north)&＃39;), 
(115, &＃39;Korea (south)&＃39;), 
(116, &＃39;Kuwait&＃39;), 
(117, &＃39;Kyrgyzstan&＃39;), 
(118, &＃39;Lao People&＃39;&＃39;s Democratic Republic&＃39;), 
(119, &＃39;Latvia&＃39;), 
(120, &＃39;Lebanon&＃39;), 
(121, &＃39;Lesotho&＃39;), 
(122, &＃39;Liberia&＃39;), 
(123, &＃39;Libyan Arab Jamahiriya&＃39;), 
(124, &＃39;Liechtenstein&＃39;), 
(125, &＃39;Lithuania&＃39;), 
(126, &＃39;Luxembourg&＃39;), 
(127, &＃39;Macao&＃39;), 
(128, &＃39;Macedonia&＃39;), 
(129, &＃39;Madagascar&＃39;), 
(130, &＃39;Malawi&＃39;), 
(131, &＃39;Malaysia&＃39;), 
(132, &＃39;Malpes&＃39;), 
(133, &＃39;Mali&＃39;), 
(134, &＃39;Malta&＃39;), 
(135, &＃39;Marshall Islands&＃39;), 
(136, &＃39;Martinique&＃39;), 
(137, &＃39;Mauritania&＃39;), 
(138, &＃39;Mauritius&＃39;), 
(139, &＃39;Mayotte&＃39;), 
(140, &＃39;Mexico&＃39;), 
(141, &＃39;Micronesia&＃39;), 
(142, &＃39;Moldova&＃39;), 
(143, &＃39;Monaco&＃39;), 
(144, &＃39;Mongolia&＃39;), 
(145, &＃39;Montserrat&＃39;), 
(146, &＃39;Morocco&＃39;), 
(147, &＃39;Mozambique&＃39;), 
(148, &＃39;Myanmar&＃39;), 
(149, &＃39;Namibia&＃39;), 
(150, &＃39;Nauru&＃39;), 
(151, &＃39;Nepal&＃39;), 
(152, &＃39;Netherlands&＃39;), 
(153, &＃39;Netherlands Antilles&＃39;), 
(154, &＃39;New Caledonia&＃39;), 
(155, &＃39;New Zealand&＃39;), 
(156, &＃39;Nicaragua&＃39;), 
(157, &＃39;Niger&＃39;), 
(158, &＃39;Nigeria&＃39;), 
(159, &＃39;Niue&＃39;), 
(160, &＃39;Norfolk Island&＃39;), 
(161, &＃39;Northern Mariana Islands&＃39;), 
(162, &＃39;Norway&＃39;), 
(163, &＃39;Oman&＃39;), 
(164, &＃39;Pakistan&＃39;), 
(165, &＃39;Palau&＃39;), 
(166, &＃39;Palestinian Territories&＃39;), 
(167, &＃39;Panama&＃39;), 
(168, &＃39;Papua New Guinea&＃39;), 
(169, &＃39;Paraguay&＃39;), 
(170, &＃39;Peru&＃39;), 
(171, &＃39;Philippines&＃39;), 
(172, &＃39;Pitcairn&＃39;), 
(173, &＃39;Poland&＃39;), 
(174, &＃39;Portugal&＃39;), 
(175, &＃39;Puerto Rico&＃39;), 
(176, &＃39;Qatar&＃39;), 
(177, &＃39;Runion&＃39;), 
(178, &＃39;Romania&＃39;), 
(179, &＃39;Russian Federation&＃39;), 
(180, &＃39;Rwanda&＃39;), 
(181, &＃39;Saint Helena&＃39;), 
(182, &＃39;Saint Kitts and Nevis&＃39;), 
(183, &＃39;Saint Lucia&＃39;), 
(184, &＃39;Saint Pierre and Miquelon&＃39;), 
(185, &＃39;Saint Vincent and the Grenadines&＃39;), 
(186, &＃39;Samoa&＃39;), 
(187, &＃39;San Marino&＃39;), 
(188, &＃39;Sao Tome and Principe&＃39;), 
(189, &＃39;Saudi Arabia&＃39;), 
(190, &＃39;Senegal&＃39;), 
(191, &＃39;Serbia and Montenegro&＃39;), 
(192, &＃39;Seychelles&＃39;), 
(193, &＃39;Sierra Leone&＃39;), 
(194, &＃39;Singapore&＃39;), 
(195, &＃39;Slovakia&＃39;), 
(196, &＃39;Slovenia&＃39;), 
(197, &＃39;Solomon Islands&＃39;), 
(198, &＃39;Somalia&＃39;), 
(199, &＃39;South Africa&＃39;), 
(200, &＃39;South Georgia and the South Sandwich Islands&＃39;), 
(201, &＃39;Spain&＃39;), 
(202, &＃39;Sri Lanka&＃39;), 
(203, &＃39;Sudan&＃39;), 
(204, &＃39;Suriname&＃39;), 
(205, &＃39;Svalbard and Jan Mayen Islands&＃39;), 
(206, &＃39;Swaziland&＃39;), 
(207, &＃39;Sweden&＃39;), 
(208, &＃39;Switzerland&＃39;), 
(209, &＃39;Syria&＃39;), 
(210, &＃39;Taiwan&＃39;), 
(211, &＃39;Tajikistan&＃39;), 
(212, &＃39;Tanzania&＃39;), 
(213, &＃39;Thailand&＃39;), 
(214, &＃39;Togo&＃39;), 
(215, &＃39;Tokelau&＃39;), 
(216, &＃39;Tonga&＃39;), 
(217, &＃39;Trinidad and Tobago&＃39;), 
(218, &＃39;Tunisia&＃39;), 
(219, &＃39;Turkey&＃39;), 
(220, &＃39;Turkmenistan&＃39;), 
(221, &＃39;Turks and Caicos Islands&＃39;), 
(222, &＃39;Tuvalu&＃39;), 
(223, &＃39;Uganda&＃39;), 
(224, &＃39;Ukraine&＃39;), 
(225, &＃39;United Arab Emirates&＃39;), 
(226, &＃39;United Kingdom&＃39;), 
(227, &＃39;United States of America&＃39;), 
(228, &＃39;Uruguay&＃39;), 
(229, &＃39;Uzbekistan&＃39;), 
(230, &＃39;Vanuatu&＃39;), 
(231, &＃39;Vatican City&＃39;), 
(232, &＃39;Venezuela&＃39;), 
(233, &＃39;Vietnam&＃39;), 
(234, &＃39;Virgin Islands (British)&＃39;), 
(235, &＃39;Virgin Islands (US)&＃39;), 
(236, &＃39;Wallis and Futuna Islands&＃39;), 
(237, &＃39;Western Sahara&＃39;), 
(238, &＃39;Yemen&＃39;), 
(239, &＃39;Zaire&＃39;), 
(240, &＃39;Zambia&＃39;), 
(241, &＃39;Zimbabwe&＃39;);

注:里面有个jquery文件没有放上来,大家可以下载jquery库.

文章网址:

随意转载^^但请附上教程地址。