SQLite3Result::columnName

(PHP 5 >= 5.3.0)

SQLite3Result::columnNameReturns the name of the nth column

Beschreibung

public string SQLite3Result::columnName ( int $column_number )

Returns the name of the column specified by the column_number.

Parameter-Liste

column_number

The numeric zero-based index of the column.

R├╝ckgabewerte

Returns the string name of the column identified by column_number.

add a note add a note

User Contributed Notes 1 note

up
0
david dot barkman13 at gmail dot com
4 years ago
Example:

<?php
   
public function selectAll($table)
    {
       
$results = $this->_dbConn->query("SELECT * FROM $table");
       
$cols = $results->numColumns();
        while (
$row = $results->fetchArray()) {
            for (
$i = 1; $i < $cols; $i++) {
                echo
$results->columnName($i) . ': ';
                echo
$row[$i] . '<br />';
            }
           
//print_r($row);
            //echo 'Username: ' . $row['USERNAME'] . '<br />';
       
}
       
$this->_dbConn->close();
    }
?>
To Top