modify_staf.php

十大精典PHP项目开发全程案例+代码

<?php
	session_start(); 
	include "../inc/chec.php";
	include "../conn/conn.php";
	$t_sqlstr = "select * from tb_users where id = ".$_GET[id];
	$t_result = mysql_query($t_sqlstr,$conn);
	$t_rows = mysql_fetch_row($t_result);
?>
<script src="../js/admin_js.js" language="javascript"></script>
<script src="../js/riq.js" language="javascript"></script>
<link href="../css/style.css" rel="stylesheet">
<table width="765" height="450" border="0" cellpadding="0" cellspacing="0" style="border: 1px solid #9CBED6; margin-top:15px;">
<tr><td align="center" valign="middle">
<form name="mod_staf" id="mod_staf" method="post" action="modify_staf_chk.php">
<table border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="100" height="25" align="right" valign="middle" scope="col"><span class="STYLE1">*</span>员工账号：</td>
    <td width="150" height="25" align="left" valign="middle" scope="col"><input name="u_user" type="text" size="10" value="<?php echo $t_rows[1]; ?>" /></td>
    <td width="100" height="25" align="right" valign="middle" scope="col"><span class="STYLE1">*</span>姓名：</td>
    <td width="300" height="25" align="left" valign="middle" scope="col"><input type="text" name="u_name" size="15" value="<?php echo $t_rows[3]; ?>" /></td>
  </tr>
  <tr>
    <td width="100" height="25" align="right" valign="middle">性别：</td>
    <td width="150" height="25" align="left" valign="middle"><select name="u_sex">
      <?php
		if($t_rows[4] == "男"){
	?>
      <option value="男" selected="selected">男</option>
      <option value="女">女</option>
      <?php
		}else{
	?>
      <option value="男">男</option>
      <option value="女" selected="selected">女</option>
      </select>
      <?php
		}
	?></td>
    <td width="100" height="25" align="right" valign="middle">出生日期：</td>
    <td width="300" align="left" valign="middle"><input type="text" name="u_birth" size="15" id="u_birth" value="<?php echo $t_rows[5]; ?>"/><input type="button" onClick="loadCalendar(mod_staf.u_birth)"></td>
  </tr>
  <tr>
    <td width="100" height="25" align="right" valign="middle"><span class="STYLE1">*</span>部门：</td>
    <td width="150" height="25" align="left" valign="middle">
	<select name="u_depart">
	<?php
		$sqlstr = "select * from tb_depart where up_depart != 0 group by up_depart";
		$result = mysql_query($sqlstr,$conn);
		$i = 0;
		while($rows = mysql_fetch_row($result)){
			$d_id[$i] = $rows[2];
			$i++;
		}
		$sqlstr1 = "select id,d_name from tb_depart where id != 0 ";
		$name = "";
		for($j = 0; $j < count($d_id); $j++){
			$sqlstr1 = $sqlstr1." and id != ".$d_id[$j];
		}
		$result1 = mysql_query($sqlstr1,$conn);
		while($rows1 = mysql_fetch_row($result1)){
			if($t_rows[9] == $rows1[0])
				echo "<option value=".$rows1[0]." selected>".$rows1[1]."</option>";
			else
				echo "<option value=".$rows1[0]." >".$rows1[1]."</option>";
		}
	?>	
	</select></td>
    <td width="100" height="25" align="right" valign="middle">员工电话：</td>
    <td width="300" height="25" align="left" valign="middle"><input type="text" name="u_tel" size="15" value="<?php echo $t_rows[7]; ?>"  /></td>
  </tr>
  <tr>
    <td width="100" height="25" align="right" valign="middle">E-mail：</td>
    <td width="150" height="25" align="left" valign="middle"><input type="text" name="u_email" size="15" value="<?php echo $t_rows[8]; ?>"></td>
    <td width="100" height="25" align="right" valign="middle">地址：</td>
    <td width="300" align="left" valign="middle"><input type="text" name="u_address" size="40" value="<?php echo $t_rows[6]; ?>" /></td>
  </tr>
  <tr>
    <td height="25" colspan="4" align="center" valign="middle">
	<input type="hidden" name="id" value="<?php echo $t_rows[0]; ?>">
	<input type="submit" value="修改" onclick="return mod_check();" /><input type="reset" value="重置" />	</td>
    </tr>
</table>
</form>
</td></tr></table>