What is the purpose of the ".get()" ?
The autocomplete plugin already has the ajax call all wired into it,
there's no need to do that on your own
$(document).ready(function(){
$("#example").autocomplete(
"test.php"
).result(function(a,data,c) {
// variable "data" has the value the user selected
});
});
On Mar 11, 10:45 am, Bright Dadson <brightdad...@googlemail.com>
wrote:
> Hi Experts,
>
> I am trying to use jQuery get function to develop an autocomplete which will
> display suggestion as soon as users starts typing like this;
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
> "http://www.w3.org/TR/html4/loose.dtd";>
> <html>
> <head>
> <script src="http://code.jquery.com/jquery-latest.js";></script>
> <link rel="stylesheet"
> href="http://dev.jquery.com/view/trunk/plugins/autocomplete/demo/main.css";
> type="text/css" />
> <link rel="stylesheet"
> href="http://dev.jquery.com/view/trunk/plugins/autocomplete/jquery.autocomp...";
> type="text/css" />
> <script type="text/javascript"
> src="http://dev.jquery.com/view/trunk/plugins/autocomplete/lib/jquery.bgif...
> "></script>
> <script type="text/javascript"
> src="http://dev.jquery.com/view/trunk/plugins/autocomplete/lib/jquery.dime...
> "></script>
> <script type="text/javascript"
> src="http://dev.jquery.com/view/trunk/plugins/autocomplete/jquery.autocomp...
> "></script>
> <script>
> $(document).ready(function(){
> var result = $.get("test.php", { data:
> "q"+$("#example").attr('value') },
> function(data){
> $("#example").html(data);
> });
>
> $("#example").autocomplete(result);
> });
> </script>
>
> </head>
> <body>
> Company name: <input id="example" />
> </body>
> </html>
>
> and my backend php script looks like this;
>
> <?php
> $q=$_GET["q"];
> $con = mysql_connect('host', 'user', 'password');
> if (!$con)
> {
> die('Could not connect: ' . mysql_error());
> }
>
> mysql_select_db("database", $con);
>
> $sql="SELECT company_name FROM company WHERE company_name =
> '".$q."'";
>
> $result = mysql_query($sql);
>
> while($row = mysql_fetch_array($result))
> {
> echo $row['company_name'];
> }
>
> mysql_close($con);
> ?>
>
> Unfurtunately tthis donot work as required - i donot see any suggestion. Do
> anyone know what i am doing wrong here?
>
> Pls help.
