session_start();
// 判断有没有登录
if(!isset($_SESSION['admin'])){
header("location:admin.php");
exit;
}
$dbhost = 'localhost';
$dbuser = 'myxjd';
$dbpass = 'fsx521lgz';
$dbname = 'myxjd';
$conn = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
if(!$conn){
die("数据库连接失败：".mysqli_connect_error());
}
// 新增质保记录
if(isset($_POST['add'])){
$name = trim($_POST['name']);
$phone = trim($_POST['phone']);
$goods = trim($_POST['goods']);
$time = trim($_POST['time']);
$remark = trim($_POST['remark']);
$sql = "INSERT INTO warranty(name,phone,goods,warranty_time,remark) VALUES ('$name','$phone','$goods','$time','$remark')";
mysqli_query($conn,$sql);
header('location:index.php');
}
// 删除记录
if(isset($_GET['del'])){
$id = intval($_GET['del']);
mysqli_query($conn,"DELETE FROM warranty WHERE id=$id");
header('location:index.php');
}
// 查询所有质保数据
$list = mysqli_query($conn,"SELECT * FROM warranty ORDER BY id DESC");
?>
质保管理后台
添加质保信息
| ID |
姓名 |
电话 |
商品 |
质保时长 |
备注 |
操作 |
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in /www/wwwroot/myxjd.xyz/index.php on line 87