php 获取mysql结果集数据

	$sql="select * from tab1"; //mysql语法
	$result = $mysqli->query($sql); //执行mysql语句
	$num=mysqli_fetch_all($result); //获取结果集,是一个二维数组,类似:[行1:[ 字段名1->值,...],行2[]... ]
	// $num = count($rec);
	// var_dump($num);
	echo "<table>
		<tr>
	 		<th>id</th>
	 		<th>订单号</th>
	 		<th>用户名</th>
	 		<th>电话号码</th>
	 		<th>时间</th>
 		</tr>
	";
	if($result===false){
		echo "获取数据失败";
	}else{
		foreach ($num as $key => $value) { //遍历每一行数据,返回数组
			echo "<tr>";  
			foreach ($value as $k => $v) { //遍历每一行的数据,$k是数组下标(字段),$v是字段值

				echo "<td>".$v."</td>";
			}
			echo "</tr>";
		}
		// for ($i=1; $i <= $num['count(id)']; $i++) { 
		// 	$sql = 'select * from tab1 where id='.$i;
		// 	// var_dump($sql);exit;
		// 	$result = $mysqli