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.autocomplete.css"; type="text/css" /> <script type="text/javascript" src=" http://dev.jquery.com/view/trunk/plugins/autocomplete/lib/jquery.bgiframe.min.js "></script> <script type="text/javascript" src=" http://dev.jquery.com/view/trunk/plugins/autocomplete/lib/jquery.dimensions.js "></script> <script type="text/javascript" src=" http://dev.jquery.com/view/trunk/plugins/autocomplete/jquery.autocomplete.js "></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.
