我做出來的網頁效果是這樣的:
怎樣才能更具搜尋方塊中的關鍵字在第二個頁面顯示搜尋結果呢?
My Code如下:
這是html的代碼:
function lookup(inputString) {if(inputString.length == 0) {// Hide the suggestion box.$('#suggestions').hide();} else {$.post("rpc.php", {queryString: ""+inputString+""}, function(data){if(data.length >0) {$('#suggestions').show();$('#autoSuggestionsList').html(data);}});}} // lookupfunction fill(thisValue) {$('#inputString').val(thisValue);setTimeout("$('#suggestions').hide();", 200);}
這是rpc.php的檔案:
real_escape_string($_POST['queryString']);// Is the string length greater than 0?if(strlen($queryString) >0) {// Run the query: We use LIKE '$queryString%'// The percentage sign is a wild-card, in my example of countries it works like this...// $queryString = 'Uni';// Returned data = 'United States, United Kindom';// YOU NEED TO ALTER THE QUERY TO MATCH YOUR DATABASE.// eg: SELECT yourColumnName FROM yourTable WHERE yourColumnName LIKE '$queryString%' LIMIT 10$query = $db->query("SELECT * FROM bbstopic WHERE title LIKE '%$queryString%' LIMIT 10");if($query) {// While there are results loop through them - fetching an Object (i like PHP5 btw!).while ($result = $query ->fetch_object()) {// Format the results, im using for the list, you can change it.// The onClick function fills the textbox with the result.// YOU MUST CHANGE: $result->value to $result->your_columecho ''.$result->title.'';}} else {echo 'ERROR: There was a problem with the query.';}} else {// Dont do anything.} // There is a queryString.} else {echo 'There should be no direct access to this script!';}}?>
回複討論(解決方案)
你可以使用jquery的一個控制項:autocomplete 。
相容性好,完全可以滿足你的需求。
db_fns.php 在哪呢