Autocomplete using PHP MYSQL not working

Autocomplete using PHP MYSQL not working

Dear Sir

refer


Auto complete not working

PHP+ JQUERY
  2. <?php //autocompleteindex.php
  3. include_once('../includes/dbconnect.php');
  4. $query = 'SELECT bg.name, bg.surname   FROM member bg WHERE bg.name LIKE "%'.$user_input.'%"';
  5.  
  6.      mysql_select_db($database_DBconnect, $DBconnect);
  7. $Result = mysql_query($query, $DBconnect) or die(mysql_error());
  8. $rows = mysql_fetch_assoc($Result);
  9. $totalrows=mysql_num_rows($Result);
  10. echo "<br> Checking the Database Connection <br> ";
  11. echo "<br>".$query."<br> total number of  rows ".$totalrows;
  12.      echo "<br>Name ".$rows['name']."<br> Surname ".$rows['surname'];
  13. ?>
  14. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  15. <html xmlns="http://www.w3.org/1999/xhtml">
  16. <head>
  17. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  18. <title>Autocomplete search in PHP, Mysql, Json, Autosuggestion search in PHP, Jquery UI</title>
  19. <meta name="description" content="This is a programming code for auto complete search in PHP, Mysql, Json or Facebook like Autosuggestion. This is a auto Complete Search tutorial developed in php, mysql and jQuery UI. Here I use Json to get response from database. After getting search data user can navigate to respective URL by href link in json."/>
  20. <meta name="keywords" content="Auto complete search, jQuery UI Autocomplete Search, PHP Autocomplete, Auto complete, Facebook Like auto complete, Facebook like Auto suggestion, Autosuggestion, Search, Search in PHP, autocomplete search, autocomplete search in Json, json, php, mysql, online demo, download code, rss, codeing, code, php programming, programming, php demo, jquery demo, discussdesk programming blog, discussdesk, jquery tutorial, technology"/>

  22. <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js"></script>
  23. <script type="text/javascript" src="jquery-ui-1.8.2.custom.min.js"></script> 
  24. <link href="css.css" rel="stylesheet" type="text/css" />

  26. <script type="text/javascript">
  27.  
  28. $(function() {
  29.  
  30. $("#dd_user_input").autocomplete({
  31. source: "global_search.php",
  32. minLength: 2,
  33. select: function(event, ui) {
  34. var getUrl = ui.item.id;
  35. if(getUrl != '#') {
  36. location.href = getUrl;
  37. }
  38. },
  39.  
  40. html: true,
  41.  
  42. open: function(event, ui) {
  43. $(".ui-autocomplete").css("z-index", 1000);
  44. }
  45. });
  46.  
  47. });
  48. </script>
  49. <br /><br />- See more at: http://www.discussdesk.com/autocomplete-search-in-php-mysql-json-with-navigation.htm#sthash.TM2XnzsS.dpuf

  51. <style>
  52. .cnt_left {
  53.     border: 1px solid #EEEEEE;
  54.     padding-right: 20px;
  55.     width: 660px;
  56. height:250px;
  57. }
  58. .cnt_right {
  59.     width: 316px;
  60. border: 1px solid #EEEEEE;
  61. height: 250px;
  62. }
  63. .floatL {
  64. float:left;
  65. }
  66. .floatR {
  67. float:right;
  68. }
  69. .container{width:1000px;margin:auto;}
  70. .home_link{padding:10px;}
  71. .home_link a {
  72.     color: #0D92E1;
  73.     font: bold 23px arial;
  74.     text-decoration:underline;
  75. }
  76. .main_subs{ border:1px solid #0D92E1;  background:#F3F3F3; height:180px;}
  77. .main_subs p{padding:5px 0 0 5px; color:#0D92E1; font: bold 18px arial,tahoma;}
  78. .subs_email{font: normal 12px arial,tahoma; padding: 26px 0 0 35px;}
  79. .in_subs{padding:5px 0 0 5px; color:#0D92E1; font: bold 18px arial,tahoma;}
  80. .in_subs input{padding:5px 0 0 5px; color:#ccc; font: normal 15px arial,tahoma;}
  81. </style>
  82. </head>
  83. <body>
  84. <div class="container">
  85. <div class="cnt_left floatL">
  86. <div class="home_link"><a href="http://www.discussdesk.com/autocomplete-search-in-php-mysql-json-with-navigation.htm">Autocomplete search in PHP, Mysql, Json with href Link Navigation</a></div>
  87. <div style="border: 1px solid #EEEEEE;"></div>

  89. <form onsubmit="return false;"> 
  90. <input id="dd_user_input" type="text" class="search_form" onblur="if(this.value=='')this.value=this.defaultValue;" onfocus="if(this.value==this.defaultValue)this.value='';" value="Type your Input Here"/> 
  91. </form>

  93. </div>

  95. <div class="cnt_right floatR">
  96. <div class="main_subs">
  97. <p>Subscribe for our Latest articles</p>
  98. <form onsubmit="window.open('http://feedburner.google.com/fb/a/mailverify?uri=discussdesk', 'popupwindow', 'scrollbars=yes,width=550,height=520');return true" target="popupwindow" method="post" action="http://feedburner.google.com/fb/a/mailverify">
  99. <div class="in_subs"><input type="text" onblur="if(this.value=='')this.value=this.defaultValue;" onfocus="if(this.value==this.defaultValue)this.value='';" value="Enter your email address:" name="email" style="width:258px; height:30px; float:left; border: 2px double #DDDDDD;"></div>
  100. <input type="hidden" name="uri" value="discussdesk">
  101. <input type="hidden" value="en_US" name="loc">
  102. <input type="submit" value="Subscribe" style="font: 17px arial,tahoma;height: 39px;margin: 10px 9px 4px;width: 142px;" class="gsc-search-button"></form>
  103. </div>
  104. </div>

  106. </div>
  107. </div>

  109. <script type="text/javascript">

  111.   var _gaq = _gaq || [];
  112.   _gaq.push(['_setAccount', 'UA-38304687-1']);
  113.   _gaq.push(['_trackPageview']);

  115.   (function() {
  116.     var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
  117.     ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
  118.     var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  119.   })();

  121. </script>

  123. </body>
  124. </html>


PHp Code (Database)

global_search.php

This code I believer is never called ..
  2. <?php
  3. /*====================== Database Connection Code Start Here =======================  

  5. define ("DB_HOST", "localhost"); // set database host
  6. define ("DB_USER", ""); // set database user
  7. define ("DB_PASS",""); // set database password
  8. define ("DB_NAME",""); // set database name

  10. $link = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("Couldn't make connection.");
  11. $db = mysql_select_db(DB_NAME, $link) or die("Couldn't select database");

  13. /*====================== Database Connection Code End Here ========================== */

  15. // Here, we will get user input data and trim it, if any space in that user input data
  16. $user_input = trim($_REQUEST['term']);

  18. // Define two array, one is to store output data and other is for display
  19. $display_json = array();
  20. $json_arr = array();
  21.  

  23. $user_input = preg_replace('/\s+/', ' ', $user_input);

  25. $query = 'SELECT bg.name, bg.surname FROM member bg WHERE bg.name LIKE "%'.$user_input.'%"';
  26.  
  27. $recSql = mysql_query($query);
  28. if(mysql_num_rows($recSql)>0){
  29. while($recResult = mysql_fetch_assoc($recSql)) {
  30.  // $json_arr["id"] = "http://www.discussdesk.com/".$recResult['url'].".htm";
  31.   $json_arr["id"] = "http://www.webvikas.net.in/marathe/".$recResult['url'].".htm";

  33.   $json_arr["value"] = $recResult['name'];
  34.   $json_arr["label"] = $recResult['name'];
  35.   array_push($display_json, $json_arr);
  36. }
  37. } else {
  38.   $json_arr["id"] = "#";
  39.   $json_arr["value"] = "";
  40.   $json_arr["label"] = "No Result Found !";
  41.   array_push($display_json, $json_arr);
  42. }
  43.  
  45. $jsonWrite = json_encode($display_json); //encode that search data
  46. print $jsonWrite;
  47. ?>