你们可以通过简单指挥获得整个表层结构。

DESC TableName

或您可在询问后使用。

SHOW COLUMNS FROM TableName

$col = $db->query("SHOW COLUMNS FROM category");

while ($fildss = $col->fetch_array())
{             
    $filds[] =  "{ .$fildss[ Field ]. }" ;
    $values[] =  $rows-> .$fildss[ Field ].  ;
}

if($type ==  value )
{
    return $values = implode( , , $values);
}
else {
     return $filds = implode( , , $filds);
}

这为我工作。

$sql = "desc MyTableName";
$result = @mysql_query($sql);
while($row = @mysql_fetch_array($result)){
    echo $row[0]."<br>";
}

I have write a simple php script to fetch table columns through PHP: Show_table_columns.php

<?php
$db =  Database ; //Database name
$host =  Database_host ; //Hostname or Server ip
$user =  USER ; //Database user
$pass =  Password ; //Database user password
$con = mysql_connect($host, $user, $pass);
if ($con) {
    $link = mysql_select_db($db) or die("no database") . mysql_error();
    $count = 0;
    if ($link) {
        $sql = "
            SELECT column_name
            FROM   information_schema.columns
            WHERE  table_schema =  $db 
                   AND table_name =  table_name "; // Change the table_name your own table name
        $result = mysql_query($sql, $con);
        if (mysql_query($sql, $con)) {
            echo $sql . "<br> <br>";
            while ($row = mysql_fetch_row($result)) {
                echo "COLUMN " . ++$count . ": {$row[0]}<br>";
                $table_name = $row[0];
            }
            echo "<br>Total No. of COLUMNS: " . $count;
        } else {
            echo "Error in query.";
        }
    } else {
        echo "Database not found.";
    }
} else {
    echo "Connection Failed.";
}
?>

欢乐!

我的Sqli fetch_field()为我工作:

if ($result = $mysqli -> query($sql)) {
  // Get field information for all fields
  while ($fieldinfo = $result -> fetch_field()) {
    printf("Name: %s
", $fieldinfo -> name);
    printf("Table: %s
", $fieldinfo -> table);
    printf("Max. Len: %d
", $fieldinfo -> max_length);
  }
  $result -> free_result();
}

资料来源:。