PHP 개발 소규모 포럼 튜토리얼 등록-2

<?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>alert('注册成功');location.href='index.php';</script>"; } ?>