Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Why my auto completion script (jquery) did not work on my website?
- <script type="text/javascript" src="js/jquery-1.4.2.js"></script>
- <script type='text/javascript' src="js/autocomplete.js"></script>
- <link rel="stylesheet" type="text/css" href="css/autocomplete.css" />
- <script type="text/javascript">
- $().ready(function() {
- $("#name").autocomplete("php/autocompletion.php",{
- width: 260,
- matchContains: true,
- //mustMatch: true,
- //minChars: 0,
- //multiple: true,
- //highlight: false,
- //multipleSeparator: ",",
- selectFirst: false
- });
- });
- </script>
- <?php
- $host="localhost"; // Host name
- $username="name"; // Mysql username
- $password="password"; // Mysql password
- $db_name="dbname"; // Database name
- $con = mysql_connect($host,$username,$password) or die(mysql_error());
- mysql_select_db($db_name, $con) or die(mysql_error());
- $q = strtolower($_GET["q"]);
- if (!$q) return;
- $sql = "SELECT DISTINCT 'name' AS 'name' FROM 'name' Where 'name' LIKE '%$q%'";
- $rsd = mysql_query($sql);
- while($rs = mysql_fetch_array($rsd)) {
- $cname = $rs['name'];
- echo "$cnamen";
- }
- ?>
Add Comment
Please, Sign In to add comment