php编写一个表,PHP编写一个函数，可以接收一个表名，然后打印表的表头和记录在网页...

function show_table_info($table_name){

$conn = mysql_connect("localhost" , "root" , "root");

if(!$conn){

die('连接失败'.mysql_error());

}

mysql_select_db("test1",$conn);

mysql_query("set names gbk");

// $sql = "select * from user1";

$sql = "desc user1";

$res = mysql_query($sql , $conn);

//获取结果集的行数、列数

$rows = mysql_affected_rows($conn); //参数是连接

$cols = mysql_num_fields($res); //参数是返回的资源

echo "行：".$rows."
列：".$cols;

//打印表头

echo "

for($i=0; $i

//取字段

$mysql_name = mysql_field_name($res,$i);

echo "

".$mysql_name."";

}

echo "

";

while ($row = mysql_fetch_row($res)){

echo "

";

for($i=0; $i

echo "

$row[$i]";

}

echo "

";

}

echo "

";

// while($field_info = mysql_fetch_field($res)){

// echo "
".$field_info->name;

// /*打印结果：

// *

// id

// name

// password

// email

// age*/

// }

//var_dump($field_info);

}

show_table_info("user1");