[FIXED] How to get field names of mysql table in codeigniter?

Issue

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.

Solution

using database library write this code to list all fields:

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

take a look here: https://codeigniter.com/userguide3/database/results.html#CI_DB_result::list_fields

Answered By - semsem