diff options
Diffstat (limited to 'music.php')
-rw-r--r-- | music.php | 34 |
1 files changed, 17 insertions, 17 deletions
@@ -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); - // } } } |