How to set Attribute to PDO connection in Codeigniter

Question

How to set attributes (PDO::ATTR_ERRMODE) on the PDO database handle in Codeigniter?

Answer 1

I think a better option is to use a MY_Model (which you then extend and this is available then across the application) and define something like this in the construct:

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

Note conn_id allows you to access the main PDO object.