phpcms 组图排序

<?php
// 假设我们有一个图片表 images，包含 id, title, sort_order 等字段

// 获取所有图片数据
$sql = "SELECT * FROM images ORDER BY sort_order ASC";
$result = mysqli_query($conn, $sql);
$images = mysqli_fetch_all($result, MYSQLI_ASSOC);

// 更新图片排序
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    $newOrder = $_POST['sort_order'];
    foreach ($newOrder as $index => $id) {
        $sql = "UPDATE images SET sort_order = $index WHERE id = $id";
        mysqli_query($conn, $sql);
    }
}

// 前端展示
?>
<form method="post">
    <ul>
        <?php foreach ($images as $image): ?>
            <li>
                <img src="<?php echo $image['url']; ?>" alt="<?php echo $image['title']; ?>">
                <input type="hidden" name="sort_order[]" value="<?php echo $image['id']; ?>">
            </li>
        <?php endforeach; ?>
    </ul>
    <button type="submit">保存排序</button>
</form>