How to implement php registration function-PHP Problem-php.cn

How to implement php registration function

藏色散人

Release： 2023-03-09 07:28:01

Original

3963 people have browsed it

How to implement the php registration function: first create the user table in the existing database; then create the HTML registration form and PHP registration program; finally create the login form and login program.

How to implement php registration function

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

php registration login system simplified version

Login to the registration system is the most common operation on the Internet every day. I have set up a category to improve the registration and login system step by step. If there are any mistakes, please forgive me.

Language used:php

Database:mysql

this Functions implemented once:

1. User registration

2. User login

Main files:

Complete code

1 sql creates a user table in an existing database, with three fields: id, username, and password.

The code is as follows:

create table user(id int(10) not null auto_increment,username varchar(30),password varchar(40),primary key(id));

Copy after login

2 connect.php database configuration file

<?php
 $server="localhost";//主机
 $db_username="";//你的数据库用户名
 $db_password="";//你的数据库密码

 $con = mysql_connect($server,$db_username,$db_password);//链接数据库
 if(!$con){
  die("can&#39;t connect".mysql_error());//如果链接失败输出错误
 }
 
 mysql_select_db(&#39;test&#39;,$con);//选择数据库（我的是test）
?>

Copy after login

3 signup.html registration form

<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <title>用户注册页面</title>
 </head>
 <body>
  <form action="signup.php" method="post">
   <p>用户名:<input type="text" name="name"></p>
   <p>密 码: <input type="text" name="password"></p>
   <p><input type="submit" name="submit" value="注册"></p>
  </form>
 </body>
</html>

Copy after login

4 signup.php registration process

<?php 
 header("Content-Type: text/html; charset=utf8");

 if(!isset($_POST[&#39;submit&#39;])){
  exit("错误执行");
 }//判断是否有submit操作

 $name=$_POST[&#39;name&#39;];//post获取表单里的name
 $password=$_POST[&#39;password&#39;];//post获取表单里的password

 include(&#39;connect.php&#39;);//链接数据库
 $q="insert into user(id,username,password) values (null,&#39;$name&#39;,&#39;$password&#39;)";//向数据库插入表单传来的值的sql
 $reslut=mysql_query($q,$con);//执行sql
 
 if (!$reslut){
  die(&#39;Error: &#39; . mysql_error());//如果sql执行失败输出错误
 }else{
  echo "注册成功";//成功输出注册成功
 }
 mysql_close($con);//关闭数据库

?>

Copy after login

The registration process is completed, the following is the user login [Recommended learning: PHP video tutorial 】

5 login.html login form

<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <title>登陆</title>
 </head>
 <body>
  <form name="login" action="login.php" method="post">
    <p>用户名<input type=text name="name"></p>
    <p>密 码<input type=password name="password"></p>
    <p><input type="submit" name="submit" value="登录"></p>
   </form>
 </body>
</html>

Copy after login

6 login.php login program

<?PHP
 header("Content-Type: text/html; charset=utf8");
 if(!isset($_POST["submit"])){
  exit("错误执行");
 }//检测是否有submit操作 

 include(&#39;connect.php&#39;);//链接数据库
 $name = $_POST[&#39;name&#39;];//post获得用户名表单值
 $passowrd = $_POST[&#39;password&#39;];//post获得用户密码单值

 if ($name && $passowrd){//如果用户名和密码都不为空
    $sql = "select * from user where username = &#39;$name&#39; and password=&#39;$passowrd&#39;";//检测数据库是否有对应的username和password的sql
    $result = mysql_query($sql);//执行sql
    $rows=mysql_num_rows($result);//返回一个数值
    if($rows){//0 false 1 true
     header("refresh:0;url=welcome.html");//如果成功跳转至welcome.html页面
     exit;
    }else{
    echo "用户名或密码错误";
    echo "
     <script>
       setTimeout(function(){window.location.href=&#39;login.html&#39;;},1000);
     </script>

    ";//如果错误使用js 1秒后跳转到登录页面重试;
    }
    

 }else{//如果用户名或密码有空
    echo "表单填写不完整";
    echo "
      <script>
       setTimeout(function(){window.location.href=&#39;login.html&#39;;},1000);
      </script>";

      //如果错误使用js 1秒后跳转到登录页面重试;
 }

 mysql_close();//关闭数据库
?>

Copy after login

7 welcome.html successful login page

<!doctype html>
<html lang="en">
 <head>
  <meta charset="UTF-8">
  <title>登陆成功</title>
 </head>
 <body>
  欢迎光临
 </body>
</html>

Copy after login

At this point, a simple and complete registration and login system is completed. The code is very simple and does not consider the verification security and robustness. It will be improved later.

The above is the detailed content of How to implement php registration function. For more information, please follow other related articles on the PHP Chinese website!