如何在php中使用ajax搜索关键字

Question

Not showing any data from php into ajax. Any help would be appreciated.

HTML:

 Search Box:<input type="text" name="search" id="search">
 <div id="search1"></div>

AJAX:

        $("#search").keyup(function(){
        var search=$(this).val();
                 $.ajax({  //GR ID Generation
                  method: "GET",
                  url: "search_rep.php?invo="+search,
                })

                  .done(function( msg ) {
        $("#search").html(msg); 
        $("#search1").val();      
        }); 

PHP:

    $in  = mysql_real_escape_string($_GET['invo']);
    $msg = '';
    if(strlen($in) > 0 && strlen($in) < 20){
      $row = mysql_query("SELECT Bot_Name
                        FROM bot_info 
                        WHERE Bot_Name 
                        LIKE '%$in%'and  Bot_Type='Printed'",$con );
      while($result = mysql_fetch_array($row)){
        $msg .= $result['Bot_Name'] . "<br />";
      }
    }

Output should be shown as google search engine once You type a word automatic all sentences are shown regarding to that word.

Answer 1

You don't seem to be echoing any data out onto the page in PHP. Consider trying

$in  = mysql_real_escape_string($_GET['invo']);
$msg = '';
if(strlen($in) > 0 && strlen($in) < 20){
  $row = mysql_query("SELECT Bot_Name
                    FROM bot_info 
                    WHERE Bot_Name 
                    LIKE '%$in%'and  Bot_Type='Printed'",$con );
  while($result = mysql_fetch_array($row)){
    $msg .= $result['Bot_Name'] . "<br />";
  }
}
echo $msg;

You may also want to look at using MySQLi rather than the soon depreciated MySQL in PHP.

If that fails to work, it may possibly be an issue with your database or another area of your code, let me know.