<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>
例子
登陆界面
<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>
<?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 "登录失败！";
注册界面
<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>
<?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 "注册失败！"; }