php - Fatal error: Call to a member function fetchAll() on a non-object in pdo

Question

I'm new to pdo just tried the following and getting fatal error.

$pdo = new pdo('mysql:localhost;widget_corp;charset=utf-8', 'root', '');
$query = $pdo->query("SELECT * FROM 'users'");
$result_array = $query->fetchAll(PDO::FETCH_ASSOC);

Answer 1

Change:

mysql:localhost;widet_corp

to

mysql:host=localhost;dbname=widget_corp

Also in your posted code:

$query = $pdo->query("SELECT * FROM 'users'");

you have the table name inside single quotes. In Mysql you should use a backtick instead for tables and columns.

    $query = $pdo->query("SELECT * FROM `users`");