PHP try catch not catching PDOException/Exception

Question

I have some PDO insert code inside try catch block. I am deliberately passing wrong values to the execute function so that the insert will fail. i.e.; inserting duplicate values on a column that is declared as primary. As tested the insert query fails while executing on console, giving error:

#1062 - Duplicate entry '0' for key 'PRIMARY'

However, my try--catch block is not catching this exception. Is it because PHP does not throw an exception for duplicate entry? I am new to PHP. Have been searching the net but cannot seem to find a clue:

try
 {  
     $query = $conn->prepare($preSQL);
     $query->execute($postSQL);  //$postSQL is the associative array for placeholders
     $dataAdded = $query->rowCount();
     $lastInsertId = $this->conn->lastInsertId();
 }
catch(PDOException $e)
 {
    fwrite($myfile,PHP_EOL);
    fwrite($myfile,$e->getMessage());
    fclose($myfile);
    return false;
 }

check here : phpdelusions.net/pdo#errors

Masivuye Cokile
– Masivuye Cokile

2017-02-27 11:40:53 +00:00
Commented Feb 27, 2017 at 11:40 — Masivuye Cokile
– Masivuye Cokile, Commented Feb 27, 2017 at 11:40

Danny Weatherley · Accepted Answer · 2019-02-24 15:16:54Z

2

You might need to include the PDOException eg

use PDO;
use PDOException;

answered Feb 24, 2019 at 15:16

Danny Weatherley

214 bronze badges

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

Comments

Vural · Accepted Answer · 2017-02-27 12:01:14Z

1

Step:

Add this code to top of the page:

error_reporting(E_ALL);
ini_set("display_errors", 1);
ini_set("display_startup_errors", 1);

use error_reporting(E_ALL) only in development mode!

Step

Add the code below after your $conn = new PDO(...);

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

edited Feb 27, 2017 at 12:01

answered Feb 27, 2017 at 11:41

Vural

8,75611 gold badges43 silver badges58 bronze badges

2 Comments

Vural Over a year ago

then it means : its not throwing a fatal error and ur error_handling level is too low. Let me fix it for you

Yeasir Arafat Majumder Over a year ago

Done. Still the exception is escaping the catch block. Actually my php.ini was already configured to report errors. Below are the values from php.ini: </ br>error_reporting=E_ALL & ~E_DEPRECATED & ~E_STRICT </ br> display_errors=On </ br> display_startup_errors=On

Collectives™ on Stack Overflow

PHP try catch not catching PDOException/Exception

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related