How to display data from a SQLite DB using PHP v.5.6.24?

Question

I am trying to get out data of a SQLite Database and display this data on my website. I am using PHP version 5.6.24 (and I have not the permission to update it).

From this PHP Manual I took the following code:

`

$db = new SQLite3('DB_NAME.db');

$results = $db->query('SELECT * FROM user');
while ($row = $results->fetchArray()) {
    var_dump($row);
}`

and I got this output:

array(10) { [0]=> NULL ["Username"]=> NULL 1=> NULL ["FirstName"]=> NULL [2]=> NULL ["LastName"]=> NULL [3]=> NULL ["Authorithy"]=> NULL [4]=> NULL ["ProfilePicture"]=> NULL }

The Attributes of my db are Username, Firstname, ProfilePicture and Authorithy but I want to get the data from the table and not only the header attributes.

How to write such a query?

DinoCoderSaurus · Accepted Answer · 2019-07-05 11:34:09Z

1

That result indicates there is one row in the user table, and all the column values are NULL.

answered Jul 5, 2019 at 11:34

DinoCoderSaurus

6,5502 gold badges13 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

How to display data from a SQLite DB using PHP v.5.6.24?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related