delete_hrms.php

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

PHP
60
字号
<?
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 ($condition_query!="")  //删除查询结果的用户档案
{
	//$query=stripslashes($condition_query);
	$query=str_replace("\'","'",$condition_query);
	//echo $query;
	//break;
	
	$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);
   	}
	
	Message("提示","信息删除成功!");
}
?>
<div align="center">
	<input type="button" value="返回" class="BigButton" onClick="location='query.php'">
</div>
</body>
</html>

⌨️ 快捷键说明

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