会python真的可以为所欲为0(回)
358天前
这里还有人吗1(回)
544天前这里还有人吗0(回)
544天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
768天前到处都是羊，不想上班0(回)
848天前
鸽子
0(回)
852天前<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> |
<html> |
<head> |
<title>jQuery Autocomplete Plugin</title> |
<script type="text/javascript" src="../jquery_autocomplete/lib/jquery.js"></script> |
<script type='text/javascript' src='../jquery_autocomplete/lib/jquery.bgiframe.min.js'></script> |
<script type='text/javascript' src='../jquery_autocomplete/lib/jquery.ajaxQueue.js'></script> |
<script type='text/javascript' src='../jquery_autocomplete/jquery.autocomplete.js'></script> |
<script type='text/javascript' src='../jquery_autocomplete/lib/thickbox-compressed.js'></script> |
<link rel="stylesheet" type="text/css" href="../jquery_autocomplete/jquery.autocomplete.css" /> |
|
<script type="text/javascript"> |
$().ready(function() { |
|
$("#suggest1").autocomplete("ajax.php", { |
minChars: 0, |
width: 230, |
highlight: false, |
scrollHeight: 300, |
matchContains: "word", |
autoFill: false, |
parse: function(data) { |
return $.map(eval(data), function(row) { |
return { |
data: row, |
value: row.name, |
result: row.to |
} |
}); //对ajax页面传过来的数据进行json转码 |
}, |
formatItem: function(row, i, max) { |
return i + '/' + max + ':"' + row.name + '"[' + row.to + ']'; |
}, |
formatMatch: function(row, i, max) { |
return row.name + row.to; |
}, |
formatResult: function(row) { |
return row.to; |
} |
}).result(function(event, row, formatted) { |
return row.to; |
}); |
|
}); |
</script> |
|
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"> |
</head> |
<body> |
<h1 id="banner"><a href="http://bassistance.de/jquery-plugins/jquery-plugin-autocomplete/">jQuery Autocomplete Plugin</a> local deomo</h1> |
<div id="content"> |
|
<form> |
<p> |
<label>选择客户:</label> |
<input type="text" id="suggest1" size="30px"/> |
|
</p> |
|
</form> |
</div> |
</body> |
</html> |
index结束 |
|
ajax.php |
|
<?php |
$conn = @mysql_connect("localhost", "root", "") or die("Failed!"); |
mysql_select_db("jquery_test", $conn); |
mysql_query("set names 'utf8'"); |
$q = $_GET["q"]; |
if (!$q) |
return; |
$items = array(); |
$sql1 = mysql_query("select `CLIENT_N_SHORT`,`CLIENT_NAME` from `client`"); |
while ($row = mysql_fetch_array($sql1)) { |
$key = $row['CLIENT_N_SHORT']; |
$value = $row['CLIENT_NAME']; |
|
if (strpos($value, $q) !== false) { |
array_push($items, array( |
"name" => urlencode($key), |
"to" => urlencode($value) |
)); |
|
//防止json中文乱码 因此转码 |
|
} |
} |
//print_r($items); |
//exit(); |
//echo "<hr>"; |
echo urldecode(json_encode($items)); |
?> |
