php取出mysql数据库中所有数据

<?php

header("Content-Type:text/html; charset=utf-8");

$db_con=new mysqli("localhost","root","psd","ultrax");

if(mysqli_connect_errno()){

exit("连接失败".mysqli_connect_error());

}

$db_con->query("set names utf8");

$result=$db_con->query("show tables");

$tables=array();

while ($row=$result->fetch_row()){

array_push($tables, $row[0]);

}

function show_shuju($sql,$table){

global $db_con;

$result=$db_con->query($sql);

$fields=$result->fetch_fields();

$ziduan=array();

foreach ($fields as $field){

array_push($ziduan, $field->name);

}

$fidld_length=count($ziduan);

echo "<table>";

echo "<thead>";

echo "<caption style='color:red'>".$table."</caption>";

echo "</thead>";

echo "<tbody>";

while($assoc=$result->fetch_assoc()){

echo "<tr>";

for($i=0;$i<$fidld_length;$i++){

echo "<td>".$assoc[$ziduan[$i]]."</td>";

}

echo "</tr>";

}

echo "</tbody>";

echo "</table>";

}

foreach ($tables as $value) {

$sql="select * from ".$value;

show_shuju($sql,$value);

}

?>