From 166cd8c0866e6069e6405ec9c452188b18a293d6 Mon Sep 17 00:00:00 2001 From: chai Date: Thu, 24 Mar 2022 23:51:49 +0800 Subject: *admin album --- music.php | 34 +++++++++++++++++----------------- 1 file changed, 17 insertions(+), 17 deletions(-) (limited to 'music.php') 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