Databases
StackOverflow2013
Postsdbo
POWhy my auto completion script (jquery) did not work on my website?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhy my auto completion script (jquery) did not work on my website?
    primarykey
    data
    text
    <p>I have downloaded an auto completion(jQuery script) form from net. I am using wamp phpmyadmin server for testing my website(php and mysql) in my computer. When i used the auto completion form in my wamp server it is working properly but when i uploaded to actual website server the script is not working. I am not able to find the problem, its showing no error. can you help me</p> <p>this is my html script</p> <pre><code> &lt;script type="text/javascript" src="js/jquery-1.4.2.js"&gt;&lt;/script&gt; &lt;script type='text/javascript' src="js/autocomplete.js"&gt;&lt;/script&gt; &lt;link rel="stylesheet" type="text/css" href="css/autocomplete.css" /&gt; &lt;script type="text/javascript"&gt; $().ready(function() { $("#name").autocomplete("php/autocompletion.php",{ width: 260, matchContains: true, //mustMatch: true, //minChars: 0, //multiple: true, //highlight: false, //multipleSeparator: ",", selectFirst: false }); }); &lt;/script&gt; </code></pre> <p>autocompletion.php file</p> <pre><code> &lt;?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 "$cname\n"; } ?&gt; </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USmu is too short
    1. USEka
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COIt looks like you might be able to test the ajax responder by putting "your-domain.com/php/autocomplete.php?q=test" in the URL. Have you tried that? (You might need to set display_errors and error_reporting.)
      singulars
      1. POWhy my auto completion script (jquery) did not work on my website?
      1. USghbarratt
    2. COare both servers running the exact same configration?
      singulars
      1. POWhy my auto completion script (jquery) did not work on my website?
      1. USWojonsTech
    3. COWhat is server's error-log showing ?
      singulars
      1. POWhy my auto completion script (jquery) did not work on my website?
      1. UStereško
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload