PHP数据库登陆注册简单做法




<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
</head>

<body>
<h1>注册</h1>
<form action="./zhucechuli0.php" method="post">

    <div>用户名：<input id="yhm" type="text" name="uid" /></div>
    
    <div>密码：<input id="mm" type="text" name="pwd" /></div>
    
    <div>姓名：<input type="text" name="name" /></div>
    
    <div><input type="submit" name="注册" onclick="return yanzheng()" /></div>
</form>



<h1>登陆</h1>
<form action="./dengluchuli.php" method="post">

    <div>用户名：<input type="text" name="uid" /></div>
    
    <div>密码：<input type="text" name="pwd" /></div>
    
    <div><input type="submit" name="登陆" /></div>
</form>


</body>


</html>

1.做登陆注册页面

2.做一个注册处理PHP

<?php

$uid = $_POST["uid"];
$pwd = $_POST["pwd"];
$name = $_POST["name"];

//1.造连接对象
$db = new MySQLi("localhost","root","212333","ppo");

//2.写SQL语句
$sql = "insert into login values('{$uid}','{$name}','{$pwd}',0)";

//3.执行
$r = $db->query($sql);

if($r)
{
    echo "注册成功！";
}
else
{
    echo "注册失败！";
}



?>

3.做登陆处理页面

<?php
$uid = $_POST["uid"];
$pwd = $_POST["pwd"];

//1.造连接对象
$db = new MySQLi("localhost","root","212333","ppo");

//2.写SQL语句
$sql = "select password from login where username='{$uid}'";

//3.执行
$reslut = $db->query($sql);

//4.取数据
$attr = $reslut->fetch_row();

if($attr[0]==$pwd && !empty($pwd))
{
    echo "登录成功！";
}
else
{
    echo "登录失败！";
}
?>