?? delete_hrms.php
字號(hào):
<?
include_once("inc/auth.php");
include_once("inc/utility_file.php");
include_once("inc/utility_field.php");
ob_start();
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
<?
if ($USER_ID=="") //刪除部門的所有用戶檔案
{
$query="select HRMS.USER_ID from HRMS,USER where HRMS.USER_ID=USER.USER_ID and USER.DEPT_ID='$DEPT_ID'";
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
$USER_ID=$ROW["USER_ID"];
$query1="select PHOTO,ATTACHMENT_ID,ATTACHMENT_NAME from HRMS where USER_ID='$USER_ID'";
$cursor1=exequery($connection,$query1);
if($ROW1=mysql_fetch_array($cursor1))
{
$ATTACHMENT_ID=$ROW1["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW1["ATTACHMENT_NAME"];
$PHOTO=$ROW1["PHOTO"];
}
if($ATTACHMENT_NAME!="")
{
delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
}
if($PHOTO!="")
{
$FILENAME=$ATTACH_PATH."hrms_pic/$PHOTO";
if(file_exists($FILENAME))
{
unlink($FILENAME);
}
}
$query2="delete from HRMS where USER_ID='$USER_ID'";
exequery($connection,$query2);
del_field_data("HRMS",$USER_ID);
}
}
else //刪除指定用戶檔案
{
$query="select PHOTO,ATTACHMENT_ID,ATTACHMENT_NAME from HRMS where USER_ID='$USER_ID'";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
$ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];
$PHOTO=$ROW["PHOTO"];
}
if($ATTACHMENT_NAME!="")
{
delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
}
if($PHOTO!="")
{
$FILENAME=$ATTACH_PATH."hrms_pic/$PHOTO";
if(file_exists($FILENAME))
{
unlink($FILENAME);
}
}
$query="delete from HRMS where USER_ID='$USER_ID'";
exequery($connection,$query);
del_field_data("HRMS",$USER_ID);
}
if($DEPT_ID!="") //刪除全部們的用戶檔案時(shí)
{
?>
<script>
location="user_new.php?DEPT_ID=<?=$DEPT_ID?>";
</script>
<?
}
else //刪除指定用戶檔案時(shí)
{
?>
<script>
location="hrms.php?USER_ID=<?=$USER_ID?>";
</script>
<?
}
?>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -