如果结果为空，如何获取字段名称？ [PHP-笨]

Question

I was able to take the field name from the table using array_keys() but if the query results are empty, array_keys() can not be used.

is there any other way that I can take the name of the field even if the result is empty?

Query i used:

SELECT m.nama_user, m.nama_login, m.email, m.tgl_expired, m.password_web, gu.ucode_grp, gu.nama_grp_user
FROM tb_m_user m
LEFT OUTER JOIN tb_m_grp_user gu
ON m.ucode_grp=gu.ucode_grp
WHERE id_user=10

Answer 1

In Codeigniter you can use...

$field_names = $this->db->list_fields('name_of_your_table');

name_of_your_table is the name of the Database Table you want the field list from.

$field_names will be an array with the field names

For more Details, Refer to https://www.codeigniter.com/userguide3/database/db_driver_reference.html?highlight=field%20names#CI_DB_driver::list_fields