作者:mce | 来源:互联网 | 2018-03-23 15:08
1. [PHP]代码
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 "
";
echo "";
echo "".$table."";
echo "";
echo "";
while($assoc=$result->fetch_assoc()){
echo "";
for($i=0;$i<$fidld_length;$i++){
echo "".$assoc[$ziduan[$i]]." | ";
}
echo "
";
}
echo "";
echo "
";
}
foreach ($tables as $value) {
$sql="select * from ".$value;
show_shuju($sql,$value);
}
?>