delete_all.php

来自「通达OA官方提供的30源代码,感觉很实在」· PHP 代码 · 共 48 行

PHP
48
字号
<?
include_once("inc/auth.php");
include_once("inc/utility_file.php");
?>

<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor" topmargin="5">
<?
if($LOGIN_USER_PRIV!="1")
   $query="select * from WORK_PLAN where CREATOR='$LOGIN_USER_ID'";
else
   $query = "select * from WORK_PLAN";   
$cursor=exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
	 $PLAN_ID.=$ROW["PLAN_ID"].",";
   $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
   $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
   if($ATTACHMENT_NAME!=""&&$ATTACHMENT_ID!="")
      delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
}

if($LOGIN_USER_PRIV!="1")
   $query="delete from WORK_PLAN where CREATOR='$LOGIN_USER_ID'";
else
   $query = "delete from WORK_PLAN";      
exequery($connection,$query);

//删除计划的进度日志和批注
$PLAN_ARRAY=explode(",",$PLAN_ID);
$PLAN_ARRAY_NUM=sizeof($PLAN_ARRAY);
for($I=0;$I<$PLAN_ARRAY_NUM;$I++)
{
   $query="delete from WORK_DETAIL where PLAN_ID='$PLAN_ARRAY[$I]'";
   exequery($connection,$query);
}

header("location: index1.php");
?>

</body>
</html>

⌨️ 快捷键说明

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