delete.php

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

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

<html>
<head>
<title>删除图书类别</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body class="bodycolor">

<?
$query = "SELECT TYPE_NAME from BOOK_TYPE where TYPE_ID=$TYPE_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
	$TYPE_NAME=$ROW["TYPE_NAME"];


$query = "SELECT * from BOOK_INFO where TYPE_ID=$TYPE_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
	Message("错误","类别“".$TYPE_NAME."”下面尚有图书,不能删除");
  Button_Back();
  exit;
}

$query="delete from BOOK_TYPE where TYPE_ID=$TYPE_ID";
exequery($connection,$query);

header("location: index.php");
?>
</body>
</html>

⌨️ 快捷键说明

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