PHP函数，它返回某个表中所有列的名称，作为数组

Question

I've tried this: http://be.php.net/manual/en/function.mysql-list-fields.php, but there's too much detail here.

What I'm looking for is a function that returns an array of strings. This array should only contain the names of all columns that a certain table has.

So for instance, if I have a table with these columns:

username | email | gender |age | married | number_of_children | street | province

I should get the same thing as if I did this:

$vars = array('username','email','gender','age','married','number_of_children','street','province');

Is there a PHP function already that can do this? Or shall I need some SQL statements of my own?

Answer 1

you could also do

$query = mysql_query("SELECT * FROM `table`");
$result = mysql_fetch_assoc($query);
$keys = array_keys($result);

$keys will now contain all of the column names because they were the array keys in the $result array.