PHP 支持MySQL多表查询并显示

如果 PHP 能够支持 MySQL 多表查询，并能够显示在页面上。那么这将方便于做很多事情。无疑是一个很好的消息。事实上，确定能够，PHP 牛逼。

 

<meta charset="utf-8">
<?php
$host = '127.0.0.1';
$user = 'root';
$pwd = '123456';
$name = 'database';
@$mysqli = new mysqli($host,$user,$pwd,$name);
if (mysqli_connect_errno ()) {  
    echo '数据库连接出现了错误';  
    exit ();  
} 
$mysqli->set_charset ('utf8');
$sql = "SELECT t1.id,t1.staff_name,t2.user_name FROM tb_staff AS t1, tb_user AS t2 WHERE t1.user_id = t2.id LIMIT 0, 10";
$result = $mysqli->query($sql);
while (!!$row = $result->fetch_row()) {
	echo "$row[0]  $row[1]  $row[2]<br>";
}
$mysqli->close();
?>

 

效果图：