bbsdel.php

这是使用ＰＨＰ编程的虚拟社区ＭySQL的简易版

<?
  include "config.inc.php";
  include "func.php";

function DeleteData() {
  global $BBS_TABLE;
  global $mainid;

  $SQL="DELETE FROM $BBS_TABLE WHERE mainid='$mainid'";

  mysql_query($SQL) or die(mysql_error());
}


function DeleteSubData() {
  global $BBS_TABLE;
  global $bbsid,$mainid,$sub_value;

  $SQL="DELETE FROM $BBS_TABLE WHERE bbsid='$bbsid'";

  mysql_query($SQL) or die(mysql_error());
}


function UpdateSubvalue() {
  global $BBS_TABLE;
  global $bbsid,$mainid;

  $SQL="SELECT sub_value FROM $BBS_TABLE WHERE bbsid='$mainid'";

  $result=mysql_query($SQL) or die(mysql_error());

  $row=mysql_fetch_Array($result);

  $sub_value=$row[sub_value];
  $sub_value--;

  $SQL="UPDATE $BBS_TABLE SET sub_value='$sub_value' WHERE bbsid='$mainid'";

  mysql_query($SQL) or die(mysql_error());
}

  ReadUserid();
  CheckDemo();

if ($bbsid==$mainid) {
  DeleteData();
  header("Location: bbslist.php?id=$id&blockid=$blockid\n");
} else {
  DeleteSubData();
  UpdateSubvalue();
  header("Location: bbsread.php?id=$id&blockid=$blockid&mainid=$mainid\n");
}
exit;

?>