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

@mysql_connect("localhost", "root","1981427") //选择数据库之前需要先连接数据库服务器

or die("数据库服务器连接失败");

$dbs = mysql_list_dbs(); //调用mysql_list_dbs函数

while ($array = mysql_fetch_row($dbs)) //循环输出所有的数据库名称

{

echo "$array[0]
";

}

?>

@mysql_connect("localhost", "root","1981427") //选择数据库之前需要先连接数据库服务器

or die("数据库服务器连接失败");

$dbs = mysql_list_tables("test"); //调用mysql_list_tables函数

while ($array = mysql_fetch_row($dbs)) //循环输出所有的表名称

{

echo "$array[0]
";

}

?>

mysql_connect("localhost","root","1981427"); //连接服务器

mysql_select_db("test"); //选择数据库

$result = mysql_query("SELECT * from tablename1"); //执行查询操作

echo mysql_num_fields($result); //获取列的数目

?>

mysql_connect("localhost","root","1981427");

mysql_select_db("test");

$result = mysql_query("SELECT * from tablename1");

echo mysql_field_name($result,0); //获取列的名称

?>

mysql_connect("localhost","root","1981427");

mysql_select_db("test");

$result = mysql_query("SELECT * from tablename1");

echo mysql_field_type($result,0); //获取列的数据类型

?>

mysql_connect("localhost","root","1981427");

mysql_select_db("test");

$result = mysql_query("SELECT * from tablename1");

echo mysql_field_len($result,0); //获取列的长度

?>

mysql_connect("localhost","root","1981427");

mysql_select_db("test");

$result = mysql_query("SELECT * from tablename1");

echo mysql_field_flag($result,0); //获取列的标志

?>

mysql_connect("localhost","root","1981427"); //连接服务器

mysql_select_db("test"); //选择数据库

echo "

echo "

列名类型长度标志";

$result = mysql_query("SELECT * from tablename1"); //在mytable表上执行SQL语句

$fields = mys