📄 music.php

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

require("./global.php");

unset($query);

cpheader();

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

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]."  ","music.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=\"music.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>&nbsp;&nbsp;<a href=\"music.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='100' align='right'><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>
                       </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("<div align=\"center\">
                         <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">
                         <tr>
                           <td>&nbsp;&nbsp;<a href=\"music.php?s=$session[sessionhash]&action=add&sclassid=$sclassid&nclassid=$nclassid&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumid=".$album[SpecialID]."&albumname=".urlencode($album[Name])."&namecode=$namecode\">$album[Name]</a></td>
                         </tr>
                         </table>
                         </div>");
    }
    dotablefooter();

  } else {
    doformheader("music","insert");
    maketableheader("添加新歌曲");
    makehiddencode("sclassid",$sclassid);
    makehiddencode("nclassid",$nclassid);
    makehiddencode("singer",$nclassname);
    makehiddencode("albumid",$albumid);

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

    makeinputcode("歌曲名称","musicname");
    makeinputcode("歌曲文件路径","filename");
    makeyesnocode("是否推荐","isgood",0);

    doformfooter("保存");
  }

}

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

  $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>记录已经添加</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]."  ","music.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=\"music.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=\"music.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=\"music.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] ","music.php?s=$session[sessionhash]&action=modify&sclassid=$sclassid&nclassid=$nclassid&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumid=".$album[SpecialID]."&albumname=".urlencode($album[Name])."&namecode=$namecode")."</li>
        </td><td align='right' width='90'>
        <li>".makelinkcode("选择歌曲","music.php?s=$session[sessionhash]&action=modify&sclassid=$sclassid&nclassid=$nclassid&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumid=".$album[SpecialID]."&albumname=".urlencode($album[Name])."&namecode=$namecode")."</li>
        </td><td align='right' width='90'>
        <li>".makelinkcode("添加歌曲","music.php?s=$session[sessionhash]&action=add&sclassid=$sclassid&nclassid=$nclassid&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumid=".$album[SpecialID]."&albumname=".urlencode($album[Name])."&namecode=$namecode")."</li>
        </td></tr></table>");
    }
    dotablefooter();

  } else if ($musicid=="") {
    echo "<p>修改歌曲信息 请选择歌曲:</p>";

    $musics=$DB_site->query("SELECT * FROM ".$table["musiclist"]." WHERE SpecialID=".$albumid." ORDER BY ID");

    doformheader("","");
    maketableheader("专辑歌曲列表");
    while ($music=$DB_site->fetch_array($musics)) {
        makedescription("<table width='90%' border='0' align='center'><tr valign='top'><td>
        <li>".makelinkcode(" $music[MusicName] ","music.php?s=$session[sessionhash]&action=edit&musicid=".$music[ID]."&musicname=".urlencode($music[MusicName])."&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumname=".urlencode($albumname))."</li>
        </td><td align='right' width='90'>
        <li>".makelinkcode("编辑歌曲","music.php?s=$session[sessionhash]&action=edit&musicid=".$music[ID]."&musicname=".urlencode($music[MusicName])."&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumname=".urlencode($albumname))."</li>
        </td><td align='right' width='90'>
        <li>".makelinkcode("删除歌曲","music.php?s=$session[sessionhash]&action=remove&musicid=".$music[ID]."&musicname=".urlencode($music[MusicName])."&nclassname=".urlencode($nclassname)."&sclassname=".urlencode($sclassname)."&albumname=".urlencode($albumname))."</li>
        </td></tr></table>");
    }
    dotablefooter();
  }

}

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

  $music=$DB_site->query_first("SELECT * FROM ".$table["musiclist"]." WHERE ID=$musicid");

  doformheader("music","doupdate");
  maketableheader("编辑歌曲信息");
  makehiddencode("musicid",$musicid);

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

  makeinputcode("歌曲名称","musicname",$music[MusicName]);
  makeinputcode("歌曲文件路径","filename",$music[FileName]);
  makeyesnocode("是否推荐","isgood",$music[IsGood]);

  doformfooter("更新资料");

}

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

  $DB_site->query("UPDATE ".$table["musiclist"]." SET MusicName='".addslashes($musicname)."',
                   FileName='".addslashes($filename)."',IsGood=".$isgood."
                   WHERE ID=$musicid");

  echo "歌曲名：<font color='red'>".$musicname."</font><BR><p>记录已经更新!</p>";

}

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

  doformheader("music","kill");
  makehiddencode("musicid",$musicid);
  makehiddencode("musicname",$musicname);
  maketableheader("确认删除");
  makedescription("你确认删除这首歌曲吗? 信息如下: <BR>
                   类别:<font color='red'>$sclassname</font><BR>
                   歌手:<font color='red'>$nclassname</font><BR>
                   专辑:<font color='red'>$albumname</font><BR>
                   歌曲名字:<font color='red'>$musicname</font><BR>");
  doformfooter("是","",2,"否");

}

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

  $DB_site->query("DELETE FROM ".$table["musiclist"]." WHERE ID=$musicid");
  echo "<p>歌曲 [ ".$musicname." ] 删除完成!</p>";

}

cpfooter();
?>
⌨️ 快捷键说明

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