摘要：//查出数据库中按年龄的倒叙排列的最后两名 function create(){ $db = mysqli_connect('127.0.0.1','root','root','myphp','3306'); &nbs
//查出数据库中按年龄的倒叙排列的最后两名
function create(){
$db = mysqli_connect('127.0.0.1','root','root','myphp','3306');
if(!$db){
return mysqli_error($db) ;
}
return $db;
}
$email = 'dfbb@qq.comssss';
$password = sha1('123456');
$time = time();
function insert($db,$password,$time){
$sql = "INSERT INTO `user` VALUES (NULL,'东败',1,18,'dfbb@qq.com','{$password}',1,{$time});";
$res = mysqli_query($db,$sql);
return $res;
}
$arr = [];
function select($db){
$sql = "SELECT * FROM `user` ORDER BY age DESC LIMIT 1,2";
$res = mysqli_query($db,$sql);
while ($ress = mysqli_fetch_assoc($res)){
$arr[] = $ress;
}
return $arr;
}
$db = create();
//$res = insert($db,$password,$time);
$res = select($db);
print_r($res);
批改老师：西门大官人批改时间：2019-03-03 09:43:45
老师总结：mysqli的使用没有问题，但是不要把业务逻辑封装到select、insert等公共方法中。sql语句建议做为参数传递进去
