jQuery autocomplete outputs all the results instead of matching string

Question

I am newer to JSON and jQuery . I need to do a jQuery autocomplete, for this I put:

<link rel="stylesheet" href="http://code.jquery.com/ui/1.10.3/themes/smoothness/jquery-ui.css" />
<script src="http://code.jquery.com/jquery-1.9.1.js"></script>
<script src="http://code.jquery.com/ui/1.10.3/jquery-ui.js"></script>


<script>
jQuery(document).ready(function($){
    $('#executives').autocomplete({source:'search_executives.php', minLength:2});
});
</script>

And in HTML :

<div class="rows">
    <div class="labels">Search</div>
    <div class="textboxs" style=" width: 175px;"><input id="executives" name="executive" /></div>
</div>

My search_executives.php is :

<?php
session_start();
    if(empty($_SESSION['userid'])){
        header('Location:index.php');
        exit();
    }
include_once('include/config.php'); 

$qry = "SELECT employee_id,fname,mname,lname FROM personal_details WHERE deg_id = '1'";

$res = $dbo->executeQuery( $qry ) ;

//$results[] = array('label' => $row['name']);

for( $i = 0; $i < count( $res ); $i++ )
{
    $result[] = array( 'label' => $res[$i]['fname'].' '.$res[$i]['mname'].' '.$res[$i]['lname'] , 'value' => $res[$i]['employee_id'] ) ;
}

echo json_encode($result);
?>

Now my problem is -

It outputs all the results, it does not depend on the search string I have entered.
It prints the value ( e.g. 3 ) in the textfield in HTML. I need to print the name of the executives with his employee_id as his value.

NB: 1st Part is solved. I forgot to add the LIKE condition in SQL !

billyonecan · Accepted Answer · 2013-06-28 07:47:26Z

1

You'd have to set the value of the input as the label, and then have another field to store the employee_id when an item has been selected:

select: function(e, ui) {
  e.preventDefault();
  this.value = ui.item.label;
  $('#other_field').val(ui.item.value);
}

Here's an example

answered Jun 28, 2013 at 7:47

billyonecan

20.3k9 gold badges45 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Abhishek Kannan · Accepted Answer · 2013-06-28 07:25:09Z

0

You are working with an input text box.

The value attribute of the textbox appears in the front end textbox and you cannot change it. (ie) employee_id in your case.

answered Jun 28, 2013 at 7:25

Abhishek Kannan

9981 gold badge8 silver badges16 bronze badges

1 Comment

AssamGuy Over a year ago

What I need to do if I want the label to be displayed in text box with value attribute from php as its valu ?

Collectives™ on Stack Overflow

jQuery autocomplete outputs all the results instead of matching string

2 Answers 2

Here's an example

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related