面向对象方式访问数据库案例-----登录和注册

1、登录

html代码

<body>
<form action="dlchuli.php" method="post">
<div>用户名:<input type="text" name="uid"/></div>
<div>密码:&nbsp;<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 "注册失败";
    }
?>