diff options
author | chai <chaifix@163.com> | 2022-03-24 23:51:49 +0800 |
---|---|---|
committer | chai <chaifix@163.com> | 2022-03-24 23:51:49 +0800 |
commit | 166cd8c0866e6069e6405ec9c452188b18a293d6 (patch) | |
tree | 2d3f1c945554cd7043dfe412e1250ea35ade94ca | |
parent | 1d127b4ae3e31456f0a8351388cefa4d13d3a4b0 (diff) |
*admin album
-rw-r--r-- | admin_modify_album.php | 2 | ||||
-rw-r--r-- | admin_new_music.php | 4 | ||||
-rw-r--r-- | cover/1648136777_829_cat.png | bin | 0 -> 116264 bytes | |||
-rw-r--r-- | music.php | 34 |
4 files changed, 21 insertions, 19 deletions
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 { </div> <div class="section"> <label class="title" for="music_list" >music ids (seprate with comma):</label> - <input class="text" type="text" name="music_list" value="<?php echo get_albums_music_id_string($album);?>"/><br/> + <textarea class="text" type="text" name="music_list" style="max-width:100%;min-height:60px;"><?php echo get_albums_music_id_string($album);?></textarea><br/> </div> <input style="float:right" type="submit" value="Update" name="submit"/> </form> 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 Binary files differnew file mode 100644 index 0000000..511d7c1 --- /dev/null +++ b/cover/1648136777_829_cat.png @@ -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); - // } } } |