Chirayu Chirayu - 5 months ago 126
PHP Question

How to get field names of mysql table in codeigniter?

i am new in codeigniter. And i am trying to get field name of a table with a query.

I have write a query


"select * from user"


and pass it to
$this->db->query()
function. i am getting records. But i want to get field names of table. so how can i get that?

Can anybody help me please. Thanks in advance.

Answer

using database library write this code to list all fields:

$this->db->list_fields('table')

take a look here: http://www.codeigniter.com/user_guide/database/results.html#CI_DB_result::list_fields

Comments