PDO : get result from SELECT query

Question

I am trying to get result from a prepared SELECT query, but i get this error :

PHP Notice: Trying to get property of non-object in /..../php/my.php on line 50

Here is the code :

// Prepared statement
$queryA = $pdo->prepare("SELECT * FROM test WHERE a_id = :id AND created_email = :email");

// Execute statement
$result = $queryA->execute(array(
    'id'        => $id,
    'email'     => $emailAddress
));

if ($result->num_rows > 0) {   // Line 50

while($row = $result->fetch_assoc()) {

...

Is your query generating any error? – Mureinik May 27 '16 at 08:42 — Mureinik, May 27 '16 at 08:42
`num_rows` is used in mysqli not in PDO – Saty May 27 '16 at 08:45 — Saty, May 27 '16 at 08:45

score 0 · Answer 1 · answered May 27 '16 at 08:49

To get the data from a statement, you have basically three options:

foreach over PDOStatement object
use familiar while with PDOStatement::fetch() method
get all the rows in the form of array using PDOStatement::fetchAll() method

So in your case it could be

$stmt = $pdo->prepare("SELECT * FROM test WHERE a_id = :id AND created_email = :email");

// Execute statement
$stmt->execute(array(
    'id'        => $id,
    'email'     => $emailAddress
));

foreach ($stmt as $row) {

if you want to process the data right in place.

PDO : get result from SELECT query

1 Answers1