php 面向对象的方式访问数据库 

<body>
<?php

//面向对象的方式访问数据库

//造对象
$db = new MySQLi("localhost","root","123","mydb");

//判断连接是否出错
/*if(mysqli_connect_error())
{
    echo "连接失败！";
    exit;
}*/

!mysqli_connect_error() or die("连接失败！");

//写SQL语句
$sql = "insert into Info values('p010','张三',true,'n002','1988-2-3')";

//执行SQL语句，查询语句返回结果集对象，其他语句返回true或false
$result = $db->query($sql);

//从结果集对象中读取数据
//$attr = $result->fetch_all(MYSQLI_BOTH); //以二维数组的方式返回所有数据
//$attr = $result->fetch_array(); //返回当前指针指向的这条数据
//$attr = $result->fetch_assoc(); //返回当前指针指向的这条数据（关联数组）
//$attr = $result->fetch_object(); //返回对象
//$attr = $result->fetch_row(); //返回索引数组
//var_dump($attr);
/*
while($attr = $result->fetch_row())  //通过循环返回所有一维数组，另外可以在外面定义一个空数组，把循环出来的数通过array_push方法加到空数组中，输出一个2维数组，等同于fetch_all();
{
    var_dump($attr);
}*/

//var_dump($result);



?>
</body>
View Code

例子

登陆界面

<body>
<h1>登录</h1>
<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>
View Code
<?php
$uid = $_POST["uid"];
$pwd = $_POST["pwd"];

//造对象
$db = new MySQLi("localhost","root","123","mydb");
//判断是否出错
!mysqli_connect_error() or die("连接失败！");
//写SQL语句
//容易被SQL注入攻击,不安全
//$sql = "select count(*) from Users where Uid = '{$uid}' and Pwd='{$pwd}'";


$sql = "select Pwd from Users where Uid='{$uid}'";

//执行SQL语句
$result = $db->query($sql);

//取数据
$attr = $result->fetch_row();

if($attr[0] == $pwd)
{
    header("location:main.php");
}
else
{
    echo "登录失败！";
View Code

注册界面

<body>
<form action="zcchuli.php" method="post">
<div>用户名：<input type="text" name="uid" /></div>
<div>密码：<input type="text" name="pwd" /></div>
<div>姓名：<input type="text" name="name" /></div>
<div>性别：<input type="radio" value="1" name="sex" />男 <input type="radio" value="0" name="sex" />女</div>
<div>生日：<input type="text" name="birthday" /></div>
<input type="submit" value="注册" />
</form>
</body>
View Code
<?php
$uid = $_POST["uid"];
$pwd = $_POST["pwd"];
$name = $_POST["name"];
$sex = $_POST["sex"];
$birthday = $_POST["birthday"];

$s = $sex==1?true:false;

//造对象
$db = new MySQLi("localhost","root","123","mydb");

//判断是否出错
!mysqli_connect_error() or die("连接失败！");

//写SQL语句
$sql = "insert into Users values('{$uid}','{$pwd}','{$name}',{$s},'{$birthday}',0)";

//执行SQL语句
$result = $db->query($sql);

if($result)
{
    header("location:zhuce.php");
}
else
{
    echo "注册失败！";
}
View Code

 

posted @ 2016-06-13 11:33  哔哩哔哩干杯  阅读(294)  评论(0)  编辑  收藏  举报