⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 album.php

📁 1、上传所有文件至服务器目录。 2、使用 MYSQL 管理工具
💻 PHP
字号:
🔍 
<?php
error_reporting(7);

require("./global.php");

unset($query);

if ($getperms[canadminmusicalbum]!=1) {
  echo "<p>您的权限不够!</p>\n";
  exit;
}

cpheader();

if (!isset($action)) {
  $action="modify";
}

// ###################### Start Add #######################
if ($action=="add") {
  if ($sclassid=="") {
    echo "<p>添加新的专辑 请选择专辑歌手所在的类别:</p>";

    $classes=$DB_site->query("SELECT * FROM ".$table["sclass"]." ORDER BY SClassID");

    doformheader("","");
    maketableheader("类别列表");

    while ($class=$DB_site->fetch_array($classes)) {
      makedescription(makelinkcode("  ".$class[SClassName]."  ","album.php?s=$session[sessionhash]&action=add&sclassid=$class[SClassID]&sclassname=".urlencode($class[SClassName]).""));
    }
    dotablefooter();

  } else if ($namecode=="") {

    echo "<p>添加新的专辑 请选择专辑歌手首字母索引:</p>";

    $namecodes=$DB_site->query("SELECT NameCode FROM ".$table["nclass"]." WHERE SClassID=$sclassid GROUP BY NameCode");

    doformheader("","");
    maketableheader("歌手首字母索引");
    $strnamecode="";
    while ($namecode=$DB_site->fetch_array($namecodes)) {
      $strnamecode.="<a href=\"album.php?s=$session[sessionhash]&action=add&sclassid=$sclassid&sclassname=".urlencode($sclassname)."&namecode=".$namecode[NameCode]."\"><B>$namecode[NameCode]</B></a> ";
    }
    makedescription($strnamecode);
    dotablefooter();

  } else if ($nclassid=="") {
    echo "<p>添加新的专辑 请选择专辑歌手:</p>";

    $classes=$DB_site->query("SELECT * FROM ".$table["nclass"]." WHERE NameCode='$namecode' AND SClassID=$sclassid");

    doformheader("","");
    maketableheader($namecode,$namecode);
    while ($class=$DB_site->fetch_array($classes)) {
      makedescription("<div align=\"center\">
                       <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">
                       <tr>
                         <td width=\"30%\">&nbsp;&nbsp;<a href=\"album.php?s=$session[sessionhash]&action=add&sclassid=$class[SClassID]&nclassid=$class[NClassID]&nclassname=".urlencode($class[NClassName])."&sclassname=".urlencode($sclassname)."&namecode=$namecode\">$class[NClassName]</a></td>
                         <td width=\"30%\"><a href=\"album.php?s=$session[sessionhash]&action=add&sclassid=$class[SClassID]&nclassid=$class[NClassID]&nclassname=".urlencode($class[NClassName])."&sclassname=".urlencode($sclassname)."&namecode=$namecode\"><---进入添加专辑</a></td>
                         <td width=\"40%\"><a href=\"music.php?s=$session[sessionhash]&action=add&sclassid=$class[SClassID]&nclassid=$class[NClassID]&nclassname=".urlencode($class[NClassName])."&sclassname=".urlencode($sclassname)."&namecode=$namecode\">添加音乐</a></td>
                       </tr>
                       </table>
                       </div>");
    }
    dotablefooter();

  } else {
    doformheader("album","insert");
    maketableheader("添加新专辑");
    makehiddencode("sclassid",$sclassid);
    makehiddencode("sclassname",$sclassname);
    makehiddencode("nclassid",$nclassid);
    makehiddencode("nclassname",$nclassname);

    makelabelcode("类别名",$sclassname);
    makelabelcode("歌手名",$nclassname);
    makeinputcode("专辑名称","albumname");

    makeoption("国语");
    makeoption("粤语");
    makeoption("台语");
    makeoption("客语");
    makeoption("英文");
    makeoption("日韩");
    makeoption("韩文");
    makeoption("日语");
    makeoption("国/粤语");
    makeoption("中/英文");
    makeoption("中/日文");
    makeoption("中/韩文");
    makeoption("俄语");
    makeoption("法语");
    makeoption("德语");
    makeoption("纯音乐");
    makeselect("所属语言","language");

    makeinputcode("唱片公司","company");
    makeinputcode("发行日期","times");
    makeinputcode("专辑图片路径","filename", "img/");

    maketextareacode("专辑简介","intro","",5);
    makeyesnocode("是否推荐","isgood",0);
    makeinputcode("同时添加歌曲数目<BR/>0 为不同时添加歌曲","musicnum",0);

    doformfooter("保存");
  }

}

// ###################### Start Insert #######################
if ($HTTP_POST_VARS['action']=="insert") {

  $DB_site->query("INSERT INTO ".$table["special"]." (SpecialID,ClassID,SClassID,SClassName,NClassID,NClassName,Name,Language,Company,PhotoPath,Intro,PublishTime,Hits,IsGood) VALUES 
                                                       (NULL,1,$sclassid,'".addslashes($sclassname)."',$nclassid,'".addslashes($nclassname)."','".addslashes($albumname)."','".addslashes($language)."','".addslashes($company)."','".addslashes($filename)."','".addslashes(text2html($intro))."','".addslashes($times)."',0,$isgood)");
  $albumid = $DB_site->insert_id();

  echo "<p>专辑记录已经添加</p>";

  if (intval($musicnum)>0) {
    $musicnum = intval($musicnum);

    doformheader("album","insertmusic");
    maketableheader("添加新专辑的歌曲");
    makehiddencode("sclassid",$sclassid);
    makehiddencode("nclassid",$nclassid);
    makehiddencode("singer",$nclassname);
    makehiddencode("albumid",$albumid);
    makehiddencode("musicnum",$musicnum);

    makelabelcode("类别名",$sclassname);
    makelabelcode("歌手名",$nclassname);
    makelabelcode("专辑名称",$albumname);

    for ($i=1; $i<=$musicnum; $i++) {
      maketableheader("歌曲编号: No.".$i);
      makeinputcode("歌曲名称","musicname_".$i);
      makeinputcode("歌曲文件路径","filename_".$i);
      makeyesnocode("是否推荐","isgood_".$i,0);
    }

    doformfooter("保存");
  }

}

// ###################### Start InsertMusic #######################
if ($HTTP_POST_VARS['action']=="insertmusic") {

  $musicnum = intval($musicnum);
  for ($i=1; $i<=$musicnum; $i++) {
    eval("\$filename = \$filename_$i;");
    eval("\$musicname = \$musicname_$i;");
    eval("\$isgood = \$isgood_$i;");
    $DB_site->query("INSERT INTO ".$table["musiclist"]." (ID,FileName,MusicName,Singer,ClassID,SClassID,NClassID,SpecialID,Hits,IsGood) VALUES 
                                                         (NULL,'".addslashes($filename)."','".addslashes($musicname)."','".addslashes($singer)."',1,$sclassid,$nclassid,$albumid,0,$isgood)");
  }

  echo "<p>记录已经添加 添加了 <font color=blue>$musicnum</font> 首歌曲记录</p>";

}

// ###################### Start Modify #######################
if ($action=="modify") {
  if ($sclassid=="") {
    echo "<p>修改专辑资料 请选择专辑歌手所在的类别:</p>";

    $classes=$DB_site->query("SELECT * FROM ".$table["sclass"]." ORDER BY SClassID");

    doformheader("","");
    maketableheader("类别列表");

    while ($class=$DB_site->fetch_array($classes)) {
      makedescription(makelinkcode("  ".$class[SClassName]."  ","album.php?s=$session[sessionhash]&action=modify&sclassid=$class[SClassID]&sclassname=".urlencode($class[SClassName]).""));
    }
    dotablefooter();

  } else if ($namecode=="") {

    echo "<p>修改专辑资料 请选择专辑歌手首字母索引:</p>";

    $namecodes=$DB_site->query("SELECT NameCode FROM ".$table["nclass"]." WHERE SClassID=$sclassid GROUP BY NameCode");

    doformheader("","");
    maketableheader("歌手首字母索引");
    $strnamecode="";
    while ($namecode=$DB_site->fetch_array($namecodes)) {
      $strnamecode.="<a href=\"album.php?s=$session[sessionhash]&action=modify&sclassid=$sclassid&sclassname=".urlencode($sclassname)."&namecode=".$namecode[NameCode]."\"><B>$namecode[NameCode]</B></a> ";
    }
    makedescription($strnamecode);
    dotablefooter();

  } else if ($nclassid=="") {
    echo "<p>修改专辑资料 请选择专辑歌手:</p>";

    $classes=$DB_site->query("SELECT * FROM ".$table["nclass"]." WHERE NameCode='$namecode' AND SClassID=$sclassid");

    doformheader("","");
    maketableheader($namecode,$namecode);
    while ($class=$DB_site->fetch_array($classes)) {
      makedescription("<div align=\"center\">
                       <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">
                       <tr>
                         <td width=\"30%\">&nbsp;&nbsp;<a href=\"album.php?s=$session[sessionhash]&action=modify&sclassid=$class[SClassID]&nclassid=$class[NClassID]&nclassname=".urlencode($class[NClassName])."&sclassname=".urlencode($sclassname)."&namecode=$namecode\">$class[NClassName]</a></td>
                         <td width=\"30%\"><a href=\"album.php?s=$session[sessionhash]&action=modify&sclassid=$class[SClassID]&nclassid=$class[NClassID]&nclassname=".urlencode($class[NClassName])."&sclassname=".urlencode($sclassname)."&namecode=$namecode\">选择专辑</a></td>
                         <td width=\"40%\"><a href=\"music.php?s=$session[sessionhash]&action=add&sclassid=$class[SClassID]&nclassid=$class[NClassID]&nclassname=".urlencode($class[NClassName])."&sclassname=".urlencode($sclassname)."&namecode=$namecode\">添加音乐</a></td>
                       </tr>
                       </table>
                       </div>");
    }
    dotablefooter();

  } else if ($albumid=="") {
    echo "<p>修改专辑资料 请选择专辑:</p>";

    $albums=$DB_site->query("SELECT * FROM ".$table["special"]." WHERE NClassID=".$nclassid." ORDER BY SpecialID");

    doformheader("","");
    maketableheader("歌手专辑列表");
    while ($album=$DB_site->fetch_array($albums)) {
        makedescription("<table width='90%' border='0' align='center'><tr valign='top'><td>
        <li>".makelinkcode(" $album[Name] ","album.php?s=$session[sessionhash]&action=edit&albumid=".$album[SpecialID])."</li>
        </td><td align='right' width='60'>
        <li>".makelinkcode("编辑","album.php?s=$session[sessionhash]&action=edit&albumid=".$album[SpecialID])."</li>
        </td><td align='right' width='60'>
        <li>".makelinkcode("删除","album.php?s=$session[sessionhash]&action=remove&albumid=".$album[SpecialID])."</li>
        </td></tr></table>");
    }
    dotablefooter();
  }

}

// ###################### Start Edit #######################
if ($action=="edit") {

  $album=$DB_site->query_first("SELECT * FROM ".$table["special"]." WHERE SpecialID=$albumid");

  doformheader("album","doupdate");
  maketableheader("编辑专辑资料");
  makehiddencode("albumid",$album["SpecialID"]);

  makelabelcode("类别名",$album["SClassName"]);
  makenclasschoosercode("专辑歌手","nclassid",$album["SClassID"],$album["NClassID"]);
  makeinputcode("专辑名称","albumname",$album["Name"]);

  makeoption($album["Language"]);
  makeoption("国语");
  makeoption("粤语");
  makeoption("台语");
  makeoption("客语");
  makeoption("英文");
  makeoption("日韩");
  makeoption("韩文");
  makeoption("日语");
  makeoption("国/粤语");
  makeoption("中/英文");
  makeoption("中/日文");
  makeoption("中/韩文");
  makeoption("俄语");
  makeoption("法语");
  makeoption("德语");
  makeoption("纯音乐");
  makeselect("所属语言","language");

  makeinputcode("唱片公司","company",$album["Company"]);
  makeinputcode("发行日期","times",$album["PublishTime"]);
  makeinputcode("专辑图片路径","filename",$album["PhotoPath"]);
  maketextareacode("专辑简介","intro",$album["Intro"],5,40,0);
  makeyesnocode("是否推荐","isgood",$album["IsGood"]);

  doformfooter("更新资料");

}

// ###################### Start Update #######################
if ($HTTP_POST_VARS['action']=="doupdate") {

  $nclass=$DB_site->query_first("SELECT NClassName FROM ".$table["nclass"]." WHERE NClassID=$nclassid");
  $DB_site->query("UPDATE ".$table["special"]." SET NClassName='".addslashes($nclass["NClassName"])."',
                   NClassID=$nclassid,Name='".addslashes($albumname)."',Language='".addslashes($language)."',
                   Company='".addslashes($company)."',PublishTime='".addslashes($times)."',PhotoPath='".addslashes($filename)."',
                   Intro='".addslashes(text2html($intro))."',IsGood=".$isgood."
                   WHERE SpecialID=$albumid");

  echo "<p>记录已经更新!</p>";

}

// ###################### Start Remove #######################
if ($action=="remove") {

  $musicnum=$DB_site->query_first("SELECT count(*) AS num FROM ".$table["musiclist"]." WHERE SpecialID=$albumid");

  doformheader("album","kill");
  makehiddencode("albumid",$albumid);
  makehiddencode("step",1);
  makehiddencode("musicnum",$musicnum[num]);
  maketableheader("确认删除");
  makedescription("你确认删除这张专辑吗?<BR><font color='red'>这将会同时删除 $musicnum[num] 首歌曲的信息.</font>");
  doformfooter("是","",2,"否");

}

// ###################### Start Kill #######################
if ($HTTP_POST_VARS['action']=="kill") {

  if ($step==1) {
    doformheader("album","kill");
    makehiddencode("albumid",$albumid);
    makehiddencode("step",2);
    makehiddencode("musicnum",$musicnum);
    maketableheader("确认删除 第一步");
    makedescription("<font color='red'>你确认删除这张专辑的 $musicnum 首歌曲的信息吗?<BR><B>注意：此操作完成后不可恢复数据</B></font>");
    doformfooter("是","",2,"否");
  } else if ($step==2) {
    $DB_site->query("DELETE FROM ".$table["musiclist"]." WHERE SpecialID=$albumid");
    echo "<p>歌手的 $musicnum 首歌曲删除完成!</p>";
    doformheader("album","kill");
    makehiddencode("albumid",$albumid);
    makehiddencode("step",3);
    maketableheader("确认删除 第二步");
    makedescription("<font color='red'>你确认删除这张专辑的信息吗?<BR><B>注意：此操作完成后不可恢复数据</B></font>");
    doformfooter("是","",2,"否");
  } else if ($step==3) {
    $DB_site->query("DELETE FROM ".$table["special"]." WHERE SpecialID=$albumid");
    echo "<p>专辑删除完成!</p>";
  }

}

cpfooter();
?>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -