Retrieve column names from sqlite3 database with php

Question

I have the following piece of code which displays a list of my current table names in my database which works fine.

<?php // Display all sqlite tables
    $db = new SQLite3('data.db');
    $tablesquery = $db->query("SELECT name FROM sqlite_master WHERE type='table';");

    while ($table = $tablesquery->fetchArray(SQLITE3_ASSOC)) {
        echo $table['name'] . '<br />';
} ?>

Can you display the list of column names for a table like you can do in mysql? I have tried numerous iterations and all have failed.

esqew · Accepted Answer · 2014-05-10 03:42:05Z

3

Refer to SQLite.org - PRAGMA Statements:

PRAGMA table_info(sqlite_master);

To fit it into your PHP implementation:

<?php // Display all sqlite tables
    $db = new SQLite3('data.db');
    $tablesquery = $db->query("PRAGMA table_info(sqlite_master);");

    while ($table = $tablesquery->fetchArray(SQLITE3_ASSOC)) {
        echo $table['name'] . '<br />';
} ?>

answered May 10, 2014 at 3:42

esqew

45k28 gold badges139 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

William Entriken Over a year ago

Useless, this is table names, not column names.

esqew Over a year ago

@FullDecent OP was asking about column names for the sqlite_master table. Would this not be the expected output?

c9s · Accepted Answer · 2017-05-13 11:13:53Z

0

Try this sqlite table schema parser, I implemented the sqlite table parser for parsing the table definitions in PHP.

https://github.com/maghead/sqlite-parser

answered May 13, 2017 at 11:13

c9s

1,91719 silver badges16 bronze badges

Collectives™ on Stack Overflow

Retrieve column names from sqlite3 database with php

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related