PHP开发：如何实现搜索关键词提示和自动补全功能

<script>
  $(document).ready(function(){
    $("#search").keyup(function(){
      var keyword = $(this).val();
      $.ajax({
        url: "suggest.php",
        method: "POST",
        data:{keyword:keyword},
        success:function(data){
          $("#suggest").html(data);
        }
      });
    });
  });
</script>

<?php
  $keyword = $_POST["keyword"];
  
  // 连接数据库
  $conn = new mysqli("localhost", "root", "", "数据库名");
  if($conn->connect_error){
    die("数据库连接失败：" . $conn->connect_error);
  }
  
  // 查询相关的搜索建议
  $sql = "SELECT keyword FROM keywords WHERE keyword LIKE '$keyword%'";
  $result = $conn->query($sql);
  if($result->num_rows > 0){
    while($row = $result->fetch_assoc()){
      echo "<li>" . $row["keyword"] . "</li>";
    }
  }
  $conn->close();
?>

<script>
  $(document).ready(function(){
    $(document).on("click", "#suggest li", function(){
      var keyword = $(this).text();
      $("#search").val(keyword);
      $("#suggest").html("");
    });
  });
</script>