<?php
function add(){
if (empty($_POST['name'])){
$GLOBALS['err_message']='请输入姓名';
return;
}
if($_POST['gender']==='-1'&&empty($_POST['gender'])){
$GLOBALS['err_message']='请选择性别';
return;
}
if (empty($_FILES['avatar'])){
$GLOBALS['err_message']='没有接收到文件';
return;
}
$data=$_FILES['avatar'];
//获取文件名的后缀名
$txt=pathinfo($data['name'],PATHINFO_EXTENSION);
//uniaid():基于微秒的当前时间,生成一个唯一id
$target='uploads/'.uniqid().'.'.$txt;
if (!move_uploaded_file($data['tmp_name'],$target)){
$GLOBALS['err_message']='上传文件失败';
return;
}
$name=$_POST['name'];
$gender=$_POST['gender'];
$conn=mysqli_connect('127.0.0.1','root','123456','demo');
if (!$conn){
$GLOBALS['err_message']='连接数据库失败';
return;
}
$query=mysqli_query($conn,"insert into users values(null,'{$name}',{$gender},'{$target}');");
if (!$query){
$GLOBALS['err_message']='添加数据库内容失败';
return;
}
header("Location:list.php");
}
if($_SERVER['REQUEST_METHOD']==='POST'){
add();
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<form action="<?php echo $_SERVER['PHP_SELF'];?>" METHOD="post" enctype="multipart/form-data">
<table>
<tr>
<td>
<label for="name">姓名:</label>
<input type="text" name="name" id="name">
</td>
</tr>
<tr>
<td>
<label for="gender">性别</label>
<select id="gender" name="gender">
<option value="-1">请选择性别</option>
<option value="1">男</option>
<option value="0">女</option>
</select>
</td>
</tr>
<tr>
<td>
<input type="file" name="avatar" id="avatar">
</td>
</tr>
<tr>
<td><button>提交</button></td>
</tr>
</table>
<?php if (isset($err_message)):?>
<p><?php echo $err_message;?></p>
<?php endif;?>
</form>
</body>
</html>
往mysql添加数据
最新推荐文章于 2024-05-06 17:52:23 发布