Why not getting results from database using PDO

Question

I am using PDO with OOP. I have a code like this:

public function selectOne($id) {
    $sql = "SELECT * FROM emps WHERE id = ':id'";
    $stmt = $this->connect()->prepare($sql);
    $stmt->bindValue(":id", $id);
    $stmtExec = $stmt->execute();
    if ($stmtExec->rowCount() > 0) {
        echo "got results";
    } else {
        echo 'nothing';
    }
}

When I try to run this it gives me an error: Fatal error: Uncaught Error: Call to a member function rowCount() on boolean

Where am I doing wrong. I am new to Php. Thanks!

this `':id'` is not valid. should be `:id`.. `prepare()` should be false — Rotimi, Mar 20 '18 at 10:07
Also `execute` returns a boolean. You should be calling `rowCount()` on `$stmt`. — Jonnix, Mar 20 '18 at 10:08
@JonStirling, Please tell me then how can i fetch result a(a row) here — Rakesh Kohali, Mar 20 '18 at 10:16
Use `fetch` method on `$stmt`? Read the [docs](http://php.net/manual/en/pdostatement.fetch.php), in particular, the examples. — Jonnix, Mar 20 '18 at 10:18

Zoli Szabó · Answer 1 · 2018-03-20T10:15:17.157

1

There is no need for the single quotes around the named placeholder :id.

$sql = "SELECT * FROM emps WHERE id = :id";

EDIT: Also, like correctly stated by @Jon Stirling, $stmt->execute() returns a boolean. Method rowCount() should be executed on the PDOStatement object instead (your $stmt variable).

http://php.net/manual/en/pdostatement.rowcount.php

edited Mar 20 '18 at 10:15

answered Mar 20 '18 at 10:08

Zoli Szabó

4,366
1
13
19

Why not getting results from database using PDO

1 Answers1