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 "登录失败!"; } ?>