查询数据 表格形式展示

<?php
$db= new MySQLi("localhost","root","","hr"); //建立链接
!mysqli_connect_error() or die("链接失败");    //判断链接是否正确
$sql="select * from info";                   //写语句
$request=$db->query($sql);                   //执行语句
if($request)
{
	echo"<table width='100%' border='1' cellpadding='0' cellspacing='0'>"; //输出表格
	echo"<tr>
	<td>Code</td><td>Name</td><td>Sex</td><td>Nation</td><td>Birthday</td> //输出表头
	</tr>";
	$a=$request->fetch_all();
	foreach($a as $b){
		echo"<tr><td>$b[0]</td><td>$b[1]</td><td>$b[2]</td><td>$b[3]</td><td>$b[4]</td></tr>";//利用foreach输出表格
		}
	echo"</table";
	}











?>

　　

转载于:https://www.cnblogs.com/yuchao19950412/p/5454871.html