php file isn't recognising my sqlite3 db mydb.sq3

Question

I'm running xampp.

I created a basic db call mydb.sq3 and a basic table called panels. That all seems to work fine because when I call SELECT * FROM panels; from the command line it is all good. But there is an error that keeps getting thrown when i run my php file:

Fatal error: Call to undefined function query() in > C:\xampp\htdocs\example\myphp.php on line 10

<?php
    $db = new SQLite3('mydb.sq3');
    $result = $db-->query('SELECT * FROM panels');
    while ($row = $result->fetchArray(SQLITE3_ASSOC))
    {
          echo $row['firstname'] . ': $' . $row['surname'] . '<br/>';
    }
   unset($db);
?>

Cheers

one to many dashes ---------

user557846
– user557846

2016-06-05 05:07:40 +00:00
Commented Jun 5, 2016 at 5:07 — user557846
– user557846, Commented Jun 5, 2016 at 5:07

Kalrav Joshi · Accepted Answer · 2016-06-05 05:17:17Z

1

There is an error in line 3

Use this-

$result = $db->query('SELECT * FROM panels');

Instead of this -

$result = $db-->query('SELECT * FROM panels');

Simple typo error you used '--' instead of '-' Enjoy :)

answered Jun 5, 2016 at 5:17

Kalrav Joshi

863 bronze badges

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

Collectives™ on Stack Overflow

php file isn't recognising my sqlite3 db mydb.sq3

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