21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
//开启Session
session_start();
header("Content-type:text/html;charset=utf-8");
$link = mysqli_connect('localhost','root','123456','panda_work');
if (!$link) {
die("连接失败:".mysqli_connect_error());
}
$workname = @$_POST['workname'];
$rank = @$_POST['rank'];
$category = @$_POST['category'];
$deadline = @$_POST['deadline'];
$description = @$_POST['description'];
$username = @$_SESSION['username'];
if($category==""||$rank==""||$category==""||$deadline==""||$description==""||$username=="")
{
echo "<script>alert('未接收——信息读取失败');window.location.href='../../html/form_validate.html'</script>";
return;
}
$sql = "select * from panda_admin where name='{$username}'";
$res = mysqli_query($link, $sql);
if($row = mysqli_fetch_row($res))
{
$id = $row[0];
}else{
echo "<script>alert('未获得ID——信息读取失败');window.location.href='../../html/form_validate.html'</script>";
return;
}
$addsql = "insert into panda_work(id,name,description, deadline,category,rank)
values('$id','$workname','$description','$deadline','$category','$rank')";
if((mysqli_query($link,$addsql)))
{
echo "<script>alert('插入成功!');window.location.href='../../html/form_validate.html'</script>";
}
else{
echo "<script>alert('未插入成功——数据插入失败');</script>";
}
?>