php和mysql查询并显示_PHP 支持MySQL多表查询并显示

如果 PHP 能够支持 MySQL 多表查询，并能够显示在页面上。那么这将方便于做很多事情。无疑是一个很好的消息。事实上，确定能够，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]
";

}

$mysqli->close();

?>

效果图：