"Trying to get property of non-object" sql error

Question

Hi I know other questions already have the answer to this but I don't understand. I've done lots of research and am still confused.

I have a table in my Mysql that I made with PHP My Admin it has three rows (I'll add to these) and 3 columns (id, name and price) I'd like to output the first rows name and id but I keep getting the error

Trying to get property of non-object;

<?php
 $db = new PDO('mysql:host=localhost;dbname=sitefiles;charset=utf8mb4','user', 'pass');           
 $sql = 'SELECT id, name FROM 1/1/16';
 $results = $db->query($sql);

 if ($results->num_rows > 0) {
    while($row = $results->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["name"];
    }
}
?>

How can I get rid of this error? Thank you :)

Try wrapping `1/1/16` in backticks. I think `$result` is returning `false`. — ImClarky, Mar 21 '16 at 09:12
I doubt that PDO has `num_rows` or `fetch_assoc()`. When you switch to PDO from other extension, you can't just change the `mysql_connect()` part to PDO. — frz3993, Mar 21 '16 at 09:14
You mixed PDO with mysqli (num_rows, fetch_assoc). Read the documentation: http://php.net/manual/en/book.pdo.php — Rocki, Mar 21 '16 at 09:47

score 1 · Answer 1 · answered Mar 21 '16 at 09:14

1

Your table name seems to be unusual. Try to use back-ticks to quote it:

$sql = 'SELECT id, name FROM `1/1/16`';

answered Mar 21 '16 at 09:14

DevilaN

1,317
10
21

i added these in and the error changed to Undefined property: PDOStatement::$num_rows – Oli B Mar 21 '16 at 09:40

"Trying to get property of non-object" sql error

1 Answers1