1、登录
html代码
<body> <form action="dlchuli.php" method="post"> <div>用户名:<input type="text" name="uid"/></div> <div>密码: <input type="text" name="pwd"/></div> <input type="submit" value="登录"/> </form> </body>
处理页面代码
<?php header("content-type:text/html;charset=utf-8"); $uid=$_POST["uid"]; $pwd=$_POST["pwd"]; $dx=new MySQLi("localhost","root","123","nation"); !mysqli_connect_error() or die("连接失败"); $sql="select pwd from nation1 where uid={$uid}"; $result=$dx->query($sql); $attr=$result->fetch_row(); if($attr[0]==$pwd) { header("location:zhuye.php"); } else { echo "密码错误"; }
方法二:
<?php header("content-type:text/html;charset=utf-8"); $uid=$_POST["uid"]; $pwd=$_POST["pwd"]; $dx=new MySQLi("localhost","root","123","nation"); !mysqli_connect_error() or die("连接失败"); $sql="select count(*) from nation1 where uid={$uid} and pwd={$pwd}"; $result=$dx->query($sql);//$result是一个数组、对象 $attr=$result->fetch_row();//此方法不够安全,不使用 if($attr[0]>0) { echo "返回主页面"; } else { echo "用户名密码错误"; }
2、注册
html代码
<body> <form action="zcchuli.php" method="post"> <div>代号:<input type="text" name="ids"/></div> <div>姓名:<input type="text" name="name"/></div> <div>民族:<input type="text" name="nation"/></div> <div>性别:<input type="radio" value="1" name="sex"/>男<input type="radio" value="0" name="sex"/>女</div> <br /> <input type="submit" value="注册"/> </form> </body>
处理页面代码
<?php header("content-type:text/html;charset=utf-8"); $code=$_POST["ids"]; $name=$_POST["name"]; $nation=$_POST["nation"]; $sex=$_POST["sex"]; $s=$sex==1?true:false; //获取到的都是value值 $dx=new MySQLi("localhost","root","123","nation"); !mysqli_connect_error() or die("连接失败"); $sql="insert into nation values('$code','$name','$nation','$s')"; $result=$dx->query($sql); if($result) { header("location:zhuce.php"); } else { echo "注册失败"; } ?>
No Excuse~