* paginate

1 files changed, 37 insertions, 1 deletions

diff --git a/music.php b/music.php
index acd4165..797f48a 100644
--- a/music.php
+++ b/music.php
@@ -207,8 +207,20 @@ function fetch_musics_by_name($name, $from=0, $count=100) {
     return $arr;
 }
 
+function get_music_count_by_name($name) {
+    $sql = "SELECT COUNT(*) as count FROM " . Config::$tb_music . " WHERE title LIKE '%" . $name . "%'";
+    $result = execute_sql($sql);
+    if($result == null || $result->num_rows == 0)
+        return 0;
+    $row = mysqli_fetch_assoc($result);
+    if($row != null){
+        return $row['count']; 
+    }
+    return 0;
+}
+
 function fetch_musics_by_tag($tag_id, $from=0, $count=100) {
-    $sql = "SELECT music_id FROM " . Config::$tb_music_tag . " WHERE tag_id=" . $tag_id ;//. " ORDER  BY time DESC LIMIT " . $from . ", " . $count;
+    $sql = "SELECT music_id FROM " . Config::$tb_music_tag . " WHERE tag_id=" . $tag_id . " ORDER  BY music_id DESC LIMIT " . $from . ", " . $count;
     $result = execute_sql($sql);
     if($result == null || $result->num_rows == 0)
         return ;
@@ -221,6 +233,18 @@ function fetch_musics_by_tag($tag_id, $from=0, $count=100) {
     return $arr;
 }
 
+function get_music_count_by_tag($tag_id) {
+    $sql = "SELECT COUNT(*) as count FROM " . Config::$tb_music_tag . " WHERE tag_id=" . $tag_id ;
+    $result = execute_sql($sql);
+    if($result == null || $result->num_rows == 0)
+        return 0;
+    $row = mysqli_fetch_assoc($result);
+    if($row != null){
+        return $row['count']; 
+    }
+    return 0;
+}
+
 function fetch_musics_by_album($album_id, $from=0, $count=100) {
     $sql = "SELECT music_id FROM " . Config::$tb_album_music .  " WHERE album_id=" . $album_id . " ORDER  BY time DESC LIMIT " . $from . ", " . $count;
     $result = execute_sql($sql);
@@ -235,6 +259,18 @@ function fetch_musics_by_album($album_id, $from=0, $count=100) {
     return $arr;
 }
 
+function get_all_music_count() {
+    $sql = "SELECT COUNT(*) as count FROM " . Config::$tb_music;
+    $result = execute_sql($sql);
+    if($result == null || $result->num_rows == 0)
+        return 0;
+    $row = mysqli_fetch_assoc($result);
+    if($row != null){
+        return $row['count']; 
+    }
+    return 0;
+}
+
 function add_unique_music_tag( $music_id, $tag_id )
 {
     $result =  execute_sql("SELECT * FROM " . Config::$tb_music_tag . " where music_id=" . $music_id . " and tag_id=" . $tag_id );