From 4e92033683d250c06d3e9f39caf675adc4b339f2 Mon Sep 17 00:00:00 2001
From: chai <chaifix@163.com>
Date: Fri, 25 Mar 2022 11:03:09 +0800
Subject: +album page

---
 music.php | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)

(limited to 'music.php')

diff --git a/music.php b/music.php
index 3d814c1..8dcf178 100644
--- a/music.php
+++ b/music.php
@@ -196,6 +196,34 @@ function fetch_album_by_id($uid) {
     }
 }
 
+function fetch_album_music_ranged($album_id, $from=0, $count=100) {
+    $sql = "SELECT music_id FROM " . Config::$tb_album_music . " WHERE album_id=" . $album_id . "  ORDER  BY id DESC LIMIT " . $from . ", " . $count ;;
+    $result = execute_sql($sql);
+    if($result == NULL || $result->num_rows == 0)
+    {
+        return null;   
+    }
+    $arr = array();
+    while($row = mysqli_fetch_assoc($result)){
+        $id = $row['music_id'];
+        $music = fetch_music_by_id($id);
+        array_push($arr, $music);
+    }
+    return $arr;
+}
+
+function get_all_album_music_count($album_id) {
+    $sql = "SELECT COUNT(*) as count FROM " . Config::$tb_album_music . " WHERE album_id=" . $album_id;//. "  ORDER  BY id DESC LIMIT " . $from . ", " . $count ;;
+    $result = execute_sql($sql);
+    if($result == NULL || $result->num_rows == 0)
+        return null;   
+    $row = mysqli_fetch_assoc($result);
+    if($row != null){
+        return $row['count']; 
+    }
+    return 0;
+}
+
 // 从第from个记录开始的count个
 function fetch_range_music($from=0, $count=100) {
     $sql = "SELECT id FROM " . Config::$tb_music .  "  ORDER  BY time DESC LIMIT " . $from . ", " . $count ;
-- 
cgit v1.1-26-g67d0