PHP loginsignup function

Posted on | In

use php to build login/signup function

login

create database in mysql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<?php
// 创建连接
$conn = new mysqli("localhost", "uesename", "password");
// 检测连接
if ($conn->connect_error) 
{    
    die("连接失败: " . $conn->connect_error);} 
    // 创建数据库
    $sql = "CREATE DATABASE test";
        if ($conn->query($sql) === TRUE) 
        {    
        echo "数据库创建成功";
        } else {    
        echo "Error creating database: " . $conn->error;
        }
    $conn->close();
?>
1
2
3
4
5
6
7
8
 $sql = "CREATE TABLE login (
id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
password VARCHAR(30) NOT NULL,)ENGINE=InnoDB DEFAULT CHARSET=utf8 ";
<?php
$SQL = "INSERT INTO login ('id','username','password') VALUES ('7', 'tom', '12345');"
?>

html structure

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
 <!DOCTYPE html>
<html>
<head>
    <title>用户登录页面</title>
    <meta charset="UTF-8"/>
    <style type="text/css">
        *{margin:0px;padding:0px;}
        ul{
            width:400px;
            list-style:none;
            margin:50px auto;
        }
        li{
            padding:12px;
            position:relative;
        }
        label{
            width:80px;
            display:inline-block;
            float:left;
            line-height:30px;
        }
        input[type='text'],input[type='password']{
            height:30px;
        }
        img{
            margin-left:10px;
        }
        input[type="submit"]{
            margin-left:80px;
            padding:5px 10px;
        }
    </style>
</head>
<body>
<form action="login.php" method="post">
    <ul>
        <li>
            <label>用户名：</label>
            <input type="text" name="username" placeholder="请输入登录账号"/>
        </li>
        <li>
            <label>密码：</label>
            <input type="password" name="password" placeholder="请输入密码" />
        </li>
        <li>
            <label>验证码：</label>
            <input type="text" name="code" size="4" style="float:left"/>
            <a href="javascript:;" onclick="document.getElementById('captcha_img').src='captcha.php?r='+Math.random()">
                <img id="captcha_img" border='1' src='captcha.php?r=echo rand(); ?>' style="width:100px; height:30px" />
            </a>
        </li>
        <li>
            <input type="submit" value="登录" />
        </li>
    </ul>
</form>
</body>
</html>

captcha.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
 <?php
//设置session,必须处于脚本最顶部
  session_start();
  
  $image = imagecreatetruecolor(100, 30);    //1>设置验证码图片大小的函数
  //5>设置验证码颜色 imagecolorallocate(int im, int red, int green, int blue);
  $bgcolor = imagecolorallocate($image,255,255,255); //#ffffff
  //6>区域填充 int imagefill(int im, int x, int y, int col) (x,y) 所在的区域着色,col 表示欲涂上的颜色
  imagefill($image, 0, 0, $bgcolor);
  //10>设置变量
  $captcha_code = "";
  //7>生成随机数字
  for($i=0;$i<4;$i++){
    //设置字体大小
    $fontsize = 6;
    //设置字体颜色，随机颜色
    $fontcolor = imagecolorallocate($image, rand(0,120),rand(0,120), rand(0,120));      //0-120深颜色
    //设置数字
    $fontcontent = rand(0,9);
    //10>.=连续定义变量
    $captcha_code .= $fontcontent;
    //设置坐标
    $x = ($i*100/4)+rand(5,10);
    $y = rand(5,10);
   imagestring($image,$fontsize,$x,$y,$fontcontent,$fontcolor);
  }
  //10>存到session
  $_SESSION['authcode'] = $captcha_code;
  //8>增加干扰元素，设置雪花点
  for($i=0;$i<200;$i++){
    //设置点的颜色，50-200颜色比数字浅，不干扰阅读
    $pointcolor = imagecolorallocate($image,rand(50,200), rand(50,200), rand(50,200));
    //imagesetpixel — 画一个单一像素
    imagesetpixel($image, rand(1,99), rand(1,29), $pointcolor);
  }
  //9>增加干扰元素，设置横线
  for($i=0;$i<4;$i++){
    //设置线的颜色
    $linecolor = imagecolorallocate($image,rand(80,220), rand(80,220),rand(80,220));
    //设置线，两点一线
    imageline($image,rand(1,99), rand(1,29),rand(1,99), rand(1,29),$linecolor);
  }
  //2>设置头部，image/png
  header('Content-Type: image/png');
  //3>imagepng() 建立png图形函数
  imagepng($image);
  //4>imagedestroy() 结束图形函数 销毁$image
  imagedestroy($image);
?>

login.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
 <?php
    //开启Session
    session_start();
    header("Content-type:text/html;charset=utf-8");
    $link = mysqli_connect('localhost','root','root','test');
    if (!$link) {
     die("连接失败:".mysqli_connect_error());
    }
    //接受提交过来的用户名及密码
    $username = $_POST["username"];//用户名
    $password = $_POST["password"];//密码
    $code = $_POST["code"]; //验证码
    if($username == "")
    {
     //echo "请填写用户名<br>";
     echo"<script type='text/javascript'>alert('请填写用户名');location='login.html'; </script>";
    }
    if($password == "")
    {
     //echo "请填写密码<br><a href='login.html'>返回</a>";  
     echo"<script type='text/javascript'>alert('请填写密码');location='login.html';</script>";
    }
    if($code != $_SESSION['authcode']) //判断填写的验证码是否与验证码PHP文件生成的信息匹配
    {
     echo "<script type='text/javascript'>alert('验证码错误!');location='login.html';</script>";
    }
    $sql = "select * from login";
    $result = mysqli_query($link, $sql);
    $rows = mysqli_fetch_array($result);
    if($rows) {
     //拿着提交过来的用户名和密码去数据库查找，看是否存在此用户名以及其密码
        if ($username == $rows["username"] && $password == $rows["password"]) {
         //echo "验证成功！<br>";
         echo "<script type='text/javascript'>alert('登陆成功');location='success.html';</script>";
        } else {
         //echo "用户名或者密码错误<br>";
         echo "<script type='text/javascript'>alert('用户名或者密码错误');location='login.html';</script>";
         //echo "<a href='login.html'>返回</a>";
        }
    }
?>

signup

create database in mysql

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
<?php
    // 创建连接
    $conn = new mysqli("localhost", "uesename", "password","test");
    // 检测连接
    if ($conn->connect_error) 
    {    
    die("连接失败: " . $conn->connect_error);
    } 
    // 使用 sql 创建数据表
    $sql = "CREATE TABLE login (
    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(30) NOT NULL,
    password VARCHAR(30) NOT NULL,
    confirm VARCHAR(30) NOT NULL,
    email VARCHAR(30) NOT NULL,
    )ENGINE=InnoDB DEFAULT CHARSET=utf8 ";
    if ($conn->query($sql) === TRUE) 
    {    
    echo "Table MyGuests created successfully";
    } else {    
    echo "创建数据表错误: " . $conn->error;
    }
    $conn->close(); 
?>

signup.html

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
<!DOCTYPE html>
<html>
<head>
    <title>用户注册页面</title>
    <meta charset="UTF-8"/>
    <style type="text/css">
        *{margin:0px;padding:0px;}
        ul{
            width:400px;
            list-style:none;
            margin:50px auto;
        }
        li{
            padding:12px;
            position:relative;
        }
        label{
            width:80px;
            display:inline-block;
            float:left;
            line-height:30px;
        }
        input[type='text'],input[type='password']{
            height:30px;
        }
        img{
            margin-left:10px;
        }
        input[type="submit"]{
            margin-left:80px;
            padding:5px 10px;
        }
    </style>
</head>
<body>
   <form action="signup.php" method="post">
      <ul>
        <li>
            <label>用户名：</label>
            <input type="text" name="username" placeholder="请输入注册账号"/>
        </li>
        <li>
            <label>密 码：</label>
            <input type="password" name="password" placeholder="请输入密码" />
        </li>
        <li>
            <label>确认密码：</label>
            <input type="password" name="confirm" placeholder="请再次输入密码" />
        </li>
        <li>
            <label>邮 箱：</label>
            <input type="text" name="email" placeholder="请输入邮箱"/>
        </li>
        <li>
            <label>验证码：</label>
            <input type="text" name="code" size="4" style="float:left" placeholder="请填写验证码"/>
            <a href="javascript:;" onclick="document.getElementById('captcha_img').src='captcha.php?r='+Math.random()">
                <img id="captcha_img" border='1' src='captcha.php?r=echo rand(); ?>' style="width:100px; height:30px" />
            </a>
        </li>
        <li>
            <input type="submit" value="注册" />
        </li>
      </ul>
  </form>
</body>

signup.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
<?php
  session_start();
  header("Content-type:text/html;charset=utf-8");
  $link = mysqli_connect('localhost','root','root','test');
  if (!$link) {
    die("连接失败:".mysqli_connect_error());
  }
  
  $username = $_POST['username'];
  $password = $_POST['password'];
  $confirm = $_POST['confirm'];
  $email = $_POST['email'];
  $code = $_POST['code'];
  
  if($username == "" || $password == "" || $confirm == "" || $email == "" || $code == "")
  {
    echo "<script>alert('信息不能为空！重新填写');window.location.href='signup.html'</script>";
  } elseif ((strlen($username) < 3)||(!preg_match('/^\w+$/i', $username))) {
    echo "<script>alert('用户名至少3位且不含非法字符！重新填写');window.location.href='signup.html'</script>";
    //判断用户名长度
  }elseif(strlen($password) < 5){
      echo "<script>alert('密码至少5位！重新填写');window.location.href='signup.html'</script>";
      //判断密码长度
  }elseif($password != $confirm) {
      echo "<script>alert('两次密码不相同！重新填写');window.location.href='signup.html'</script>";
      //检测两次输入密码是否相同
  } elseif (!preg_match('/^[\w\.]+@\w+\.\w+$/i', $email)) {
      echo "<script>alert('邮箱不合法！重新填写');window.location.href='signup.html'</script>";
      //判断邮箱格式是否合法
  } elseif($code != $_SESSION['authcode']) {
    echo "<script>alert('验证码错误！重新填写');window.location.href='signup.html'</script>";
    //判断验证码是否填写正确
  } elseif(mysqli_fetch_array(mysqli_query($link,"select * from login where username = '$username'"))){
    echo "<script>alert('用户名已存在');window.location.href='signup.html'</script>";
  } else{
    $sql= "insert into login(username, password, confirm, email)values('$username','$password','$confirm','$email')";
    //插入数据库
    if(!(mysqli_query($link,$sql))){
      echo "<script>alert('数据插入失败');window.location.href='signup.html'</script>";
    }else{
      echo "<script>alert('注册成功！去登陆');window.location.href='login.html'</script>";
    }
  }
?>
``` 
### links between login and signup
``` html
 <a href="zhuce.html" style="text-decoration: none; padding-left: 30px;">注册</a>