PHP development small forum tutorial registration PHP page

This page is to store the data passed from the registration page into the database

##The code is as follows

<?php
header("Content-type:text/html;charset=utf-8");    //设置编码
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "mybbs";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($conn,'utf8'); //设定字符集
$username=$_POST['username'];
$password=md5($_POST['password']);
$email=trim($_POST['email']);
$log_time=date("Y-m-d H:i:s");
$sql1="SELECT * from menber where username='$username'";
$que=mysqli_query($conn,$sql1);
if($num){
    echo"<script>alert('用户名已经被注册');location.href='reg.html';</script>";
}else{
    $sql="INSERTinto member(username,password,email,log_time)VALUES
    ('$username','$password','$email','$log_time')";
    $que=mysqli_query($conn,$sql);
    $_SESSION['username']=$username;
    echo "<script>console.log('注册成功');location.href='index.php';</script>";
}
?>

Now our login and registration page is complete, hurry up and try it

Continuing Learning

new file

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
<?php
header("Content-type:text/html;charset=utf-8"); //设置编码
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "mybbs";
// 创建连接
$conn = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($conn,'utf8'); //设定字符集
$username=$_POST['username'];
$password=md5($_POST['password']);
$email=trim($_POST['email']);
$log_time=date("Y-m-d H:i:s");
$sql1="select * from menber where username='$username'";
$que=mysqli_query($conn,$sql1);
if($num){
 echo"<script>alert('用户名已经被注册');location.href='reg.html';</script>";
}else{
 $sql="insert into member(username,password,email,log_time)VALUES
 ('$username','$password','$email','$log_time')";
 $que=mysqli_query($conn,$sql);
 $_SESSION['username']=$username;
 echo "<script>console.log('注册成功');</script>";
}
?>
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX