实战php制作会员管理系统（三）

我们直接看下面得代码，分别是连接数据库，设置字符集等，还可以判断账号密码是否为空

//连接数据库
$conn = mysqli_connect("localhost","root","root","member");
if(!$conn){
    die("数据库链接失败！");
}
//设置字符集
mysqli_query($conn,"sex names utf8");
//判断参数
if(!strlen($username)||!strlen($password)){
    echo "<script>alert('账号密码不得为空!');history.back()</script>";
    exit;
}

$sql="select * from info where username ='$username'";
$result=mysqli_query($conn,$sql);
$num=mysqli_num_rows($result);
if($num){
    echo "<script>alert('用户名已被占用!');history.back()</script>";
    exit;
}
//sql语句
$sql = "insert into info (username,password,email,sex,fav,createtime) values ('$username','".md5($password)."','$email','$sex','$fav','".time()."')";
$result = mysqli_query($conn,$sql);
if($result){
    echo "<script>alert('保存成功!');</script>";
}else{
    echo "<script>alert('保存失败!');</script>";
}

这里我们看到，已经成功提交到数据库