本文主要和大家分享PHP如何更新数据库的数据的方法。希望能帮助到大家。
第一步创建更新页面文件Upwork.php
删除修改数据
<?php$code = $_GET["code"];
$db = new MySQLi("localhost","root","123456","study");
!mysqli_connect_error() or die("连接失败!");
$sql1 = "select * from `员工信息` where 工号='{$code}'";
$r1 = $db->query($sql1);
$att1 = $r1->fetch_row();
?>
员工工号:
员工姓名:
出生日期:
员工年龄:
员工职称:
所在部门:
员工月薪:
员工年薪:
政治面貌:
健康状况:
第二步创建更新数据操作的文件UpworkChuLi.php,在Upwork.php中通过表单跳转<?php
$code = $_POST["code"];
$name = $_POST["name"];
$date = $_POST["date"];
$age = $_POST["age"];
$job = $_POST["job"];
$department = $_POST["department"];
$month = $_POST["month"];
$year = $_POST["year"];
$politics = $_POST["politics"];
$health = $_POST["health"];
$db = new MySQLi("localhost","root","123456","study");
!mysqli_connect_error() or die("连接失败!");
$sql = "update `员工信息` set 姓名='{$name}',出生日期='{$date}',年龄='{$age}',职称='{$job}',
所在部门='{$department}',月薪='{$month}',年薪='{$year}',政治面貌='{$politics}',健康状况='{$health}'
where 工号='{$code}'";
$r = $db->query($sql);
if($r)
{
header("location:work.php");
}
else
{
echo "修改失败!";
}
?>
相关推荐: