From 166cd8c0866e6069e6405ec9c452188b18a293d6 Mon Sep 17 00:00:00 2001 From: chai Date: Thu, 24 Mar 2022 23:51:49 +0800 Subject: *admin album --- admin_modify_album.php | 2 +- admin_new_music.php | 4 +++- cover/1648136777_829_cat.png | Bin 0 -> 116264 bytes music.php | 34 +++++++++++++++++----------------- 4 files changed, 21 insertions(+), 19 deletions(-) create mode 100644 cover/1648136777_829_cat.png diff --git a/admin_modify_album.php b/admin_modify_album.php index 568a393..c858bf5 100644 --- a/admin_modify_album.php +++ b/admin_modify_album.php @@ -58,7 +58,7 @@ form .text {
-
+
diff --git a/admin_new_music.php b/admin_new_music.php index d084450..67975bc 100644 --- a/admin_new_music.php +++ b/admin_new_music.php @@ -18,4 +18,6 @@ if($music != null) { // 跳转 header('Location: '.'index.php'); -?> \ No newline at end of file +?> + + diff --git a/cover/1648136777_829_cat.png b/cover/1648136777_829_cat.png new file mode 100644 index 0000000..511d7c1 Binary files /dev/null and b/cover/1648136777_829_cat.png differ diff --git a/music.php b/music.php index 4405401..3d814c1 100644 --- a/music.php +++ b/music.php @@ -425,6 +425,11 @@ function delete_music_album($music) { execute_sql($sql); } +function delete_album_music($album_id) { + $sql = "DELETE FROM " . Config::$tb_album_music . " WHERE album_id=" . $album_id; + execute_sql($sql); +} + // 提交上来的表单中构建music function get_music_from_post() { @@ -613,27 +618,22 @@ function write_album_to_db($album) { } else // 更新 { - // $sql = "UPDATE " . Config::$tb_music . " SET " . - // "path='" . $music->path ."'," . - // "title='" . $music->title ."'," . - // "cover='" . $music->cover ."'," . - // "project='" . $music->project ."'" . - // " WHERE id=" . $music->uid; - // //println($sql); - // execute_sql($sql); + $sql = "UPDATE " . Config::$tb_album . " SET " . + "title='" . $album->title ."'," . + "description='" . $album->description ."'," . + "cover='" . $album->cover ."'" . + " WHERE id=" . $album->uid; + //println($sql); + execute_sql($sql); - // delete_music_tag($music); - // delete_music_album($music); + delete_album_music($album->uid); - // $id = $music->uid; + $id = $album->uid; - // foreach($music->array_tags as $tag){ - // add_unique_music_tag($id, $tag->uid); - // } + foreach($album->array_music_ids as $mid){ + add_unique_music_album($mid, $id); + } - // foreach($music->array_albums as $album){ - // add_unique_music_album($id, $album->uid); - // } } } -- cgit v1.1-26-g67d0