SQLite3Result::columnName

(PHP 5 >= 5.3.0, PHP 7, PHP 8)

SQLite3Result::columnName — Returns the name of the nth column

说明

public SQLite3Result::columnName(int $column): string|false

Returns the name of the column specified by the column. Note that the name of a result column is the value of the AS clause for that column, if there is an AS clause. If there is no AS clause then the name of the column is unspecified and may change from one release of libsqlite3 to the next.

参数

column: The numeric zero-based index of the column.

返回值

Returns the string name of the column identified by column, or false if the column does not exist.

add a note

User Contributed Notes 1 note

down

-6

david dot barkman13 at gmail dot com ¶

14 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();

    }

?>

add a note