Guest User

Untitled

a guest
Aug 19th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. Why my auto completion script (jquery) did not work on my website?
  2. <script type="text/javascript" src="js/jquery-1.4.2.js"></script>
  3. <script type='text/javascript' src="js/autocomplete.js"></script>
  4. <link rel="stylesheet" type="text/css" href="css/autocomplete.css" />
  5.  
  6. <script type="text/javascript">
  7. $().ready(function() {
  8. $("#name").autocomplete("php/autocompletion.php",{
  9. width: 260,
  10. matchContains: true,
  11. //mustMatch: true,
  12. //minChars: 0,
  13. //multiple: true,
  14. //highlight: false,
  15. //multipleSeparator: ",",
  16. selectFirst: false
  17. });
  18. });
  19. </script>
  20.  
  21. <?php
  22. $host="localhost"; // Host name
  23. $username="name"; // Mysql username
  24. $password="password"; // Mysql password
  25. $db_name="dbname"; // Database name
  26.  
  27. $con = mysql_connect($host,$username,$password) or die(mysql_error());
  28. mysql_select_db($db_name, $con) or die(mysql_error());
  29.  
  30. $q = strtolower($_GET["q"]);
  31. if (!$q) return;
  32.  
  33. $sql = "SELECT DISTINCT 'name' AS 'name' FROM 'name' Where 'name' LIKE '%$q%'";
  34. $rsd = mysql_query($sql);
  35. while($rs = mysql_fetch_array($rsd)) {
  36. $cname = $rs['name'];
  37. echo "$cnamen";
  38. }
  39. ?>
Add Comment
Please, Sign In to add comment