如何用PHP实现CMS系统的图片轮播功能

CREATE TABLE slides (
  id INT PRIMARY KEY AUTO_INCREMENT,
  title VARCHAR(255) NOT NULL,
  description TEXT,
  image VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

<div id="carouselExampleControls" class="carousel slide" data-ride="carousel">
  <div class="carousel-inner" id="carousel-inner">
    <!-- 图片轮播内容 -->
  </div>
    <a class="carousel-control-prev" href="#carouselExampleControls" role="button" data-slide="prev">
        <span class="carousel-control-prev-icon" aria-hidden="true"></span>
        <span class="sr-only">Previous</span>
    </a>
    <a class="carousel-control-next" href="#carouselExampleControls" role="button" data-slide="next">
        <span class="carousel-control-next-icon" aria-hidden="true"></span>
        <span class="sr-only">Next</span>
    </a>
</div>

<?php
// 连接数据库
$conn = new mysqli("localhost", "username", "password", "database");

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

// 从数据库中获取所有轮播图片的信息
$sql = "SELECT * FROM slides";
$result = $conn->query($sql);

// 添加轮播图片到轮播器
if ($result->num_rows > 0) {
  while ($row = $result->fetch_assoc()) {
    echo '<div class="carousel-item">';
    echo '<img src="' . $row["image"] . '" class="d-block w-100" alt="' . $row["title"] . '">';
    echo '<div class="carousel-caption d-none d-md-block">';
    echo '<h5>' . $row["title"] . '</h5>';
    echo '<p>' . $row["description"] . '</p>';
    echo '</div>';
    echo '</div>';
  }
}

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

$(document).ready(function() {
  $('.carousel').carousel();
});