delete.php

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

<?
include_once("inc/auth.php");
include_once("inc/utility_file.php");

$query = "SELECT ATTACHMENT_ID,ATTACHMENT_NAME from BOOK_INFO where BOOK_ID=$BOOK_ID";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
   $ATTACHMENT_ID=$ROW["ATTACHMENT_ID"];
   $ATTACHMENT_NAME=$ROW["ATTACHMENT_NAME"];

   if($ATTACHMENT_NAME!="")
      delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
}

$query="delete from BOOK_INFO where BOOK_ID='$BOOK_ID'";
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");
?>