📄 modefiyworker.php

📁 酒店管理系统
💻 PHP
字号:
<?
require_once('../include/connectionadmin.php'); 
include('../include/admin_or_user.php');
require_once('../include/sqlfuns.php');
?>
<?
if(isset($_POST['total'])&&$_POST['total']!="")
 { $i=$_POST['total'];  
  $selected=0;
for($j=1;$j<=$i;$j++)
 if(isset($_POST["checkbox".$j]))
   $selected=1;
 if(!$selected)
 { ?>
 <script>
 alert("请选择!");
 window.history.back();

 </script>
 
<?
 exit;
   }
  }
if(isset($_POST['s'])&&$_POST['s']=="修改")
{ 
if(isset($_POST['i'])&&$_POST['i']!="")
  $i=$_POST['i'];
for($j=1;$j<=$i;$j++)
 {
   if(isset($_POST['name'.$j])&&!empty($_POST['name'.$j]))
    {
 $updatesql=sprintf("update worker set name=%s,age=%s,sex=%s,payment=%s,address=%s,phone=%s,hiredate=%s,howlong=%s,deptno=%s where id=%s",
 GetSQLValueString($_POST['name'.$j],'text'),
 GetSQLValueString($_POST['age'.$j],'int'),
 GetSQLValueString($_POST['sex'.$j],'text'),
 GetSQLValueString($_POST['payment'.$j],'int'),
 GetSQLValueString($_POST['address'.$j],'text'),
 GetSQLValueString($_POST['phone'.$j],'text'),
 GetSQLValueString($_POST['hiredate'.$j],'text'),
 GetSQLValueString($_POST['howlong'.$j],'text'),
 GetSQLValueString($_POST['deptno'.$j],'text'),
 GetSQLValueString($_POST['id'.$j],'int'));
odbc_exec($conn,$updatesql);
     }
  }
 odbc_close($conn);
 $goto="worker.php";
 header("Location: ".$goto);
 exit;
  }
 
if(isset($_POST['delete']))
{ 
 for($j=1;$j<=$i;$j++)
  {
if(isset($_POST['checkbox'.$j])&&!empty($_POST['checkbox'.$j]))
 {
$detelesql=sprintf("delete from worker where id=%s",
 GetSQLValueString($_POST['checkbox'.$j],'int'));
odbc_exec($conn,$detelesql);
  }
 
   }
 odbc_close($conn);
 $goto="worker.php";
 header("Location: ".$goto);
 exit;
 } 
 

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<link href="../css/hotel.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
body {
	margin-left: 36px;
	margin-right: 36px;
}
-->
</style></head>

<body>
<form method="post" name="form" id="form" >
<table width="100%" border="1">
  <tr>
   
    <td width="5%"><div align="center">编号</div></td>
    <td width="8%"><div align="center">姓名</div></td>
    <td width="5%"><div align="center">姓别</div></td>
    <td width="5%"><div align="center">年龄</div></td>
    <td width="10%"><div align="center">电话</div></td>
    <td width="38%"><div align="center">地址</div></td>
    <td width="5%"><div align="center">工资</div></td>
	<td width="5%"><div align="center">部门</div></td>
	<td width="11%"><div align="center">雇用日期</div></td>
	<td width="8%"><div align="center">雇用期限</div></td>
   
  </tr>
 <?
for($j=1;$j<=$i;$j++)
 if(isset($_POST["checkbox".$j])&&$_POST["checkbox".$j]!="")
 { 
  $id=$_POST['checkbox'.$j];
  
   $selectsql="select * from worker left join dept on worker.deptno=dept.deptno where id =".$id;
   $result=odbc_exec($conn,$selectsql);
  ?>
  <tr>
  
    <td><div align="center"><? echo $j;?></div></td>
    <td><input name="name<? echo $j;?>" type="text" id="name<? echo $j;?>" size="10" maxlength="30" value="<? echo odbc_result($result,'name');?>"></td>
    <td><div align="center">
      <input name="sex<? echo $j;?>" type="text" id="sex<? echo $j;?>" size="2" maxlength="6" value="<? echo odbc_result($result,'sex');?>">
    </div></td>
    <td><div align="center">
      <input name="age<? echo $j;?>" type="text" id="age<? echo $j;?>" size="2" maxlength="6" value="<? echo odbc_result($result,'age');?>">
    </div></td>
    <td><input name="phone<? echo $j;?>" type="text" id="phone<? echo $j;?>" size="10" maxlength="20" value="<? echo odbc_result($result,'phone');?>"></td>
    <td><input name="address<? echo $j;?>" type="text" id="address<? echo $j;?>" size="47" maxlength="49" value="<? echo odbc_result($result,'address');?>"></td>
    <td><input name="payment<? echo $j;?>" type="text" id="payment<? echo $j;?>" size="6" maxlength="10" value="<? echo odbc_result($result,'payment');?>"></td>
	<td><label>
	  <select name="deptno<? echo $j;?>" id="deptno<? echo $j;?>">
	  <? $selectdeptno="select * from dept order by deptno";
	      $deptno= odbc_exec($conn,$selectdeptno);
		  while(odbc_fetch_row($deptno))
		  {
		  ?>
		  <option value="<? echo odbc_result($deptno,'deptno');?> " <? if(odbc_result($deptno,'deptno')==odbc_result($result,'deptno')){?>selected="selected"<? }?> ><? echo odbc_result($deptno,'deptname');?></option>
		  <? }?>
	   
	    </select>
	</label></td>
	<td><input name="hiredate<? echo $j;?>" type="text" id="hiredate<? echo $j;?>" size="13" maxlength="10" value="<? echo odbc_result($result,'hiredate');?>"></td>
	<td><input name="howlong<? echo $j;?>" type="text" id="howlong<? echo $j;?>" size="7" maxlength="10" value="<? echo odbc_result($result,'howlong');?>"></td>
    <input name="id<? echo $j;?>" type="hidden" value="<? echo $id;?>" />
  </tr>
  <? 
  } ?>
</table>

  
<table width="198" border="0">
<tr>
<td width="50">
操作:</td>
<td width="138"><label>
  <input name="s" type="submit" id="s" value="修改" />
 &nbsp;</label></td>
    
  </tr>
</table>
<input name="i" type="hidden" id="i" value="<? echo $_POST['total'];?>" />
</p>

</form>
<p align="center"><a href="worker.php">返回</a></p>
<p \>
 <script src="../copyright.inc">
</script>
</body>
</html>
<? odbc_close($conn); ?>
⌨️ 快捷键说明

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