本帖最后由 麻木先生 于 2025-10-5 11:27 编辑
首页显示能按热度显示吗
首页显示按热度代码
将下面代码
// 为每种视频类型获取分类和视频数据
foreach ($videoTypes as $type) {
$typeId = $type['id'];
// 获取该类型下的所有分类
$stmt = $pdo->prepare("SELECT * FROM movie_categories WHERE type = :typeId AND status = 1");
$stmt->bindParam(':typeId', $typeId, PDO::PARAM_INT);
$stmt->execute();
$typeCategories[$typeId] = $stmt->fetchAll();
// 获取该类型下最新的视频 - 使用统一的状态过滤条件并增加类型过滤
$stmt = $pdo->prepare("SELECT m.* FROM movies m
$statusFilterSql
AND m.type = :typeId
ORDER BY m.create_time DESC LIMIT 12"); // 数字代表各类型区获取的视频数量
$stmt->bindParam(':typeId', $typeId, PDO::PARAM_INT);
$stmt->execute();
$typeMovies[$typeId] = $stmt->fetchAll();
}
替换为
// 为每种视频类型获取分类和视频数据
foreach ($videoTypes as $type) {
$typeId = $type['id'];
// 获取该类型下的所有分类
$stmt = $pdo->prepare("SELECT * FROM movie_categories WHERE type = :typeId AND status = 1");
$stmt->bindParam(':typeId', $typeId, PDO::PARAM_INT);
$stmt->execute();
$typeCategories[$typeId] = $stmt->fetchAll();
// 获取该类型下最新的视频 - 使用统一的状态过滤条件并增加类型过滤,并按热度降序排序
$stmt = $pdo->prepare("SELECT m.* FROM movies m
$statusFilterSql
AND m.type = :typeId
ORDER BY m.view_count DESC, m.create_time DESC LIMIT 12"); // 数字代表各类型区获取的视频数量
$stmt->bindParam(':typeId', $typeId, PDO::PARAM_INT);
$stmt->execute();
$typeMovies[$typeId] = $stmt->fetchAll();
}
|