- <?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);
- }
- ?>
- //该片段来自于http://www.codesnippet.cn/detail/090720134505.html
来源: http://www.codesnippet.cn/detail/090720134505.html