📄 worker.php
字号:
<?
require_once('../include/connectionadmin.php');
include('../include/admin_or_user.php');
?>
<?
$selectsql="select * from worker left join dept on worker.deptno=dept.deptno order by worker.deptno";
$result=odbc_exec($conn,$selectsql);
?>
<!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 action="modefiyworker.php" method="post" name="form" id="form" >
<table width="100%" border="1" cellspacing="0">
<tr>
<td width="4%"><div align="center">选择</div></td>
<td width="5%"><div align="center">编号</div></td>
<td width="8%"><div align="center">姓名</div></td>
<td width="6%"><div align="center">姓别</div></td>
<td width="5%"><div align="center">年龄</div></td>
<td width="11%"><div align="center">电话</div></td>
<td width="29%"><div align="center">地址</div></td>
<td width="3%"><div align="center">工资</div></td>
<td width="8%"><div align="center">部门</div></td>
<td width="14%"><div align="center">雇用日期</div></td>
<td width="7%"><div align="center">雇用期限</div></td>
</tr>
<? $i=1;
while(odbc_fetch_row($result))
{?>
<tr>
<td> <div align="center">
<input type="checkbox" name="checkbox<? echo $i;?>" value="<? echo odbc_result($result,'id');?>" />
</div></td>
<td><div align="center"><? echo $i;?></div></td>
<td><div align="center"><? echo odbc_result($result,'name');?> </div></td>
<td><div align="center"><? echo odbc_result($result,'sex');?> </div></td>
<td><div align="center"><? echo odbc_result($result,'age');?> 岁</div></td>
<td><div align="center"><? echo odbc_result($result,'phone');?> </div></td>
<td><? echo odbc_result($result,'address');?></td>
<td><div align="center"><span class="redclore">￥</span><? echo odbc_result($result,'payment');?>
</div></td>
<td><div align="center"><? echo odbc_result($result,'deptname');?> </div></td>
<td><div align="center"><? echo odbc_result($result,'hiredate');?> </div></td>
<td><div align="center"><? echo odbc_result($result,'howlong');?> </div></td>
</tr>
<? $i++;
} ?>
</table>
<p>
<input name="total" type="hidden" id="totalselect" value="<? echo $i;?>" />
<table width="337" border="0">
<tr>
<td width="70">
操作:</td>
<td width="257"><label>
<input name="modefiy" type="submit" id="modefiy" value="编辑" />
<input name="delete" type="submit" id="delete" value="删除" />
<input name="addworker" type="button" id="addworker" value="增加员工" onClick="location=('addworker.php')" />
</label></td>
</tr>
</table></p>
</form>
<p \>
<script src="../copyright.inc">
</script>
</body>
</html>
<? odbc_close($conn);?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -