<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<script type="text/javascript" src="jquery-1.8.2.min.js"></script>
<script type="text/javascript" src="jquery.autocomplete.js"></script>
<link rel="stylesheet" type="text/css" href="jquery.autocomplete.css" />
<title>test</title>
</head>
<body>
<script type="text/javascript">
$().ready(function() {
$("#autoComplete").autocomplete("search.php", {
selectFirst: false
}).result(function(event, data, formatted) {
alert("test");
});
});
</script>
</head>
<body>
<input type="text" name="autoComplete" id="autoComplete" />
<input type="text" id="username" >
</body>
</html>
有几个INPUT,想从数据库中调用商品,选择后把其他规格型号,填充到其他INPUT上,调试两天了,选择数据后.result 事件一直不触发,不知道怎么肥事
<?php
header("content-type:text/html; charset=utf-8");
$q = strtolower($_GET["q"]);
if (!$q) return;
$conn = @mysql_connect ( "localhost", "root", "" ); //连接数据库
mysql_query("SET NAMES 'utf8'");//处理乱码
mysql_select_db ( "xt_deyuan", $conn ); //选择数据库
$array ;
if ($conn) {
$recode = "select * from client";
$result = mysql_query ( $recode, $conn );
while ( $row = mysql_fetch_array ( $result, MYSQL_ASSOC ) ) {
$array [$row ['a2']] = $row ["id"];
$array [$row ['a3']] = $row ["id"];
}
}
foreach ($array as $key=>$a2) {
if (strpos(strtolower($key), unescape($q)) !== false) {
echo "$key|$a2\n";
}
}
function unescape($str){
$ret = '';
$len = strlen($str);
for ($i = 0; $i < $len; $i++){
if ($str[$i] == '%' && $str[$i+1] == 'u'){
$val = hexdec(substr($str, $i+2, 4));
if ($val < 0x7f) $ret .= chr($val);
else if($val < 0x800) $ret .= chr(0xc0|($val>>6)).chr(0x80|($val&0x3f));
else $ret .= chr(0xe0|($val>>12)).chr(0x80|(($val>>6)&0x3f)).chr(0x80|($val&0x3f));
$i += 5;
}
else if ($str[$i] == '%'){
$ret .= urldecode(substr($str, $i, 3));
$i += 2;
}
else $ret .= $str[$i];
}
return $ret;
}
?>
这个是从数据库调用数据的代码。求大神看看