mysql_list_fields

说明

resource mysql_list_fields ( string database_name, string table_name [, resource link_identifier] )

mysql_list_fields() 取得给定表名的信息。参数是数据库名和表名。返回一个结果指针，可以用于 mysql_field_flags()，mysql_field_len()，mysql_field_name() 和 mysql_field_type()。

例子 1. mysql_list_fields() 例子
<?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); $fields = mysql_list_fields("database1", "table1", $link); $columns = mysql_num_fields($fields); for ($i = 0; $i < $columns; $i++) { echo mysql_field_name($fields, $i) . "\n"; }
以上例子将产生如下输出：
field1 field2 field3 ...

为向下兼容仍然可以使用 mysql_listfields()，但反对这样做。

注: mysql_list_fields() 函数已过时。最好用 mysql_query() 来发出一条 SHOW COLUMNS FROM table [LIKE 'name'] 的 SQL 语句来代替。

add a note User Contributed Notes

arster
16-Oct-2005 03:05


# This should also give you an array of column names

$res = mysql_query("SHOW COLUMNS FROM `my_table`");

while ($row = mysql_fetch_array($res)) $col_names[]=$row[0];

harryzhong at hotmail dot com
26-Jul-2005 12:27


Here is a simple script get names of columns in an array:



//Get names of columns in table

$field_names = array();

$res = mysql_query("SHOW COLUMNS FROM `my_table`");

for($i=0;$i<mysql_num_rows($res);$i++){

    array_push($field_names,mysql_result($res, $i));

}

rhyous at yahoo dot com
05-Jun-2005 06:22


To make an array containing the names of a column from a table, you use the following simple script: (Note: using table1 with three columns)



$qColumnNames = mysql_query("SHOW COLUMNS FROM table1",$db) or die("mysql error");

$numColumns = mysql_num_rows($qColumnNames);

$x = 0;

while ($x < $numColumns)

{

    $colname = mysql_fetch_row($qColumnNames);

    $col[$colname[0]] = $colname[0];

    $x++;

}



print_r($col);



/* it will have the following output

Array (

[firstcolumn] => firstcolumn

[secondcolumn] => secondcolumn

[thirdcolumn] => thirdcolumn

)

*/



Or you can number the columns from zero.  This help when using it in conjunction with mysql_fetch_row to get an array.  You don't have to remember which number of the array a certain column is.



$qColumnNames = mysql_query("SHOW COLUMNS FROM table1",$db) or die("mysql error");

$numColumns = mysql_num_rows($qColumnNames);

$x = 0;

while ($x < $numColumns)

{

    $colname = mysql_fetch_row($qColumnNames);

    $col[$colname[0]] = $x;

    $x++;

}



print_r($col);



/* it will have the following output

Array (

[firstcolumn] => 0

[secondcolumn] => 1

[thirdcolumn] => 2

)

*/



To use it in conjuction with mysql_fetch_row:



$row = mysql_fetch_row("SELECT * from table1",$db) or die("mysql error");



You can now call $row[col[firstcolumn]].  This becomes useful when you have a lot of columns.

mbevan at marginsoftware dot com
14-Nov-2003 05:40


If you're willing to use a lot of functions to get a little information about fields in a table, this function is for you.  If you just want to get all the information you can find, you can use this:



<?php



// Taken from: http://ca.php.net/manual/en/function.mysql-field-flags.php

// Original by: amir at scrounch dot com

// Returns the name of the fields in the primary key for a table.

// Also keeps the fields in KEY order.  Handy.

function getPrimaryKeyOf($table) { 

  $keys = Array();



  $query = sprintf("SHOW KEYS FROM `%s`", $table);

  $result = mysql_query($query) or die(mysql_error());



  while ($row = mysql_fetch_assoc($result)) {

    if ( $row['Key_name'] == 'PRIMARY' )

      $keys[$row['Seq_in_index'] - 1] = $row['Column_name'];

  }



  return $keys;

}



// Returns a bunch of information about a table...

// The name of the auto-increment field, if any, fields in the

// primary key (using the function above), and all information

// about all fields.

function getTableInformationOf($table) {

  $information = array(

      "auto"    => "",

      "primary" => array(),

      "fields"  => array()

    );



  $information['primary'] = $this->getPrimaryKeyOf($table);



  $result = mysql_query("DESC `$table`");

  while ( $field = mysql_fetch_assoc($result) ) {

    $information['fields'][] = $field;

    if ( $field['Extra'] == "auto_increment" )

      $information['auto'] = $field['Field'];

  }



  return $information;

}



?>

dom at brainwaveuk dot com
19-Jul-2002 10:55


mysql_list_fields() retrieves information about the given table name but you can use something like mysql_fetch_field to retrieve the field names from a result source.

add a note