Sqlite with PHP Select Query

Question

I am trying to query a sqlite and I cant seem to figure out why my query returns nothing...Please let me know what I am doing incorrectly: Here is my code:

<?php

class MyDB extends SQLite3
{
    function __construct()
    {
        $this->open('zap.db');
    }
}

$dbname = new MyDB();
$tablename = "test";   

error_reporting (E_ALL ^ E_NOTICE); 

$result = "select user FROM test";
echo "here";

$row = $dbname->query($result);

foreach ($dbname->query("$result") as $row) {
        print $row["user"] . "\n";
    }

?>

You're not using PDO. You're using the SQLite3 extension.

Sander Marechal
– Sander Marechal

2011-04-28 05:17:08 +00:00
Commented Apr 28, 2011 at 5:17 — Sander Marechal
– Sander Marechal, Commented Apr 28, 2011 at 5:17

Community · Accepted Answer · 2023-11-17 20:38:18Z

6

SQLite3::query returns a result resource object. You need to use the fetchArray method on it to get rows from it:

$query = "select user FROM test";
echo "here";

$result = $dbname->query($query);

while ($row = $result->fetchArray()) {
    print $row["user"] . "\n";
}

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered Apr 28, 2011 at 5:20

Sander Marechal

23.3k13 gold badges69 silver badges97 bronze badges

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

2 Comments

Akronix Over a year ago

This doesn't use PDO :(

Sander Marechal Over a year ago

Neither does the question, see my comment on the question.

kishansinh · Accepted Answer · 2014-02-05 06:17:25Z

0

    class MyDB extends SQLite3
    {
        function __construct($db_name)
        {
            $this->open($db_name.".db");
        }

    }

$db = new MyDB($user_db);

$result = $db->query("your query ");

its working great with me in php... you must be enable SQLite3 module version and SQLite Library in your phpinfo file...

answered Feb 5, 2014 at 6:17

kishansinh

1011 gold badge1 silver badge8 bronze badges

Collectives™ on Stack Overflow

Sqlite with PHP Select Query

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