pdoexception not outputting error

Question

    $db = new PDO('mysql:host=localhost;dbname=dbname;charset=utf8', 'username', 'password');
    try
    {
        //Prepare and execute an insert into DB         
        $st = $db->prepare("INSERT INTO users(login,pass,email,county) VALUES(:username,:password,:email,:county)");        
        $st->execute(array(':username' => $_POST['username'], ':password' => $_POST['password1'], ':email' => $_POST['email'], ':county' => $_POST['county']));
        echo 'Success';
    }
    catch (PDOException $e)
    {
        echo $e->getMessage();
    }

Hi, I am not completely familiar with pdo but I thought I would add a few error exceptions, except I won't actually display the error normally as I don't want everyone to know my schema. In this case I changed my working code to a non working code by changing "...,county)" to "....,count)" which obviously did not insert into the database at all but still shown "Success" and no error.

Please help :(

invisal · Accepted Answer · 2013-09-17 11:10:05Z

1

You need to set PDO error mode to throw exception.

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

answered Sep 17, 2013 at 11:10

invisal

11.2k4 gold badges36 silver badges54 bronze badges

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

1 Comment

omega_prime Over a year ago

Thanks, but where should I put that?

Collectives™ on Stack Overflow

pdoexception not outputting error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related