PDO Statement not returning result

Question

$query = $db->prepare("SELECT * FROM coupons WHERE deleted = ? LIMIT ?, ?");
$query->bindValue("1", 0);
$query->bindValue("2", 2);
$query->bindValue("3", 5);
    try{
        $query->execute();
        $result = $query->fetchAll();
        return $result;
    }catch(PDOException $e){
        die($e->getMessage());
}

Unfortunately this returns a result with no rows (but an empty result not even an error), and when I run this sql query through phpmyadmin, it fetches me multiple rows. Any suggestions would be really be helpful. I can't get through this.

Duplicate of http://stackoverflow.com/questions/15990857/reference-frequently-asked-questions-about-pdo — Your Common Sense, Apr 14 '14 at 11:05
Have you configured PDO to throw exceptions? It doesn't by default. — Álvaro González, Apr 14 '14 at 11:24
This worked. And this was so stupid I wasted 2 hours. :\ Thanks mate. — Gaurav, Apr 14 '14 at 11:30
please try to close the question, either by picking a suitable answer or writing your own answer and selecting it as the answer — Luceos, Apr 14 '14 at 11:40

score 0 · Answer 1 · edited May 23 '17 at 12:13

0

First comment to this question helped me very well: Here

And solved my problem. Al the above suggestions mentioned above were previously tried and did not work.

edited May 23 '17 at 12:13

Community

1
1

answered Apr 14 '14 at 11:43

Gaurav

29
9

Fadey · Answer 2 · 2014-04-14T11:41:58.870

-1

bindValue expects an integer in case of you using a question mark as a binder and not a string like you provided:

$query = $db->prepare("SELECT * FROM coupons WHERE deleted = ? LIMIT ?, ?");
$query->bindValue(1, 0);
$query->bindValue(2, 2);
$query->bindValue(2, 5);
    try{
        $query->execute();
        $result = $query->fetchAll();
        return $result;
    }catch(PDOException $e){
        die($e->getMessage());
}

or simply do this:

$query = $db->prepare("SELECT * FROM coupons WHERE deleted = ? LIMIT ?, ?");
$binds = array(0,2,5);
    try{
        $query->execute($binds);
        $result = $query->fetchAll();
        return $result;
    }catch(PDOException $e){
        die($e->getMessage());
}

edited Apr 14 '14 at 11:41

answered Apr 14 '14 at 11:11

Fadey

430
2
11

Defensively right, edited added an explanation for him. – Fadey Apr 14 '14 at 11:36
Instead of solving, both your variants will actually fail in default emulation mode. – Your Common Sense Apr 14 '14 at 11:54

score -1 · Answer 3 · answered Apr 14 '14 at 11:21

-1

try to use like this

<?php
$query = $db->prepare("SELECT * FROM coupons WHERE deleted = :deleted LIMIT :limit, :offset");
$query->bindValue(":deleted", 0);
$query->bindValue(":limit", 2);
$query->bindValue(":offset", 5);
    try{
        $query->execute();
        $result = $query->fetchAll();
        return $result;
    }catch(PDOException $e){
        die($e->getMessage());
}
?>

answered Apr 14 '14 at 11:21

shivanshu patel

782
10
19

why should he try it? – Your Common Sense Apr 14 '14 at 11:34
but **what** should it fix? what is the problem this code is fixing? – Your Common Sense Apr 14 '14 at 11:53

PDO Statement not returning result

3 Answers3