PHP+MYSQL实现简单的用户注册登录功能

偏执的太偏执、 2023-01-20 09:43 11阅读 0赞

**准备工作:**  
*1：在本地搭建好php环境，以便测试；*  
*2：在MySQL里创建一个库和表；*  
创建库:

CREATE DATABASE 数据库名;

创建表:

CREATE TABLE 表名 (
        id INT(12) UNSIGNED AUTO_INCREMENT PRIMARY KEY,  
        username VARCHAR(30) NOT NULL,
        password VARCHAR(32) NOT NULL,
        confirm VARCHAR(32) NOT NULL
        )ENGINE=InnoDB DEFAULT CHARSET=utf8;
    注释:
    	NOT NULL - 每一行都必须含有值（不能为空）。
        UNSIGNED - 使用无符号数值类型，0 及正数。
        AUTO INCREMENT - 设置 MySQL 字段的值在新增记录时每次自动增长 1

**代码如下：**  
由于写前端效果的话代码会过多，我这里就不添加效果了，直入正题  
regedit.html

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>注册</title>
    </head>
    <body>
    	<form action="regedit.php" method="POST" enctype="multipart/form-data">
                	<input type="text" id="username" name="user" placeholder="输入用户名"/><br><br>
                	<input type="password" id="password" name="pass" placeholder="输入密码"/><br><br>
                	<input type="password" id="confirm" name='confirm' placeholder="确认密码"/><br><br>
                	<input type="submit" name=submit id="ze" value="regedit"><br><br>
            </form>
            <li><a href="login.html">返回登入</a></li>
    </body>
    </html>

regedit.php

<?php
    $servername = "localhost";
    $username = "root";
    $password = "123456";
    $dbname = "库名"; //自己创建的数据库名
    
    $user = $_POST['user'];  //获取用户文本框内容
    $pass = $_POST['pass'];  //获取密码文本框内容
    $confirm = $_POST['confirm']; //获取确认密码文本框内容
    
    if($user == ''){   //判断用户，密码两项输入值是否为空
    	echo '<script>alert("请输入用户名!");history.go(-1);</script>'; //php内alert弹窗返回上一页面
    	exit(0);
    }
    if($pass == ''){ 
    	echo '<script>alert("请输入密码!");history.go(-1);</script>';
    	exit(0);
    }
    if($pass != $confirm){  //判断密码和确认密码是否一致 
    	echo '<script>alert("密码不一致!");history.go(-1);</script>';
    	exit(0);
    }
    
    if($pass == $confirm){   
    	$conn = new mysqli($servername,$username,$password,$dbname); //连接数据库
    	if($conn->connect_error){  
    		die("数据库连接失败:".$conn->connect_error);
    		exit(0);
    	}else{ 
    		$sql = "insert into user (username,password,confirm) values ('$user','$pass','$confirm')";  //插入匹配到的用户名，密码，确认密码的值
    		if($conn->query($sql) === TRUE){   
    			echo "<script>alert('注册成功!')</script>";
    			echo '<script>window.location="regedit.html"</script>';
    		}else{ 
    			echo "注册出错!";
    		}
    	}
    }
    
    mysqli_close($conn);  //关闭数据库连接
    
    ?>

<!DOCTYPE html>
    <html lang="en">
    <head>
        <meta charset="UTF-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
        <title>登入</title>
    </head>
    <body>
    	<form action="login.php" method="POST" enctype="multipart/form-data">
                	<input type="text" name="user" placeholder="输入用户名"/><br><br>
                	<input type="password" name="pass" placeholder="输入密码"/><br><br>
                	<input type="submit" name="submit" value="login">
            </form>
            <li><a href="regedit.html">新用户注册</a></li>
    </body>
    </html>

<?php
    $servername = "localhost";
    $username = "root";
    $password = "123456";
    $dbname = "库名"; //自己创建的数据库名
    
    $user = $_POST['user'];  //获取用户名表单值
    $pass = $_POST['pass'];  //获取密码表单值
    $conn = new mysqli($servername,$username,$password,$dbname);  //连接数据库
    if($conn->connect_error){   
    	die("数据库连接失败:".$conn->connect_error);
    	exit(0);
    }else{ 
    	if ($user == ''){   //用户名不能为空
    		echo '<script>alert("请输入用户名");history.go(-1);</script>';
    		exit(0);
    	}
    	if ($pass == ''){  //密码不能为空
    		echo '<script>alert("请输入密码");history.go(-1);</script>';
    	}
    }
    
    $sql = "select username,password from user where username = '$_POST[user]' and password = '$_POST[pass]'";  //查询表里的用户名和密码是否与注册时输入的用户密码一样
    
    $result = $conn->query($sql);
    $number = mysqli_num_rows($result);
    if ($number) { 
    	echo '<script>alert("登入成功");history.go(-1);</script>';
    }else{ 
    	echo '<script>alert("用户名或密码错误!");history.go(-1);</script>';
    }
    ?>