delete.php

来自「极限网络智能办公系统 Office Automation V3.0官方100%源」· PHP 代码 · 共 37 行

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

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

<body class="bodycolor">

<?
$connection=OpenConnection();
$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 + -
显示快捷键?