php用面向对象从mysql取数据

<?php

//建立数据库的链接
@$_mysqli = new mysqli('localhost','root','123456','dbname');
if(mysqli_connect_errno()){
    echo 'mysqli Connect is error'.mysqli_connect_error();
    exit();
}
//设置客户端字符编码
$_mysqli->set_charset('utf8');
//数据库查询语句
$sqli= "SELECT * FROM tp_blog";

//运行查询语句
$result=$_mysqli->query($sqli);

//循环出数据库数据 
 while(!!$rows = $result->fetch_assoc()){
     print_r($rows).'<br />';  //遍历出所有数据
         $rows['title'].'<br />'; //遍历某个字段的数据
 }
 


$result ->free();

$_mysqli->close();

?>

转载于:https://www.cnblogs.com/guanbingge/p/5783079.html