PHP PDO error using SQLite3

Question

Here is the code:

<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
if ($_GET['id']) {

    $id = $_GET['id'];

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

    $sth = $db->query('SELECT * FROM channels WHERE id = :id');
    $sth->bindValue(':id', $id);

    while ($row = $sth->fetchArray()) {
        var_dump($row);
    }
}
?>

Here is the error message:

Fatal error: Call to undefined method SQLite3Result::bindValue() in /var/www/index.html on line 12

I do not understand what Call to undefined method means since I am following the examples on PHP's own website.

You need to call $db->prepare(), not $db->query(). query returns a result set; prepare returns a statement. — jbafford
– jbafford, Commented Feb 8, 2016 at 15:17

Hanky Panky · Accepted Answer · 2016-02-08 15:17:23Z

3

prepare()

Where is that? If you were following the manual correctly you would be preparing a statement and that statement would provide bindValue() method :)

By executing a query directly on the database handle you don't get the features that statements provide. You have to create an SQLite3Stmt object for it.

Like this

$stmt = $db->prepare('SELECT * FROM channels WHERE id=:id');
$stmt->bindValue(':id', $id, SQLITE3_INTEGER);
$result = $stmt->execute();

Reference

answered Feb 8, 2016 at 15:17

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

PHP PDO error using SQLite3

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