PDO connect not displaying errors

Question

So I'm trying to connect to a DB with PDO. I was able to do this earlier today, but now I'm not sure if its working because when I enter wrong credentials I get errors. Here's my code

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
$host = "localhost";
$pass = "root";
$dbname = "users";
$user = "root";

try{
    $con->pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
    $con = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);

 }
 catch(PDOException $e){
    echo $->getMessage();
 }

When I run any other script they work fine. Anyone see any errors? Also this is what I see in my dev tools when running it. This only happens with the code above.

enter image description here

sectus · Accepted Answer · 2014-06-24 01:06:09Z

3

Your default setting of display_errors is 0. And you have fatal error. So your code have not been executed and display_errors was not changed, hence you have not recieved error message. You could change your ini settings to display errors.

Or even better - use ide with error highlighting.

You should rewrite your code.

try{
    $con = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass); // change order
    $con->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION ); // change to exception, remove pdo->
 }
 catch(PDOException $e){
    echo $e->getMessage(); // <- fixed
 }

edited Jun 24, 2014 at 1:06

answered Jun 24, 2014 at 0:43

sectus

15.7k5 gold badges59 silver badges97 bronze badges

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

Comments

Ryan · Accepted Answer · 2014-06-24 00:48:13Z

0

If you want it throw exceptions, you need to enable to tell it do that.

$con->pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );

Furthermore, try setting error_reporting(-1) to enable them all.

catch(PDOException $e){
    echo $e->getMessage();
}

edited Jun 24, 2014 at 0:48

answered Jun 24, 2014 at 0:42

Ryan

14.7k9 gold badges68 silver badges104 bronze badges

1 Comment

user3537990 Over a year ago

Just fixed it. And still the same issue.

Collectives™ on Stack Overflow

PDO connect not displaying errors

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related