php / jquery autocomplete from mysql table

Question

After referencing many previous questions and answers on this topic, I am still stumped. I am attempting to reference the database that stores a user's contact list. As an initial start, I'm keeping things simple and only allowing reference by email (rather than email, first and last names, etc).

I have the following linked:

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.23/jquery-ui.min.js"></script>
<script type="text/javascript">
$(document).ready(function() {
    $( ".emaillist" ).autocomplete({
        source: "contacts.php"}); });
</script>

contacts.php: [UPDATED]

<?php
session_start();
include "scripts/sqlconnect.php";
$id = $_SESSION['id'];
$csql = mysql_query("SELECT * FROM db WHERE id='$id' AND email LIKE '%".mysql_real_escape_string($_GET['term'])."%'");
$contactlist = array();
while($row = mysql_fetch_assoc($csql)){
    $contactlist[] = $row['email'];
}
$contactlist = json_encode($contactlist);
header('Content-Type: application/json');
echo "$contactlist";
?>

And finally the relevant HTML snippet:

<input name="semail" type="text" class="emaillist" id="semail"/>

Any suggestions on what I've done wrong? I can't seem to pinpoint the issue.

score 3 · Accepted Answer · 2012-09-17 19:51:05Z

3

2 things that I notice:

You never output the contents of $contactlist
You aren't setting the appropriate Content-Type header.

So you want to do this:

$contactlist = json_encode($contactlist);
header('Content-Type: application/json');
echo $contactlist;

According to the documentation, the value passed to the AJAX source is called term, so you should be using that in your query, not semail:

...  AND email LIKE "%'. mysql_real_escape_string($_GET['term']) .'%"');
                                                         ^^^^-- Here

edited Sep 17, 2012 at 19:51

answered Sep 17, 2012 at 19:16

user21926

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

7 Comments

Craig Over a year ago

You're right, I didn't have an echo! Unfortunately, I'm still not getting any autocomplete options when i type in the input field shown above. I do have <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> in my header of the page, should this be the problem?

user21926 Over a year ago

In contacts.php? If you navigate to contacts.php directly, what is the output?

user21926 Over a year ago

Well you need to pass in the appropriate variables, too: contacts.php?semail=zeshin

Craig Over a year ago

are you saying that the source: "contacts.php" should instead be source: "contacts.php?semail=<? echo $_GET['term'];?>" ?

user21926 Over a year ago

let us continue this discussion in chat

|

Collectives™ on Stack Overflow

php / jquery autocomplete from mysql table

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related