PHP SQLite fetchAll returning empty array

Question

I created this php script which queries a sqlite database as so:

$r = $db->prepare("SELECT * FROM logs WHERE ip=?;");
$r->bindValue(1, $ip, PDO::PARAM_STR);
$r->execute();

if($r->fetchColumn() >= 1) {
   echo "contains columns.. <br />";
$result = $r->fetchAll();
    foreach ($result as $log) {
        echo "in loop";
        $log_ip = $log['ip'];
        $log_userAgent = $log['userAgent'];
        $log_hits = $log['hits'];

        $log_hits = $log_hits++;

        echo "hits " . $log_hits;

        $hitUp = $db->prepare("UPDATE logs SET hits = ? WHERE ip = ?;");
        $hitUp->bindValue(1, $log_hits, PDO::PARAM_INT);
        $hitUp->bindValue(2, $ip, PDO::PARAM_STR);
        $hitUp->execute();
}

However, $r->fetchAll(); is returning an empty array.

I am 100% sure that the row exists and $ip is 127.0.0.1:

sqlite> select * from logs;
1|127.0.0.1|1|Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/534.54.16 (KHTML, like Gecko) Version/5.1.4 Safari/534.54.16

Any help is greatly appreciated

If you remove WHERE ip=?, do you still get an empty array? — user610650
– user610650, Commented Apr 7, 2012 at 8:10
If i run SELECT * FROM logs; in sqlite3 it returns the correct rows, but in pdo/php no? — Daniel
– Daniel, Commented Apr 7, 2012 at 8:17

user610650 · Accepted Answer · 2012-04-07 08:21:42Z

2

You probably need to remove the if($r->fetchColumn() >= 1) as it probably consumes your single result:

Returns a single column from the next row of a result set or FALSE if there are no more rows.

Also, you shouldn't doubt that you have at least a column, you should instead verify if $result is empty.

Perhaps try that by running something like this:

$r = $db->prepare("SELECT * FROM logs;");
$r->execute();
$result = $r->fetchAll();
echo "result contains " . count($result);

If you still get 0 record in your array, perhaps there is something wrong more upstream. Let me know if you still get 0 record.

answered Apr 7, 2012 at 8:21

user610650

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

Collectives™ on Stack Overflow

PHP SQLite fetchAll returning empty array

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