jquery autocomplete with json not working

Question

I have successfully used the autocomplete function with a hard coded array. But, when I try to use data from a php file, it doesn't work.

My jquery is as follows.

<script type="text/javascript">
$(document).ready(function(){
    $("input#game_two_other").autocomplete({
        source: "mlb_other_teams.php",
        minLength: 3
    });
});
</script>

My php code is as follows.

$mister =   mysql_query("SELECT * FROM al_other WHERE user_id = '".$_SESSION['id']."'") or die(mysql_error());

while ($other = mysql_fetch_assoc($mister)) 
{

    $team_one   =   $other['team_one'];
    $team_two   =   $other['team_two'];

}

$json = array($team_one, $team_two);

echo json_encode($json);

Any ideas or thoughts?

Thanks,

Lance

did u try to debug $json try echo $json and see in firebug — xkeshav
– xkeshav, Commented Apr 16, 2011 at 7:19
Also: You should go back to your old questions and select an answer for them by clicking on the check-mark next to the answer that helped most. Otherwise people might no longer help you. — nfechner
– nfechner, Commented Apr 16, 2011 at 7:21
It echoes out as follows: ["Texas Rangers","Tampa Bay Rays"] — Lance
– Lance, Commented Apr 16, 2011 at 7:21
Okay, I didn't know that it was such a big deal... but, i'll do that from now on. — Lance
– Lance, Commented Apr 16, 2011 at 7:24

Community · Accepted Answer · 2017-05-23 12:03:12Z

1

When you produce json for jquery's autocomplete it has to containtains label and/or value properties:

$mister =   mysql_query("SELECT * FROM al_other WHERE user_id = '".$_SESSION['id']."'") or die(mysql_error());

$json = array()

while ($other = mysql_fetch_assoc($mister)) 
{

   $json[] = array('label'=>$other['team_one']);
   $json[] = array('label'=>$other['team_two']);

}

echo json_encode($json);

Similar question: Having problems with jQuery UI Autocomplete

edited May 23, 2017 at 12:03

CommunityBot

11 silver badge

answered Apr 16, 2011 at 7:45

Dalen

9,0264 gold badges49 silver badges53 bronze badges

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

2 Comments

Milimetric Over a year ago

Looks like you should add the 'value' => ... as well, but hopefully @Lance figured that out.

Dalen Over a year ago

actually it is not required to provide both label and value, documentation states that if one is missing the other will be used for both purposes

Collectives™ on Stack Overflow

jquery autocomplete with json not working

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related