PHP PDO fatal error while connecting MySQL database

Question

I am getting following fatal error when i use PDO to connect and retrieve some output from MySQL

Fatal error: Call to a member function prepare() on a non-object in /home/ ... line 21

My PHP Code:

$dbConnection = new PDO('mysql:dbname=abc;host=127.0.0.1;charset=utf8', 'abc','abc');
$dbConnection->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$dbConnection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $pdo->prepare('SELECT current_date()'); //line 21
$stmt->execute();

You don't read "your" code (copied from somewhere?) so you've got errors. — Elon Than
– Elon Than, Commented Oct 9, 2013 at 19:01
@ElonThan : could you please let me know how to read the row values then ? is it $row[0] ? — logan
– logan, Commented Oct 9, 2013 at 19:15
No, I can't. Go and learn PHP before trying to write code in it. — Elon Than
– Elon Than, Commented Oct 9, 2013 at 19:17
Thats expected !! but I could not find enough detail on php.net/manual/en/ref.pdo-mysql.php... — logan
– logan, Commented Oct 9, 2013 at 19:22

Jason OOO · Accepted Answer · 2013-10-09 19:00:33Z

3

change this line:

$stmt = $pdo->prepare('SELECT current_date()'); //line 21

To:

$stmt = $dbConnection->prepare('SELECT current_date()'); //line 21

Because $pdo is not defined here but $dbConnection

answered Oct 9, 2013 at 19:00

Jason OOO

3,5622 gold badges28 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

logan Over a year ago

could you please let me know how to read the row values then ? is it $row[0] ?

Snowburnt · Accepted Answer · 2013-10-09 19:00:25Z

1

try changing the 4th line to

$stmt= $dbConnection->prepare...

answered Oct 9, 2013 at 19:00

Snowburnt

6,9558 gold badges33 silver badges44 bronze badges

Collectives™ on Stack Overflow

PHP PDO fatal error while connecting MySQL database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related