singer.php

1、上传所有文件至服务器目录。 2、使用 MYSQL 管理工具

<?php
error_reporting(7);

require("./global.php");

unset($query);

cpheader();

if ($getperms[canadminmusicsinger]!=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]."  ","singer.php?s=$session[sessionhash]&action=add&sclassid=$class[SClassID]&sclassname=".urlencode($class[SClassName]).""));
    }
    dotablefooter();

  } else {
    doformheader("singer","insert");
    maketableheader("添加新歌手");
    makehiddencode("sclassid",$sclassid);

    makelabelcode("类别名",$sclassname);

    makeinputcode("歌手姓名","singername");
    makeinputcode("字母索引","namecode");

    doformfooter("添加");
  }

}

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

  $DB_site->query("INSERT INTO ".$table["nclass"]." (NClassID,NClassName,ClassID,SClassID,NameCode) VALUES 
                                                    (NULL,'".addslashes($singername)."',1,$sclassid,'".strtoupper(addslashes($namecode))."')");

  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]."  ","singer.php?s=$session[sessionhash]&action=modify&sclassid=$class[SClassID]"));
    }
    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=\"singer.php?s=$session[sessionhash]&action=modify&sclassid=$sclassid&namecode=".$namecode[NameCode]."\"><B>$namecode[NameCode]</B></a> ";
    }
    makedescription($strnamecode);
    dotablefooter();

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

    $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("<table width='90%' border='0' align='center'><tr valign='top'><td>
      <li>".makelinkcode(" $class[NClassName] ","singer.php?s=$session[sessionhash]&action=edit&nclassid=$class[NClassID]&sclassid=$sclassid")."</li>
      </td><td align='right' width='60'>
      <li>".makelinkcode("编辑","singer.php?s=$session[sessionhash]&action=edit&nclassid=$class[NClassID]&sclassid=$sclassid")."</li>
      </td><td align='right' width='60'>
      <li>".makelinkcode("删除","singer.php?s=$session[sessionhash]&action=remove&nclassid=$class[NClassID]")."</li>
      </td></tr></table>");
    }
    dotablefooter();
  }

}

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

  $class=$DB_site->query_first("SELECT * FROM ".$table["nclass"]." WHERE NClassID=$nclassid");

  doformheader("singer","doupdate");
  maketableheader("编辑歌手资料");
  makehiddencode("nclassid",$nclassid);

  makesclasschoosercode("歌手所属类别","sclassid",$table["sclass"],$sclassid);
  makeinputcode("歌手姓名","singername",$class[NClassName]);
  makeinputcode("字母索引","namecode",$class[NameCode]);

  doformfooter("保存");

}

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

  $sclass=$DB_site->query_first("SELECT SClassName AS Name FROM ".$table["sclass"]." WHERE SClassID=$sclassid");
  $ok1=$DB_site->query("UPDATE ".$table["nclass"]." SET NClassName='".addslashes($singername)."',
                   NameCode='".strtoupper(addslashes($namecode))."',SClassID=$sclassid 
                   WHERE NClassID=$nclassid");
  $ok2=$DB_site->query("UPDATE ".$table["special"]." SET NClassName='".addslashes($singername)."',
                   SClassID=$sclassid,SClassName='".addslashes($sclass["Name"])."'
                   WHERE NClassID=$nclassid");
  $ok3=$DB_site->query("UPDATE ".$table["musiclist"]." SET Singer='".addslashes($singername)."',
                   SClassID=$sclassid WHERE NClassID=$nclassid");
  if ($ok1) {
    echo "歌手资料表修改完成!<BR>";
  }
  if ($ok2) {
    echo "专辑资料表中的歌手信息修改完成!<BR>";
  }
  if ($ok3) {
    echo "歌曲资料表中的歌手信息修改完成!<BR>";
  }

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

}

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

  $musicnum=$DB_site->query_first("SELECT count(*) AS num FROM ".$table["musiclist"]." WHERE NClassID=$nclassid");
  $albumnum=$DB_site->query_first("SELECT count(*) AS num FROM ".$table["special"]." WHERE NClassID=$nclassid");

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

}

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

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

}

cpfooter();
?>