Sqlite PDO query returns no results

Question

Getting no results no matter how broad my query PHP: 5.3 Sqlite3: 3.6 PDO: 5.3.3 I would think this should be a very simple process but even looking around I still don't know why I'm getting 0 results. Here is my code:

<?php
$sqlite = new PDO('sqlite:/example.db');
$result = $sqlite->query('SELECT * from  foo');
if(!$result)
{
    echo 'fail';
    return false;
}
?>

Any ideas on what I am doing wrong? The 'foo' table will only have four columns, and this test db only has one table. Running the query in sqlite displays the results fine.

you get an `exception`? Also how do you fetch the details from `$result` — Maheswaran Ravisankar, Feb 01 '14 at 21:58
No exception. I'm not fetching yet the variable is empty, doesn't matter? — Elliot Rocha, Feb 01 '14 at 22:01
Ok, are you sure the Data is in ? if no exception, table should be there anad available thru ur PHP. The insert operation might not be commited in you other sqllite session? — Maheswaran Ravisankar, Feb 01 '14 at 22:04
I'm not sure what you mean about the insert operation. I can run this from command line and get all 7 rows returned: sqlite example.db 'SELECT * from foo' — Elliot Rocha, Feb 01 '14 at 22:08
to get exceptions run: `$sqlite->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);` — bitWorking, Feb 01 '14 at 22:20
Wow thanks - **Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 26 file is encrypted or is not a database' in test.php:9 Stack trace: #0 test.php(9): PDO->query('SELECT * from foo') #1 {main} thrown in test.php on line 9** — Elliot Rocha, Feb 01 '14 at 22:24
I wonder why though if I can run that sqlite query on it from command line.. — Elliot Rocha, Feb 01 '14 at 22:25
Check if `php` has read/write access to the sql database file? — tftd, Feb 01 '14 at 22:48

enterx · Accepted Answer · 2020-09-21T19:27:20.923

9

You have to execute the statement first than fetch the result.

You might add try/catch block around the execute method call. and do some error handling.

Here's an example of catching an Exception. Do not use it as a design guideline.

<?php

try
{
    $sqlite = new PDO('sqlite:/example.db');
}
catch (PDOException $e)
{
  echo 'Connection failed: ' . $e->getMessage();
}

$statement = $sqlite->prepare('SELECT * from  foo');
try
{
     $statement->execute();
}
catch(PDOException $e)
{
     echo "Statement failed: " . $e->getMessage();
     return false;
}

$result = $statement->fetchAll();
var_dump($result);
?>

edited Sep 21 '20 at 19:27

answered Feb 01 '14 at 23:40

enterx

869
4
14

1

Actually I believe whether you fetch the result or not, the var should be true for data. I do have it in try catch, and fetch follows the test to see if !$result. The problem turned out to be a rights issue, discovered by catching the exception. Therefore the var was still empty. Thanks. – Elliot Rocha Feb 01 '14 at 23:52
I've edited my answer to give a better guidance for debugging. I'm now here. :) – enterx Feb 02 '14 at 00:28

Sqlite PDO query returns no results

1 Answers1