php method to implement user registration login interface: 1. Create log.php main login interface; 2. Set register.php main registration interface; 3. Connect to the database through mysqli_connect and perform corresponding data operations.
The operating environment of this tutorial: Windows 7 system, PHP version 8.1, Dell G3 computer.
php How to implement user registration and login interface?
Simple implementation of PHP login and registration page (including database verification) (including database)
log.php (main login interface)
Because it is a simple page , the login page only performs database verification. In fact, email verification and verification code verification can also be added if conditions permit.
<!doctype html> <html> <head> <meta charset="utf-8"> <title>无标题文档</title> </head> <style type="text/css"> #aaa{width: 300px; height: 30px;} </style> <body> <center> <h2>登录界面</h2> <form method="POST" action="log_ok.php"> 账号 :<input id="aaa" type="text" name="uname" placeholder="用户名" /> <br /><br/> 密码 :<input id="aaa"type="password" name="pwd" placeholder="密码" /> <br /> <input type="submit" > <input type="reset"> <a href="register.php">注册账号</a> </form> </center> </body> </html>
log_ok.php
<!doctype html> <html> <head> <meta charset="utf-8"> <title>无标题文档</title> </head> <body> <?php header("content-type:text/html; charest=UTF-8");//文件编码格式 // Session需要先启动。 session_start(); //判断uname和pwd是否赋值 if(isset($_POST['uname']) && isset($_POST['pwd'])){ $name = $_POST['uname']; $pwd = $_POST['pwd']; //连接数据库 require("conn.php"); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } //验证内容是否与数据库的记录吻合。 $sql = "SELECT * FROM register WHERE (account='$name') AND (password='$pwd')"; //执行上面的sql语句并将结果集赋给result。 $result = $conn->query($sql); //判断结果集的记录数是否大于0 if ($result->num_rows > 0) { // 输出每行数据 ,,,不知道为什么在这个变量前设置字符串的时候,必须得用"",''这个是不实现的。。什么不使用也可以成功 while($row = $result->fetch_assoc()) { echo'欢迎'.$row['username']; echo '<p> 账号:' . $row['account'].' <br/> 姓名:' . $row['username'].' <br/> 性别:' . $row['sex'].' <br/> 年龄:' . $row['age'].' <br/> 地址:' . $row['address'].' <br/> 邮箱:' . $row['mail'].' <br/> 电话:' . $row['number'].' <br/> </p>'; } } else { echo "没有您要的信息"; } $conn->close(); //关闭数据库 } ?> </body> </html>
register.php (register main interface)
This I set up a random ID on the page. As long as I refresh the page, a new account will appear. However, since what I am doing is simple, I have not realized that the ID will not be repeated. If possible, you can implement it and send it to me for mutual communication. In addition, I have not set up repeated password verification. It is just a simple one. If you want, make it and send me a copy. Ha ha.
<!doctype html> <html> <head> <meta charset="utf-8"> <title>无标题文档</title> </head> <style type="text/css"> .aaa{width: 300px; height: 30px;} </style> <style type="text/javascript"> </style> <body> <?php $a=mt_rand(333333,999999999); ?> <center> <h2>注册界面</h2> <form method="post" name="from1" action="register_ok.php"><!-- 在数据库中id是自动增长列 --> 账号: <input name="id" class="aaa" type="text" value="<?php echo"$a";?>"><br/><br/> 姓名: <input class="aaa" type="text" name="username"><br/><br/> 性别: <input class="aaa" type="text" name="sex"><br/><br/> 年龄: <input class="aaa" type="text" name="age"><br/><br/> 地址: <input class="aaa" type="text" name="address"><br/><br/> 邮箱: <input class="aaa" type="text" name="mail"><br/><br/> 密码: <input class="aaa" type="text" name="password"><br/><br/> 确认 密码: <input class="aaa" type="text" name="repsw"><br/><br/> 手机号: <input class="aaa"type="text" name="number"><br/><br/> <input type="reset"name="reset" value="重置"> <input type="submit"name="submit" value="注册" onClick="myfunction"> <a href="log.php"><< 返回上一页</a> <a href="register.php">点击注册</a> </form> </body> </html>
register_ok.php
<!doctype html> <html> <head> <meta charset="utf-8"> <title>无标题文档</title> </head> </body> <body> <?php include_once("conn.php"); header("content-type:text/html; charest=UTF-8");//文件编码格式 $id=$_POST['id']; $username=$_POST['username']; $sex=$_POST['sex']; $age=$_POST['age']; $address=$_POST['address']; $mail=$_POST['mail']; $password=$_POST['password']; $number=$_POST['number']; if(!($id and $username and $sex and $age and $address and $mail and $password and $number)){ echo("输入值不能为空");//判断变量名是否为空值 }else{ $sqlstr1="insert into register values('".$id."','".$username."','".$sex."','".$age."','".$address."','".$mail."','".$password."','".$number."')"; //执行sql insert语句 把用post引用的变量接入到bookable中 $result = mysqli_query($conn,$sqlstr1);//承接结果集 if($result){ echo"添加成功"; }else{ echo"<script>alter('添加失败');history.go(-1);</script>"; } } echo"$id $username $sex $age $address $mail $password $number"; ?> </body> </html>
conn.php(Connect to database)
<!doctype html> <html> <head> <meta charset="utf-8"> <title>conn文件</title> </head> <body> <?php $mysql_server_name = 'localhost'; //改成自己的mysql数据库服务器 $mysql_username = 'root'; //改成自己的mysql数据库用户名 $mysql_password = ''; //改成自己的mysql数据库密码 $mysql_database = 'regist'; //改成自己的mysql数据库名 $conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database); //连接数据库 //连接数据库错误提示 mysqli_query($conn, 'set names utf8'); mysqli_query($conn, 'set character set utf8'); if (mysqli_connect_errno($conn)) { die("连接 MySQL 失败: " . mysqli_connect_error()); } ?> </body> </html>
Database
1. The database name is register
2. The table name is register
Recommended learning: "PHP Video Tutorial》
The above is the detailed content of How to implement user registration login interface in php. For more information, please follow other related articles on the PHP Chinese website!