本篇文章带大家来了解一下怎样使用PHP来实现简单的登录注册的功能，实现这个功能需要用到MySql的相关知识，希望对大家有帮助！
php怎样实现用户的登录注册
最近学习中要使用PHP+MySql实现简单登录注册，看了很多简单案例后发现，并没有人通过PDO实现简单登录注册，要么就是Mysql和MySqli实现，就算实现了意义也不大，js就可以做的事情，没必要放到PHP中去，我却偏偏不相信，保留着一股倔劲，简单的实现了登录注册，下面请看代码，有错误的地方希望大佬们指教！
新建数据库名itcast , 表名user ,执行下面代码
create table user(
id int unsigned primary key auto_increment,
username varchar(10) not null comment '用户名',
password char(20) not null comment '密码',
email varchar(40) not null comment '邮箱'
)charset=utf8;
insert into user (username,password,email) values
('张三','123456','zhangsan@qq.com');
目录结构
首先从注册前台页面register_html.php开始
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>欢迎注册</title> </head> <form action="./register.php" method="post"> <table > <tr><td class="title" colspan="2">欢迎注册新用户</td></tr> <tr><th>用户名：</th><td><input type="text" name="username" /></td></tr> <tr><th>邮箱：</th><td><input type="text" name="email" /></td></tr> <tr><th>密码：</th><td><input type="password" name="password" id="pw1" /></td></tr> <tr><th>确认密码：</th><td><input type="password" id="pw2" /></td></tr> <tr><td colspan="2" class="td-btn"> <input type="submit" value="提交注册" class="button" /> <input type="button" value="返回登录" class="button" onclick="location.href='login.php'" /> </td></tr> </table> </form> </html>
注册后台页面register.php（注册即是新增）
<?php
header ('Content-type:text/html;charset=utf-8');
//数据库服务器主机名，端口号，选择的数据库，字符集
$dsn = "mysql:host=localhost;dbname=itcast;charset=utf8";
$user = 'root'; //数据库名
$pwd = 'root'; //数据库密码
try{
$pdo = new PDO($dsn,$user,$pwd);
//如果post表单不为空
if(!empty($_POST)){
//声明变量$fields，用来保存字段信息
$fields = array('username','password','email');
//声明$values，用来保存值信息
$values = array();
//遍历$fields，获取输入用户名、密码、邮箱的键和值
foreach($fields as $k=>$v){
$data = isset($_POST[$v]) ? $_POST[$v] : '';
if($data=='') die($v.'字段不能为空！');
//赋值给$fields数组
$fields[$k] = "$v";
//赋值给$values数组
$values[] = "'$data'";
}
//将$fields数组以逗号连接，赋值给$fields，组成insert语句中的字段部分
//implode — 将一个一维数组的值转化为字符串
$fields = implode(',', $fields);
//将$values数组以逗号连接，赋值给$values，组成insert语句中的值部分
$values = implode(',', $values);
//最后把$fields和$values拼接到insert语句中，注意要指定表名
$sql = "insert into user ($fields) values ($values)";
if($res = $pdo->query($sql)){
//注册成功，自动跳转到会员中心
echo '<script>alert("注册成功！");window.location.href="login_html.php";</script>';
}else{
die ('注册失败！');
}
}
}catch(PDOException $e){
echo $e->getMessage().'<br>';
echo $e->getLine().'<br>';
echo $e->__toString().'<br>';
}
define('APP', 'itcast');
require './register_html.php';
登录前台页面login_html.php
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>欢迎登录</title> </head> <body> <form method="post" action="./login.php"> <table> <tr><td>欢迎登录</td></tr> <tr><th>用户名：</th><td><input type="text" name="username" /></td></tr> <tr><th>密码：</th><td><input type="password" name="password" /></td></tr> <tr><td> <input type="submit" value="登录" /> <input type="reset" value="重新填写" /> </td></tr> </table> </form> </body> </html>
登录后台页面login.php
<?php
header ('Content-type:text/html;charset=utf-8');
//数据库相关信息
$dsn = "mysql:host=localhost;dbname=itcast;charset=utf8";
$user = 'root'; //数据库名
$pwd = 'root'; //数据库密码，根据自己的密码更改
try{
$pdo = new PDO($dsn,$user,$pwd);
//如果表单中不为空
if(!empty($_POST)){
//从表单中获取数据
$username = isset($_POST['username']) ? trim($_POST['username']) : '';
$password = isset($_POST['password']) ? ($_POST['password']) : '';
//执行SQL语句
$sql = "select `id`,`password` from `user` where `username`='$username'";
if($res = $pdo->query($sql)){
//登录成功，自动跳转到会员中心
echo '<script>alert("登录成功");window.location.href="index.php";</script>';
}else{
//否则提示登录失败
die('登录失败！');
}
}
}catch(PDOException $e){
//这段用于出错的时候，方便告诉我们那里错了
echo $e->getMessage().'<br>';
echo $e->getLine().'<br>'; //显示错误所在多少行
echo $e->__toString().'<br>';
}
define('APP', 'itcast');
require './login_html.php';
?>
最后是我们登录成功的inex.php页面
<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Insert title here</title> </head> <body> <h1>登录成功！</h1> </body> </html>
这里做的并不是很美观，大家可以在这个基础上增加好看的样式，增加两次密码是否相同的判断，使用正则实现注册格式的判断等等，这里就不一一讲了，目的主要是能实现简单的登录注册，嘻嘻！
输入注册信息
点击注册
注册成功，自动跳转到登录页面
输入刚刚注册的信息
点击登录
成功跳转到index.php页面
大家如果感兴趣的话，可以点击《PHP视频教程》进行更多关于PHP知识的学习。
PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AMAPHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.
Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AMSelect DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.
PHP performance optimization strategies.May 13, 2025 am 12:06 AMPHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi
PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AMPHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl
How to make PHP applications fasterMay 12, 2025 am 12:12 AMTomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc
PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AMToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin
PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AMDependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.
PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AMDatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Dreamweaver Mac version
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
EditPlus Chinese cracked version
Small size, syntax highlighting, does not support code prompt function
MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
