如何使用autocomplete将我的MySQL数据编码到Bootstrap输入标记中？

<input type="text" id="myInput" class="form-control" autocomplete="off">

$(document).ready(function() {
  $('#myInput').autocomplete({
    source: function(request, response) {
      $.ajax({
        url: 'your_php_script.php', // 替换为你的服务器端脚本文件路径
        dataType: 'json',
        data: {
          term: request.term
        },
        success: function(data) {
          response(data);
        }
      });
    },
    minLength: 2 // 设置最小输入字符数
  });
});

<?php
// 连接到MySQL数据库
$servername = "your_servername";
$username = "your_username";
$password = "your_password";
$dbname = "your_dbname";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
  die("连接失败: " . $conn->connect_error);
}

// 获取前端传递的搜索关键字
$term = $_GET['term'];

// 查询数据库中匹配的数据
$sql = "SELECT column_name FROM table_name WHERE column_name LIKE '%$term%'";
$result = $conn->query($sql);

// 将查询结果编码为JSON格式并返回给前端
$data = array();
if ($result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    $data[] = $row['column_name'];
  }
}
echo json_encode($data);

// 关闭数据库连接
$conn->close();
?>