Detailed explanation of how to implement a simple search box automatic prompt function in PHP-PHP Tutorial-php.cn

Detailed explanation of how to implement a simple search box automatic prompt function in PHP

*文

Release： 2023-03-19 06:50:01

Original

4508 people have browsed it

How to implement a simple search box automatic prompt function? This article mainly introduces the simple retrieval automatic completion prompt function implemented by php+mysql+jquery, involving the operation skills related to ajax database query and event dynamic response based on jQuery. Friends in need can refer to it. I hope to be helpful.

The details are as follows:

I have read some content about automatic completion prompts during this period and found that most of the implementation processes are very complicated. I thought this should be a relatively simple function, so I tried it myself. The idea is very conventional. It should be noted that there are no keyboard events bound to the prompt content, and only mouse operations can be used.

html+jQuery content:

<html>
<head>
  <style type="text/css">
    #autoBox
    {
      margin: 0px;
      padding: 0px;
      border: 1px solid #CCCCCC;
      width: 200px;
    }
    #autoBox li
    {
      clear: both;
      background-color: white;
      color: black;
      position: relative;
      top: 0px;
      left: 0px;
      line-height: 25px;
      width:200px;
      text-align: left;
      overflow: hidden;
    }
    #autoBox li:hover
    {
      background-color: gray;
      color: yellow;
      cursor: pointer;
    }
  </style>
<script type="text/javascript" src="js/jquery-1.9.1.min.js"></script>
<script type="text/javascript">
  $(function(){
    $.ajaxSetup({cache:false}) ; //不缓存
    //以下代码用于显示检索提示框
    $("#autoBox").hide(); //初始化时隐藏补全提示框
    $("#stuSearch").keyup(function(){ //输入框中的keyup事件激活以下查询行为
      $("#autoBox").html(""); //先清空补全提示框原有内容
      if($("#stuSearch").val().length>0) // 如果输入框不为空
      {
        $.ajax({ //后台调用php文件进行查询
          type:"post",
          url:"phpFiles/stuSearch.php",
          dataType:"json",
          data:{keywords:$("#stuSearch").val()},
          success:function(feedbackdata)
            {
              $("#autoBox").show();// 显示补全提示框
              for(i=0;i<feedbackdata.length;i++) //将结果添加到提示框中
              {
                $("#autoBox").append("<li>"+feedbackdata[i][&#39;truename&#39;]+"</li>");
              }
              $("#autoBox li").on("click",function(){ //为这些新增的li绑定单击事件，单击后将其值赋到输入框中
                $("#stuSearch").val($(this).text());
              })
              $("#autoBox").append("<li style=&#39;text-align:right&#39;>关闭</li>");//在提示框的最后添加一个li用来关闭
              $("#autoBox li:last").on("click",function(){ // 添加单击事件，单击后隐藏提示框
                $("#autoBox").hide();
              })
            }
        });
      }
    })
  })
</script>
</head>
<body>
<input type="text" placeholder="输入您想检索的关键词后回车。" id="stuSearch" name="stuSearch"/>
<ul id="autoBox">
</ul>
</body>
</html>

Copy after login

stuSearch.php code

<?php
  include &#39;../phpFiles/connMysql.php&#39;;
  $keywords=$_POST[&#39;keywords&#39;];
  $myrs=mysql_query("select * from users where truename like &#39;".$keywords."%&#39;");
  if($myrs)
  {
    while($row=mysql_fetch_array($myrs))
    {
      $temp[]=$row;
    }
    echo(json_encode($temp));
  }
?>

Copy after login

Rendering

When inputting:

After clicking on an item:

Related recommendations:

Detailed explanation of PHP Implement Sudoku solving

Detailed explanation on how to dynamically transfer data to highcharts through php

Detailed explanation How to generate time-sensitive ciphertext with PHP

The above is the detailed content of Detailed explanation of how to implement a simple search box automatic prompt function in PHP. For more information, please follow other related articles on the PHP Chinese website!