<html><head>
<center><h4>员工调动登记<h4><center></head>
</head>
<body>
<body bgcolor="lightblue">
<form method="POST" action="removesave.php">
<table border="1" align="center">
<tr>
<td><font color="Red">*</font>员工所在部门
<select name="old_department_name">
<?php
include("share.php");
$select_sql="select * from department_info";
$result=mysql_query($select_sql);
$num=mysql_num_rows($result);
$i=0;
while ($i<$num) {
$department_name=mysql_result($result,$i,"department_name");
echo "<option>".$department_name;
$i++;
}
?>
</select>
</td>
<td><font color="Red">*</font>员工姓名
<select name="employee_name">
<?php
include("share.php");
$select_sql1="select * from employee_info";
$result1=mysql_query($select_sql1);
$num1=mysql_num_rows($result1);
$i=0;
while ($i<$num1) {
$employee_name=mysql_result($result1,$i,"employee_name");
echo "<option id='".$i."'>".$employee_name;
$i++;
}
?>
</select>
</td>
<td><font color="Red">*</font>原职位
<select name="old_major_name">
<?php
include("share.php");
$select_sql2="select * from major_info";
$result2=mysql_query($select_sql2);
$num2=mysql_num_rows($result2);
$i=0;
while ($i<$num2) {
$old_major_name=mysql_result($result2,$i,"major_name");
echo "<option id='".$i."'>".$old_major_name;
$i++;
}
?>
</select>
</td>
<td><font color="Red">*</font>新部门
<select name="new_departmentName">
<?php
include("share.php");
$select_sql3="select * from department_info";
$result3=mysql_query($select_sql3);
$num3=mysql_num_rows($result3);
$i=0;
while ($i<$num3) {
$new_departmentName=mysql_result($result3,$i,"department_name");
echo "<option id='".$i."'>".$new_departmentName;
$i++;
}
?>
</select>
</td>
<td><font color="Red">*</font>新职位
<select name="new_jobName">
<?php
include("share.php");
$select_sql4="select * from major_info";
$result4=mysql_query($select_sql4);
$num4=mysql_num_rows($result4);
$i=0;
while ($i<$num4) {
$new_jobName=mysql_result($result4,$i,"major_name");
echo "<option id='".$i."'>".$new_jobName;
$i++;
}
?>
</select>
</td>
<tr>
</table>
<center>调动原因：<center>
<textarea name="remove_cause" cols="120" rows="10"></textarea>
<p align="center">
<input type="submit" name="save" value="保存">
</p>
</form>
</body>
</html>