CI_DB_result::list_fields PHP Méthode

list_fields() public méthode

Generates an array of column names. Overridden by driver result classes.
public list_fields ( ) : array
Résultat array
    public function list_fields()
    {
        return array();
    }

Usage Example

 /**
  * Generate CSV from a query result object
  *
  * @param	object	$query		Query result object
  * @param	string	$delim		Delimiter (default: ,)
  * @param	string	$newline	Newline character (default: \n)
  * @param	string	$enclosure	Enclosure (default: ")
  * @return	string
  */
 public function csv_from_result(CI_DB_result $query, $delim = ',', $newline = "\n", $enclosure = '"')
 {
     $out = '';
     // First generate the headings from the table column names
     foreach ($query->list_fields() as $name) {
         $out .= $enclosure . str_replace($enclosure, $enclosure . $enclosure, $name) . $enclosure . $delim;
     }
     $out = substr($out, 0, -strlen($delim)) . $newline;
     // Next blast through the result array and build out the rows
     while ($row = $query->unbuffered_row('array')) {
         $line = array();
         foreach ($row as $item) {
             $line[] = $enclosure . str_replace($enclosure, $enclosure . $enclosure, $item) . $enclosure;
         }
         $out .= implode($delim, $line) . $newline;
     }
     return $out;
 }