PHP開發(fā) 小型論壇教程之注冊(cè)-2
創(chuàng)建 reg.php 文件
本頁面是將從注冊(cè)頁面?zhèn)鬟^來的數(shù)據(jù)
存放到數(shù)據(jù)庫(kù)里面
代碼如下
<?php
header("Content-type:text/html;charset=utf-8"); //設(shè)置編碼
$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "mybbs";
// 創(chuàng)建連接
$conn = mysqli_connect($servername, $username, $password, $dbname);
mysqli_set_charset($conn,'utf8'); //設(shè)定字符集
$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('用戶名已經(jīng)被注冊(cè)');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('注冊(cè)成功');location.href='index.php';</script>";
}
?>
