Fatal error: Uncaught Error: Call to a member function fetchAll()

Asked May 28 '22 at 18:36

Active May 28 '22 at 18:36

Viewed 15 times

I know this question has been asked before but the answers found don't help me to find why my code is not working.

I specify that I use WAMP under Windows, that the name of my database is "myapp" and I am looking for the results of the "posts" table.

My SQL query:

"SELECT * FROM `posts`"

works with phpMyAdmin.

Nevertheless; I have the message indicated in the title.

My code:

$pdo = new PDO("mysql:host = localhost; dbname = myapp", 'root', '');
$sql = "SELECT * FROM `posts`";
$query = $pdo->query($sql);
var_dump($query);
$posts = $query->fetchAll();

For information,

var_dump($query);

return false

Please help me :(

Thanks in advance

asked May 28 '22 at 18:36

Flow

1

You might want to check https://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php/12769983#12769983 – Progman May 28 '22 at 18:40
1

remove spaces from dsn – Your Common Sense May 28 '22 at 18:46
try setting this attribute to see the error. `$pdo->setAttribute("PDO::ATTR_ERRMODE", PDO::ERRMODE_EXCEPTION);` – golangphp May 28 '22 at 18:48
Oh my god, it was indeed the spaces in the DSN. Ty so much. – Flow May 28 '22 at 19:06

Fatal error: Uncaught Error: Call to a member function fetchAll()

0 Answers0