PHP 支持MySQL多表查询并显示
程序员文章站
2024-03-19 19:30:46
...
如果 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();
?>
效果图:
上一篇: 数据回填