php mysql 获取列名,如何获取PHP MySQLi中的列名？

Using Php and MySQLi how do I get the column names of a table and then put the result of that query in an array?

解决方案

The following code gets all column names from table table_name:

$mysqli = new mysqli('localhost', 'USERNAME_HERE', 'PASSWORD_HERE', 'DATABASE_HERE');

$sql = 'SHOW COLUMNS FROM table_name';

$res = $mysqli->query($sql);

while($row = $res->fetch_assoc()){

$columns[] = $row['Field'];

}

Since I have the columns id and name in my table, this is the result:

Array

(

[0] => id

[1] => name

)

If you want to get the columns from a resultset, it depends, but here is one way to do it:

$mysqli = new mysqli('localhost', 'USERNAME_HERE', 'PASSWORD_HERE', 'DATABASE_HERE');

$sql = 'SELECT * FROM table_name';

$res = $mysqli->query($sql);

$values = $res->fetch_all(MYSQLI_ASSOC);

$columns = array();

if(!empty($values)){

$columns = array_keys($values[0]);

}

Example result for $columns:

Array

(

[0] => id

[1] => name

)

Example result for $values:

Array

(

[0] => Array

(

[id] => 1

[name] => Name 1

)

[1] => Array

(

[id] => 2

[name] => Name 2

)

)