php and mysql登录注册页面

本文将基于PHP以及mysql设计一个最最基础的登录注册页面,所用到的软件有wampserver以及各种PHP编译器,我选择的是,vscode。

第一部分先写个连接数据库文件。

conn.php

<?php
   $conn =@mysqli_connect("localhost","root","") or die("数据库连接出错!");//相应的数据库地址 用户名 和密码
   $selected = mysqli_select_db($conn,"regist");
?>

使用这个后面每次使用时,就可以直接调用,一劳永逸。

现在来写注册界面

signup.php

<?php
    session_start();
    include("conn.php");//连接数据库
    $username =isset($_POST['username'])? $_POST['username'] : '';//用户名
    $password2 =isset($_POST['password2'])? $_POST['password2'] : '';//密码
    $password1 =isset($_POST['password1'])? $_POST['password1'] : '';

    

if(isset($_POST['signup']))
{if($password2==$password1){
    
        $sql ="INSERT INTO account(username,password) VALUES('$username','$password2')";
        mysqli_query($conn,$sql);
        echo "<script>alert('注册成功');window.location ='login.php';</script>";
}
else {echo "<script>alert('两次密码不一致!');window.location ='index.php';</script>";}
    
}


?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width&
  • 2
    点赞
  • 28
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
下面是一个简单的HTML+PHP+MySQL登录注册页面的示例: index.html: ```html <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Login or Register</title> </head> <body> <h1>Login or Register</h1> <p>Please choose:</p> <ul> <li><a href="login.php">Login</a></li> <li><a href="register.php">Register</a></li> </ul> </body> </html> ``` login.php: ```php <?php session_start(); if(isset($_SESSION["username"])) { header("Location: welcome.php"); exit(); } require_once("config.php"); if(isset($_POST["username"]) && isset($_POST["password"])) { $username = $_POST["username"]; $password = md5($_POST["password"]); $sql = "SELECT * FROM users WHERE username='$username' AND password='$password'"; $result = mysqli_query($conn, $sql); if(mysqli_num_rows($result) == 1) { $row = mysqli_fetch_assoc($result); $_SESSION["username"] = $row["username"]; header("Location: welcome.php"); exit(); } else { $error = "Invalid username or password"; } } ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Login</title> </head> <body> <h1>Login</h1> <?php if(isset($error)) echo "<p style='color:red;'>$error</p>"; ?> <form method="post" action=""> <p> <label for="username">Username:</label> <input type="text" id="username" name="username" required> </p> <p> <label for="password">Password:</label> <input type="password" id="password" name="password" required> </p> <p> <button type="submit">Login</button> </p> </form> </body> </html> ``` register.php: ```php <?php require_once("config.php"); if(isset($_POST["username"]) && isset($_POST["password"])) { $username = $_POST["username"]; $password = md5($_POST["password"]); $sql = "INSERT INTO users (username, password) VALUES ('$username', '$password')"; if(mysqli_query($conn, $sql)) { header("Location: login.php"); exit(); } else { $error = "Registration failed"; } } ?> <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Register</title> </head> <body> <h1>Register</h1> <?php if(isset($error)) echo "<p style='color:red;'>$error</p>"; ?> <form method="post" action=""> <p> <label for="username">Username:</label> <input type="text" id="username" name="username" required> </p> <p> <label for="password">Password:</label> <input type="password" id="password" name="password" required> </p> <p> <button type="submit">Register</button> </p> </form> </body> </html> ``` config.php: ```php <?php $servername = "localhost"; $username = "root"; $password = ""; $dbname = "mydb"; $conn = mysqli_connect($servername, $username, $password, $dbname); if(!$conn) { die("Connection failed: " . mysqli_connect_error()); } ?> ``` 注意:这只是一个简单的示例,实际应用中需要进行更多的安全性检查和数据验证。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值