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

1. [PHP]代码<?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 "

echo "";

echo "

".$table."";

echo "

";

echo "

";

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

echo "

";

for($i=0;$i

echo "

".$assoc[$ziduan[$i]]."";

}

echo "

";

}

echo "

";

echo "

";

}

foreach ($tables as $value) {

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

show_shuju($sql,$value);

}

?>

相关标签：php

本文原创发布php中文网，转载请注明出处，感谢您的尊重！