利用php获取数据库中所有信息可参考phpMyAdmin

<?php
@mysql_connect("localhost", "root","1981427") //选择数据库之前需要先连接数据库服务器
or die("数据库服务器连接失败");
$dbs = mysql_list_dbs(); //调用mysql_list_dbs函数
while ($array = mysql_fetch_row($dbs)) //循环输出所有的数据库名称
{
echo "$array[0]<BR>";
}
?>
<?php
@mysql_connect("localhost", "root","1981427") //选择数据库之前需要先连接数据库服务器
or die("数据库服务器连接失败");
$dbs = mysql_list_tables("test"); //调用mysql_list_tables函数
while ($array = mysql_fetch_row($dbs)) //循环输出所有的表名称
{
echo "$array[0]<BR>";
}
?>
<?php
mysql_connect("localhost","root","1981427"); //连接服务器
mysql_select_db("test"); //选择数据库
$result = mysql_query("SELECT * from tablename1"); //执行查询操作
echo mysql_num_fields($result); //获取列的数目
?>
<?php
mysql_connect("localhost","root","1981427");
mysql_select_db("test");
$result = mysql_query("SELECT * from tablename1");
echo mysql_field_name($result,0); //获取列的名称
?>
<?php
mysql_connect("localhost","root","1981427");
mysql_select_db("test");
$result = mysql_query("SELECT * from tablename1");
echo mysql_field_type($result,0); //获取列的数据类型
?>
<?php
mysql_connect("localhost","root","1981427");
mysql_select_db("test");
$result = mysql_query("SELECT * from tablename1");
echo mysql_field_len($result,0); //获取列的长度
?>
<?php
mysql_connect("localhost","root","1981427");
mysql_select_db("test");
$result = mysql_query("SELECT * from tablename1");
echo mysql_field_flag($result,0); //获取列的标志
?>
<?php
mysql_connect("localhost","root","1981427"); //连接服务器
mysql_select_db("test"); //选择数据库
echo "<table border='1'>"; //输出表头
echo "<tr><th>列名</th><th>类型</th><th>长度</th><th>标志</th>";
$result = mysql_query("SELECT * from tablename1"); //在mytable表上执行SQL语句
$fields = mys