一.效果展示

点击注册后

数据库已经多了一条数据

二.实现过程
1.工具:
phpstudy7.0或以上版本(phpstudy的配置我上篇博客讲了:https://blog.youkuaiyun.com/doubleguy/article/details/96005440) ,sublime(编辑器不强制,记事本都可以,只要能写东西)
2.来个前端(这里给主要文件index.html)
<!DOCTYPE HTML>
<html lang="zxx">
<head>
<title>Home</title>
<!-- Meta tag Keywords -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta charset="UTF-8" />
<meta name="keywords" content=""
/>
<script>
addEventListener("load", function () {
setTimeout(hideURLbar, 0);
}, false);
function hideURLbar() {
window.scrollTo(0, 1);
}
</script>
<!-- Meta tag Keywords -->
<!-- css files -->
<link rel="stylesheet" href="css/style.css" type="text/css" media="all" />
<!-- Style-CSS -->
<link rel="stylesheet" href="css/fontawesome-all.css">
<!-- Font-Awesome-Icons-CSS -->
<!-- //css files -->
<!-- web-fonts -->
<link href="http://maxcdn.bootstrapcdn.com/css?family=Josefin+Sans:100,100i,300,300i,400,400i,600,600i,700,700i" rel="stylesheet">
<link href="http://maxcdn.bootstrapcdn.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i,800,800i" rel="stylesheet">
<!-- //web-fonts -->
</head>
<body>
<!-- bg effect -->
<div id="bg">
<canvas></canvas>
<canvas></canvas>
<canvas></canvas>
</div>
<!-- //bg effect -->
<!-- title -->
<h1>用户注册系统</h1>
<!-- //title -->
<!-- content -->
<div class="sub-main-w3">
<form action="../admin/admin.php" method="post">
<h2>开始注册
<i class="fas fa-level-down-alt"></i>
</h2>
<div class="form-style-agile">
<label>
<i class="fas fa-user"></i>
用户名
</label>
<input placeholder="Username" name="username" type="text" required="">
</div>
<div class="form-style-agile">
<label>
<i class="fas fa-unlock-alt"></i>
密码
</label>
<input placeholder="Password" name="password" type="password" required="">
</div>
<div class="form-style-agile">
<label>
<i class="fas fa-user"></i>
电子邮件
</label>
<input placeholder="Email" name="email" type="text" required="">
</div>
<div class="form-style-agile">
<label>
<i class="fas fa-user"></i>
年龄
</label>
<input placeholder="Age" name="age" type="text" required="">
</div>
<div>
<label>
<i class="fas fa-user"></i>
性别
</label>
<input type='radio' name='gender' value="boy">男 <input type='radio' name='gender' value="girl">女
</div>
<!-- checkbox -->
<div class="wthree-text">
<ul>
<li>
<label class="anim">
<input type="checkbox" class="checkbox" required="">
<span>我已同意注册协议</span>
</label>
</li>
</ul>
</div>
<!-- //checkbox -->
<input type="submit" name='submit' value="注册">
</form>
</div>
<!-- //content -->
<!-- copyright -->
<div class="footer">
<p>Copyright © 2019.7.4 doubleguy</a></p>
</div>
<!-- //copyright -->
<!-- Jquery -->
<script src="js/jquery-3.3.1.min.js"></script>
<!-- //Jquery -->
<!-- effect js -->
<script src="js/canva_moving_effect.js"></script>
<!-- //effect js -->
</body>
</html>
3.写个辣鸡后台
<!doctype html>
<head>
<meta charset="utf-8">
<title>
用户注册系统
</title>
<!-- <style>
body{
background-image: url(test1.jpg);
background-size: cover;
}
</style> -->
</head>
<body bgcolor="#E6E6FA">
<?php
// 1.连接并配置数据库
// 连接到主机
$con = mysqli_connect('localhost','root','root');
//判断连接是否成功
if(!$con){
//连接失败,终止程序并输出错误信息
die("Connection failed: " . mysqli_connect_error());
}
//连接成功
//选择数据库
mysqli_select_db($con,'register');
//2.处理注册请求并插入到数据库
//判断是否有提交请求
if(!isset($_POST['submit'])){
exit("没有提交请求,搞神马飞机啦你?本想叫你声靓仔,你非要当sd!");
}
//获取表单中的数据
$username = $_POST['username'];
$password = $_POST['password'];
$gender = $_POST['gender'];
$email = $_POST['email'];
$age = $_POST['age'];
// print('<pre>');
// var_dump($_POST);
// print('</pre>');
//预处理及绑定,将用户信息插入数据库
$sql = $con->prepare("INSERT INTO user (username,password,email,age,gender) values (?,?,?,?,?)");
$sql->bind_param("sssis", $username,$password,$email,$age,$gender);
//执行sql语句
$result = $sql->execute();
// var_dump($result);
// echo '<br>';
// 判断执行语句影响的条数
if(!$result){
die('向数据库插入数据失败了,wc,顶雷哥fei啊!').mysqli_error($con);
}else{
echo "可喜可贺,帅的人总是一脸轻松 ~ <br>";
echo "你的信息已经存入数据库!<br>";
echo "信息如下:<br>";
print('<pre>');
var_dump($_POST);
print('</pre>');
}
//关闭数据库连接
mysqli_close($con);
?>
</body>
完事。。

本文介绍了一个简单的用户注册系统的实现过程,包括前端页面的设计与后端数据处理。前端使用HTML、CSS和JavaScript完成用户输入界面,而后端则通过PHP连接MySQL数据库进行数据存储。
2244





