summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorchai <chaifix@163.com>2022-03-24 23:51:49 +0800
committerchai <chaifix@163.com>2022-03-24 23:51:49 +0800
commit166cd8c0866e6069e6405ec9c452188b18a293d6 (patch)
tree2d3f1c945554cd7043dfe412e1250ea35ade94ca
parent1d127b4ae3e31456f0a8351388cefa4d13d3a4b0 (diff)
*admin album
-rw-r--r--admin_modify_album.php2
-rw-r--r--admin_new_music.php4
-rw-r--r--cover/1648136777_829_cat.pngbin0 -> 116264 bytes
-rw-r--r--music.php34
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
new file mode 100644
index 0000000..511d7c1
--- /dev/null
+++ b/cover/1648136777_829_cat.png
Binary files 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);
- // }
}
}