php 自动填写表单,php – 由数据库填充的自动填充表单？

我最近使用这个库进行自动完成 –

http://www.devbridge.com/projects/autocomplete/jquery/

所以这里是基于你的简短脚本：

$query = isset($_GET['query']) ? $_GET['query'] : FALSE;

if ($query) {

global $wpdb;

// escape values passed to db to avoid sql-injection

$depts = $wpdb->get_results( "SELECT * FROM departments WHERE department_name LIKE '".$query."%' ORDER BY department_name ASC" );

$suggestions = array();

$data = array();

foreach($depts as $row) {

$suggestions[] = $row->department_name;

$data[] = $row->department_id;

}

$response = array(

'query' => $query,

'suggestions' => $suggestions,

'data' => $data,

);

echo json_encode($response);

} else {

?>

$(document).ready(function(){

$('#box').autocomplete({

serviceUrl:'/',

// callback function:

onSelect: function(value, data){ alert('You selected: ' + value + ', ' + data); },

});

});

}?>