Jquery autocomplete with php source

Question

I would like to use the jquery autocomplete "function" with a php file as the source. I don't get why it is not working. If I use data entered in a variable everything works fine. Hope someone can help. Thank you in advance for your replies. Cheers. Marc.

My HTML:

<input id="moi" type="text"/>

My JS :

$(function() {
        $( "#moi" ).autocomplete({
            source: "php/search_loc.php",
            minLength: 2
        });
    });

My PHP:

<?php
header('Content-Type: text/html; charset=utf-8');
require("../inc/connect.inc.php");
mysql_set_charset('utf8'); 

$result = mysql_query("SELECT * FROM search_loc");
$row=mysql_fetch_assoc($result);

while($row=mysql_fetch_assoc($result)){
    echo $row['srl_loc'].'<br>';}

?>

I've never used the jQuery autocomplete plugin, but I'm fairly certain that it's not delimited by <br>. — Ry-
– Ry- ♦, Commented Feb 15, 2012 at 16:11
And you have twice $row=mysql_fetch_assoc($result); in there. is this on purpose? — Raffael Luthiger
– Raffael Luthiger, Commented Feb 15, 2012 at 16:39

Nettogrof · Accepted Answer · 2012-02-15 16:12:56Z

3

Your PHP script should return JSON data,

In the Jquery UI autocomplete doc

The datasource is a server-side script which returns JSON data,

answered Feb 15, 2012 at 16:12

Nettogrof

2,1362 gold badges15 silver badges22 bronze badges

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

1 Comment

Michael Laffargue Over a year ago

You could put "[" before <?php, "]" after ?> and separate your strings with a ",". Or use json_encode on an array where you put your values

Alexey Malev · Accepted Answer · 2014-06-14 13:42:10Z

0

Wrap it in a json_encode() function:

echo json_encode($row['srl_loc']).'<br />';

edited Jun 14, 2014 at 13:42

Alexey Malev

6,5514 gold badges37 silver badges52 bronze badges

answered Jun 14, 2014 at 12:08

Nwachukwu A. Nnaemeka

3694 silver badges14 bronze badges

Collectives™ on Stack Overflow

Jquery autocomplete with php source

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related