tes_$res = soft::groups($option["key"],$option["value"-优快云博客

<?
/*员工信息录入界面
--
--
*/
?>
<?
//加入数据库
include( 'include/database_conn.php' );
if(!empty($_POST["Sname"]) && !empty($_POST["department"]) && !empty($_POST["salary"]) && !empty($_POST["Sphone"]) && !empty($_POST["sex"]) && !empty($_POST["psw"]) && !empty($_POST["Saddress"]) && !empty($_POST["clerk"])){
	if($_POST["act"]=="edit"){
		//修改UPDATE 
		$sql="UPDATE  employees SET department ='".$_POST["department"]."', salary  = '".$_POST["salary"]."' ,Sphone = '".$_POST["Sphone"]."',sex = '".$_POST["sex"]."',psw= '".$_POST["psw"]."', Saddress  = '".$_POST["Saddress"]."', clerk  = '".$_POST["clerk"]."' WHERE  Sname = '".$_POST["Sname"]."'";
		echo mysql_query($sql)?"执行成功":"失败";
	}else{
        //增加
        $sql="INSERT INTO employees VALUES ('".$_POST["Sname"]."', '".$_POST["department"]."', '".$_POST["salary"]."','".$_POST["Sphone"]."','".$_POST["sex"]."', '".$_POST["psw"]."', '".$_POST["Saddress"]."', '".$_POST["clerk"]."')";
        echo mysql_query($sql)?"执行成功":"执行失败";
    }
    echo "<meta http-equiv='refresh' content='1;url=base_query_employees.php'>";
	exit();
}else{
	//echo !empty($_POST["Sname"]) && !empty($_POST["department"]) && !empty($_POST["salary"]) && !empty($_POST["Sphone"]) && !empty($_POST["sex"]) && !empty($_POST["psw"]) && !empty($_POST["Saddress"]) && !empty($_POST["clerk"];
}
?>


<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
    <title><?echo isset($_REQUEST["Sname"])?"员工信息维护":"员工信息录入";?></title>
    <link rel="stylesheet" type="text/css" href="body.css" />
</head>
<body>
<div>
<?echo "".isset($_REQUEST["Sname"])?"<span>员工信息维护</span>":"<span>员工信息录入</span>".""?>
<form action="base_employees.php" method="post">
<?
if(isset($_REQUEST["Sname"])){
	echo "<p>员工名称:  <input type='text' value='".$_REQUEST['Sname']."' disabled='true' /></p>";
	echo "<input type='Hidden' name='Sname' value='".$_REQUEST['Sname']."' />";
	echo "<input type='Hidden' name='act' value='edit' />";
	$sql="SELECT * FROM `employees` where Sname='".$_REQUEST["Sname"]."'";
	$Sname_data=mysql_fetch_array(mysql_query($sql));
}else{
	echo "<p>员工名称:<input type='text' name='Sname'/></p>";
}
?>
  <p>部门:  <select name="department">
			<option value="1" checked="<?=$Sname_data[1]==1?"checked":"";?>">1</option>
			<option value="2" checked="<?=$Sname_data[1]==2?"checked":"";?>">2</option>
			<option value="3" checked="<?=$Sname_data[1]==3?"checked":"";?>">3</option>
			<option value="4" checked="<?=$Sname_data[1]==4?"checked":"";?>">4</option>
			</select>
  </p>
  <p>工资: 	  <input type="text" name="salary"	 value="<?=$Sname_data[2]?>" /></p>
  <p>手机号码: 	  <input type="text" name="Sphone"	 value="<?=$Sname_data[3]?>" /></p>
  <p>性别: 	  
	  <input type="radio" name="sex" value="男" <?=$Sname_data[4]=="男"?"checked":"";?>/><label>男</label>
	  <input type="radio" name="sex" value="女" <?=$Sname_data[4]=="女"?"checked":"";?>/><label>女</label>
  </p>
  <p>密码:		  <input type="text" name="psw" 	 value="<?=$Sname_data[5]?>" /></p>
  <p>地址:		  <input type="text" name="Saddress"  value="<?=$Sname_data[6]?>" /></p>
  <p>职位:		  <input type="text" name="clerk"    value="<?=$Sname_data[7]?>" /></p>
    <input type="submit" value="<?echo isset($_REQUEST["Sname"])?"修改":"添加";?>" />
  <input type="reset"  value="重置" />
</form>
</div>
</body>
</html>

<?
/*
员工信息查询界面
*/
?>
<?
//加入数据库
include( 'include/database_conn.php' );
echo "<div>";
if(!empty($_GET["Sname"])){
	$sql="DELETE FROM `employees` WHERE Sname ='". $_GET["Sname"]."'";
    echo mysql_query($sql)?"删除成功":"删除失败";
}
$sql="SELECT  * FROM `employees`";
$SQLdata=mysql_query($sql);
if(!mysql_num_rows($SQLdata)){echo "<span>没有查询到数据</span></div><link rel='stylesheet' type='text/css' href='body.css' />";exit();}
//$LineCount=mysql_num_rows($SQLdata);
echo "<span>员工信息查询</span><table border='1' cellpadding='0' cellspacing='0'><tr>";
$SQLLdata=mysql_fetch_array($SQLdata,MYSQL_ASSOC);
foreach($SQLLdata as $key => $value){
echo "<th>".o($key)."</th>";
}
echo "<th>操作</th></tr>";

do{
    echo "<tr>";
    foreach($SQLLdata as  $value){
    echo "<td>".$value."</td>";
    }
    echo "<td><a href='base_employees.php?Sname=".$SQLLdata['Sname']."'>修改</a>/<a href='?Sname=".$SQLLdata['Sname']."'>删除</a></td></tr>";
}while($SQLLdata=mysql_fetch_array($SQLdata,MYSQL_ASSOC))
?>
</div>
<link rel="stylesheet" type="text/css" href="body.css" />