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();
?>
从灌饼哥到程序猿,再到攻城狮,