How to get field names of table in Codeigniter

• Get column names of table in codeigniter 4

  --PATH app\Controllers\<Home>.php

  public function getColumnNamesFromTable(){
      $db = \Config\Database::connect();
      $fields = $db->getFieldNames('heroes');
      foreach ($fields as $field)
      {
         echo $field . "<br>";
      }
      die();
  }
  

• Get column names of table in Codeigniter 3

  $fields = $this->db->list_fields('heroes');
  foreach ($fields as $field)
  {
      echo $field . "<br/>";
  }
  

Back to code snippet queries related codeIgniter