- <?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."<br > 列:".$cols;
- // 打印表头
- echo "<table border=1 cellspacing=0><tr>";
- for($i=0; $i<$cols; $i++){
- // 取字段
- $mysql_name = mysql_field_name($res,$i);
- echo "<th>".$mysql_name."</th>";
- }
- echo "</tr>";
- while ($row = mysql_fetch_row($res)){
- echo "<tr>";
- for($i=0; $i<$cols; $i++){
- echo "<td>$row[$i]</td>";
- }
- echo "</tr>";
- }
- echo "</table>";
- // while($field_info = mysql_fetch_field($res)){
- // echo "<br>".$field_info->name;
- ///* 打印结果:
- //*// id
- // name
- // password
- // age*/
- // }
- //var_dump($field_info);
- }
- show_table_info("user1");
来源: http://www.bubuko.com/infodetail-2571811.html