<?php
//建立连接
$link = mysql_connect("localhost", "root", "mysql") or die("数据库连接失败:".mysql_error());//选择数据库
mysql_select_db("empdb", $link) or die("选择数据库失败:".mysql_error());mysql_query("set names gbk");if(isset($_GET['empid'])){
$sql = "select empid, empname, empdep from empinfo where empid = ".$_GET['empid'];
$result = mysql_query($sql, $link);
$row = mysql_fetch_array($result);
$empid =$_GET['empid'];
$empname = $row['empname'];
$empdep = $row['empdep'];
}
?> <form action='#' method='GET' name = myform onsubmit="save()">
<input type='hidden' name = 'type' value ="select">
职员编号:<input type='text' name = 'empid' readonly value = <?php echo $empid; ?>><br>
职员姓名:<input type='text' name = 'empname' value = <?php echo $empname; ?>><br>
薪水:<input type='text' name = 'wage'><br>
部门:<select name = 'empdep' >
<?php
$depttsql = "select empdep from empinfo group by empdep";
$deptresult = mysql_query($depttsql, $link);
while($row = mysql_fetch_assoc($deptresult)){
if($empdep == $row['empdep']){
echo "<option value = $row[empdep] selected>$row[empdep]</option>";
}
}
?>
</select><br>
<input type='submit' value = '修改'><input type='reset' value = '重置'>
</form>
//建立连接
$link = mysql_connect("localhost", "root", "mysql") or die("数据库连接失败:".mysql_error());//选择数据库
mysql_select_db("empdb", $link) or die("选择数据库失败:".mysql_error());mysql_query("set names gbk");if(isset($_GET['empid'])){
$sql = "select empid, empname, empdep from empinfo where empid = ".$_GET['empid'];
$result = mysql_query($sql, $link);
$row = mysql_fetch_array($result);
$empid =$_GET['empid'];
$empname = $row['empname'];
$empdep = $row['empdep'];
}
?> <form action='#' method='GET' name = myform onsubmit="save()">
<input type='hidden' name = 'type' value ="select">
职员编号:<input type='text' name = 'empid' readonly value = <?php echo $empid; ?>><br>
职员姓名:<input type='text' name = 'empname' value = <?php echo $empname; ?>><br>
薪水:<input type='text' name = 'wage'><br>
部门:<select name = 'empdep' >
<?php
$depttsql = "select empdep from empinfo group by empdep";
$deptresult = mysql_query($depttsql, $link);
while($row = mysql_fetch_assoc($deptresult)){
if($empdep == $row['empdep']){
echo "<option value = $row[empdep] selected>$row[empdep]</option>";
}
}
?>
</select><br>
<input type='submit' value = '修改'><input type='reset' value = '重置'>
</form>
<?php
//建立连接
$link = mysql_connect("localhost", "root", "mysql") or die("数据库连接失败:".mysql_error());//选择数据库
mysql_select_db("empdb", $link) or die("选择数据库失败:".mysql_error());mysql_query("set names gbk");if(isset($_GET['empid'])){
//当empid在数据库中不存在时插入
$sql = "insert into empinfo(empid, empname, empdep) select {$_GET['empid']}, {$_GET['empname']}, {$_GET['empdep']} from empinfo where not exist (select * from empinof where empid = {$_GET['empid']}) ";
$result = mysql_query($sql, $link);
//重新查询
$sql = "select empid, empname, empdep from empinfo where empid = ".$_GET['empid'];
$result = mysql_query($sql, $link);
$row = mysql_fetch_array($result);
$empid =$_GET['empid'];
$empname = $row['empname'];
$empdep = $row['empdep'];
}
?><form action='#' method='GET' name=myform onsubmit="save()">
<input type='hidden' name='type' value="select">
职员编号:<input type='text' name='empid' readonly value=<?php echo $empid; ?>><br>
职员姓名:<input type='text' name='empname' value=<?php echo $empname; ?>><br>
薪水:<input type='text' name='wage'><br>
部门:<select name='empdep'>
<?php
$depttsql = "select empdep from empinfo group by empdep";
$deptresult = mysql_query($depttsql, $link);
while($row = mysql_fetch_assoc($deptresult)){
if($empdep == $row['empdep']){
echo "<option value = $row[empdep] selected>$row[empdep]</option>";
}
}
?>
</select><br><input type='submit' value='修改'><input type='reset' value='重置'></form>
<?php
//建立连接
$link = mysql_connect("localhost", "root", "mysql") or die("数据库连接失败:".mysql_error());//选择数据库
mysql_select_db("empdb", $link) or die("选择数据库失败:".mysql_error());mysql_query("set names gbk");if(isset($_GET['empid'])){
$sql = "select empid, empname, empdep from empinfo where empid = ".$_GET['empid'];
$result = mysql_query($sql, $link);
$row = mysql_fetch_array($result);
$empid =$_GET['empid'];
$empname = $row['empname'];
$empdep = $row['empdep'];
}
?><form action='#' method='GET' name=myform onsubmit="save()"><input
type='hidden' name='type' value="select"> 职员编号:<input type='text'
name='empid' readonly value=<?php echo $empid; ?>><br>
职员姓名:<input type='text' name='empname' value=<?php echo $empname; ?>><br>
薪水:<input type='text' name='wage'><br>
部门:<select name='empdep'>
<?php
$depttsql = "select empdep from empinfo group by empdep";
$deptresult = mysql_query($depttsql, $link);
while($row = mysql_fetch_assoc($deptresult)){
if($empdep == $row['empdep']){
echo "<option value = $row[empdep] selected>$row[empdep]</option>";
}
}
?>
</select><br><input type='submit' value='修改'><input type='reset' value='重置'></form>
把save()函數貼出來看看
if(isset($_GET['empid'])){
//修改这个SQL语句就行了
$sql = "update empinfo set wage = {$_GET['wage']} where empid={$_GET['empid']}";
$result = mysql_query($sql, $link);
//重新查询
$sql = "select empid, empname, empdep from empinfo where empid = ".$_GET['empid'];
$result = mysql_query($sql, $link);
$row = mysql_fetch_array($result);
$empid =$_GET['empid'];
$empname = $row['empname'];
$empdep = $row['empdep'];
}
<?php
//建立连接
$link = mysql_connect("localhost", "root", "mysql") or die("数据库连接失败:".mysql_error());//选择数据库
mysql_select_db("empdb", $link) or die("选择数据库失败:".mysql_error());mysql_query("set names gbk");if(isset($_GET['empid'])){
if($_GET['type']=='edit'){
$sql = "update empinfo set wage = '{$_GET['wage']}' where empid='{$_GET['empid']}'";
mysql_query($sql, $link);
}
$sql = "select empid, empname, empdep,wage from empinfo where empid = '{$_GET['empid']}'";
$result = mysql_query($sql, $link);
$row = mysql_fetch_array($result);
$empid =$_GET['empid'];
$empname = $row['empname'];
$empdep = $row['empdep'];
$wage = $row['wage'];
}
?> <form action='' method='GET' name = myform onsubmit="save()">
<input type='hidden' name = 'type' value ="edit">
职员编号:<input type='text' name = 'empid' readonly value = <?php echo $empid; ?>><br>
职员姓名:<input type='text' name = 'empname' value = <?php echo $empname; ?>><br>
薪水:<input type='text' name = 'wage' value = '<?php echo $wage; ?>'><br>
部门:<select name = 'empdep' >
<?php
$depttsql = "select empdep from empinfo group by empdep";
$deptresult = mysql_query($depttsql, $link);
while($row = mysql_fetch_assoc($deptresult)){
if($empdep == $row['empdep']){
echo "<option value = $row[empdep] selected>$row[empdep]</option>";
}
}
?>
</select><br> <input type='submit' value = '修改'><input type='reset' value = '重置'>
</form>