一个非常low的pdo+sql实现的注册 + 登录；

最新推荐文章于 2022-09-15 23:21:29 发布

红鲤鱼铝绿里鱼铝驴

最新推荐文章于 2022-09-15 23:21:29 发布

阅读量896

点赞数 1

文章标签： pdo 注册登录 mysql 调取数据库内容

本文链接：https://blog.csdn.net/cuilei798/article/details/81082878

版权

下面是html注册页面。非常low

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title>Document</title>
</head>
<body>
<form action="phptext10.php" method="POST">
用户名:<input type="text" name="username" value=""/>
<br><br>
密码：<input type="password" name="password" value=""/>
<br><br>
性别：<input type="radio" name="rad" value="男" />男
<input type="radio" name="rad" value="女" />女
<br><br>
<input type="submit" name="but" value="提交"/>
<a href="phptext11.php">立即登录</a>
</form>

</body>
</html>

下面是注册页面的pdo代码，非常low；

<?php
$conn = new PDO('mysql:host=localhost;dbname=admin','root', 'root');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$username=$_POST['username'];
$sql="select * from user where username='$username'";
$result=$conn->query($sql);
$dbh=$result->fetchAll(PDO::FETCH_ASSOC);
if($dbh)
{
echo "用户名已存在";
header("refresh:1;url=phptext08.php");
}else{
$sql_r='insert into user(username,password,sex) values("'.$_POST["username"].'","'.$_POST["password"].'","'.$_POST["rad"].'");';
$result=$conn->query($sql_r);
echo "注册成功";
header("refresh:1;url=phptext11.php");
}
下面是登陆

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<title>Document</title>
</head>
<body>
<form action="phptext09.php" method="POST">
用户名:<input type="text" name="username" value=""/>
<br><br>
密码：<input type="password" name="password" value=""/>
<br><br>
<input type="submit" name="but" value="立即登录"/>
</form>

下面是登陆

<?php

if($_POST)
{
$conn = new PDO('mysql:host=localhost;dbname=admin','root', 'root');
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$username = $_POST['username'];
$password = $_POST['password'];
$sql="select id from user where username='$username' and password='$password';";
$result = $conn->query($sql);
$dbn=$result-> fetch(PDO::FETCH_ASSOC);

if($dbn)
{
echo "成功";
header("refresh:1;url=http://www.baidu.com");
}else
{
echo "失败";
header("refresh:1;url=phptext11.php");
}
}