📄 delete.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码

💻 PHP

字号:

<?php
 

include_once( "inc/auth.php" );
echo "\r\n<html>\r\n<head>\r\n<title>删除图书</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\">\r\n\r\n";
$connection = openconnection( );
$query = "SELECT BOOK_NO from BOOK_INFO  where BOOK_ID='".$BOOK_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$BOOK_NO = $ROW['BOOK_NO'];
}
$query = "SELECT count(*) from BOOK_MANAGE where BOOK_NO='".$BOOK_NO."' and BOOK_STATUS='0'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
	$LEND_COUNT = $ROW[0];
}
if ( 0 < $LEND_COUNT )
{
	message( "提示", "该图书已经借出，请归还后再删除" );
	echo "<br>\r\n<div align=\"center\">\r\n   <input type=\"button\" value=\"返回\" class=\"BigButton\" onClick=\"location='list.php?TYPE_ID=";
	echo $TYPE_ID;
	echo "&BOOK_NAME=";
	echo $BOOK_NAME;
	echo "&AUTHOR=";
	echo $AUTHOR;
	echo "&ISBN=";
	echo $ISBN;
	echo "&PUB_HOUSE=";
	echo $PUB_HOUSE;
	echo "&AREA=";
	echo $AREA;
	echo "&DEPT_ID=";
	echo $DEPT_ID;
	echo "&ORDER_FIELD=";
	echo $ORDER_FIELD;
	echo "&PAGE_START=";
	echo $PAGE_START;
	echo "'\">\r\n</div>\r\n";
	exit( );
}
$query = "delete from BOOK_INFO where BOOK_ID='".$BOOK_ID."'";
exequery( $connection, $query );
$query = "delete from BOOK_MANAGE where BOOK_NO='".$BOOK_NO."'";
exequery( $connection, $query );
header( "location: list.php?TYPE_ID=".$TYPE_ID."&BOOK_NAME={$BOOK_NAME}&AUTHOR={$AUTHOR}&ISBN={$ISBN}&PUB_HOUSE={$PUB_HOUSE}&AREA={$AREA}&DEPT_ID={$DEPT_ID}&ORDER_FIELD={$ORDER_FIELD}&PAGE_START={$PAGE_START}" );
echo "\r\n</body>\r\n</html>\r\n";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -