Hi can somebody help me debug my autosuggest code? Please.
View (jquery is included)
Code:
<script>
function lookup(inputString) {
if(inputString.length == 0) {
$('#suggestions').hide();
} else {
$.post("http://site/loan_percentage/autocomplete/", {queryString: ""+inputString+""}, function(data){
if(data.length > 0) {
$('#suggestions').show();
$('#autoSuggestionsList').html(data);
}
});
}
}
function fill(thisValue) {
$('#id_input').val(thisValue);
setTimeout("$('#suggestions').hide();", 200);
}
</script>
<input name="name" id="id_input" type="text" onkeyup="lookup();">
<div id="suggestions">
<div class="autoSuggestionsList_l" id="autoSuggestionsList"></div>
</div>
Controller
Code:
class Loan_percentage extends MY_Controller {
public function __construct (){
parent::__construct();
}
public function index (){
$this->data['page_title'] = 'Loan Percentage';
$this->load_view('site/loan_percentage');
}
public function autocomplete(){
$this->load->model('loan_percentage_model','get_data');
$query = $this->get_data->get_autocomplete();
foreach($query->result() as $row):
echo "<li id=''>".$row->username."</li>";
endforeach;
}
}
Model
Code:
class Loan_percentage_model extends MY_Model{
public function __construct (){
parent::__construct();
}
public function get_autocomplete(){
$this->db->select('username');
$this->db->like('username',$this->input->post('queryString'));
return $this->db->get('tbl_user_accounts', 10);
}
}
Thanks.