CodeIgniter - how to catch DB errors

Question

Is there a way to make CI throw an exception when it encounters a DB error instead of displaying a message like      A Database Error Occurred    Error Number  1054           Unknown column  foo  in  where clause     SELECT   FROM  FooBar  WHERE foo    1    NOTE  I only want this to happen in one controller  In the other controllers  I m happy for it to display the DB error messages

User · Accepted Answer

Try these CI functions  this- gt db- gt  error message     mysql error equivalent   this- gt db- gt  error number     mysql errno equivalent   UPDATE FOR CODEIGNITER 3 Functions are deprecated  use error   instead   this- gt db- gt error

User · Answer

If one uses PDO  additional to all the answers above   I log my errors silently as below           q    this- gt db- gt conn id- gt prepare  query            if  q instanceof PDOStatement                  go on with bind values and execute            else               dbError    this- gt db- gt error               this- gt Logger model- gt logError  Db Error   date  Y-m-d H i s      METHOD     Line     LINE     Code     dbError  code     -     Message     dbError  message

User · Answer

I know this thread is old  but just in case there s someone else having this issue  This is a trick I used without touching the CI db classes  Leave your debug on and in your error view file  throw an exception   So in you db config  you have      db  default    db debug     true    Then in your db error view file  mine is in application errors error db php replace all content with the following    lt  php  message   preg replace     lt    p gt             message   throw new Exception  Database error occured with message     message        gt    Since the view file will be called  the error will always get thrown as an exception  you may later add different views for different environment

User · Answer

Put this code in a file called MY Exceptions php in application core folder    lt  php  if   defined  BASEPATH        exit  No direct script access allowed            Class dealing with errors as exceptions     class MY Exceptions extends CI Exceptions                   Force exception throwing on erros             public function show error  heading   message   template    error general    status code   500                set status header  status code             message   implode          is array  message     array  message     message            throw new CiError  message                    Captured error from Code Igniter     class CiError extends Exception        It will make all the Code Igniter errors to be treated as Exception  CiError   Then  turn all your database debug on    db  default    db debug     true

User · Answer

You must turn debug off for database in config database php -     db  default    db debug     FALSE    It is better for your website security

User · Answer

I have created an simple library for that     lt  php defined  BASEPATH   OR exit  No direct script access allowed     class exceptions        public function checkForError             get instance  - gt load- gt database             error   get instance  - gt db- gt error            if   error  code                throw new MySQLException  error            abstract class UserException extends Exception       public abstract function getUserMessage       class MySQLException extends UserException       private  errorNumber      private  errorMessage       public function   construct array  error             this- gt errorNumber    Error Code      error  code                   this- gt errorMessage    error  message               public function getUserMessage             return array               error    gt  array                    code    gt   this- gt errorNumber                   message    gt   this- gt errorMessage                                     The example query   function insertId  id        data   array           id    gt   id               this- gt db- gt insert  test    data        this- gt exceptions- gt checkForError        return  this- gt db- gt insert id        And I can catch it this way in my controller    try         this- gt insertThings- gt insertId  1       catch  UserException  error          do whatever you want when there is an mysql error

User · Answer

In Codeigniter 3 0  CI3   all you have to do is  this- gt db- gt error    If you need to get the last error that has occured  the error   method will return an array containing its code and message http   www codeigniter com user guide database queries html handling-errors

User · Answer

In sybase driver php        Manejador de Mensajes de Error Sybase   Autor  Isa   Moreno   Fecha  06 Nov 2019     static   CODE ERROR SYBASE   public static function SetCodeErrorSybase  Code        if   Code    3621       No se toma en cuenta el c  digo de command aborted           CI DB sybase driver   CODE ERROR SYBASE   trim CI DB sybase driver   CODE ERROR SYBASE      Code                   public static function GetCodeErrorSybase                        return CI DB sybase driver   CODE ERROR SYBASE     public static function msg handler  msgnumber   severity   state   line   text               log message  info    CI DB sybase driver - CODE ERROR     msgnumber    Mensaje -    text       CI DB sybase driver  SetCodeErrorSybase  msgnumber            ------------------------------------------------------------------------   Add and modify the following methods in the same sybase driver php file         The error message number        access  private     return  integer     function  error number            Are error numbers supported      return CI DB sybase driver  GetCodeErrorSybase       function  sybase set message handler            Are error numbers supported           return sybase set message handler  CI DB sybase driver  msg handler        Implement in the function of a controller   public function Eliminar DUPLA               if  this- gt session- gt userdata  this- gt config- gt item  mycfg session object name                                   Operacion Borrado Exitosa false           this- gt db- gt trans begin              this- gt db- gt  sybase set message handler      lt  lt  lt  lt  lt ------- Activar Manejador de errores de sybase          Dupla Eliminada  this- gt Mi Modelo- gt QUERY Eliminar Dupla  PARAMETROS                               if   Dupla Eliminada                this- gt db- gt trans commit                MostrarNotificacion  Se elimin   DUPLA exitosamente   OK  true                Operacion Borrado Exitosa true           else               Error    this- gt db- gt  error number      lt  lt  lt  lt ----- Obtengo el c  digo de error de sybase para personilzar mensaje al usuario                  this- gt db- gt trans rollback                                MostrarNotificacion  Ocurrio un error al intentar eliminar Dupla   Error  true               if   Error    547                    MostrarNotificacion   lt strong gt C  digo de error      Error     No se puede eliminar documento Padre  lt  strong gt    Error  true                  else                                      MostrarNotificacion   lt strong gt C  digo de Error      Error    lt  strong gt  lt br gt    Error  true                                                     echo     Obtener Contador Notificaciones            if   Operacion Borrado Exitosa               echo   T            else              echo   F                  else          redirect  this- gt router- gt default controller              In the log you can check the codes and messages sent by the database server   INFO - 2019-11-06 19 26 33 - gt  CI DB sybase driver - CODE ERROR  547  Message - Dependent foreign key constraint violation in a referential integrity constraint  dbname    database   table name    mitabla   constraint name    FK SR RELAC REFERENCE SR mitabla   INFO - 2019-11-06 19 26 33 - gt  CI DB sybase driver - CODE ERROR  3621  Message - Command has been aborted  ERROR - 2019-11-06 19 26 33 - gt  Query error  - Invalid query  delete from mitabla where ID   1019

User · Answer

Use it       this- gt db- gt  error message       It is better for finding error After completing your site  Close the error messages  using it       db  default    db debug     FALSE    You will change it in your config folder s database php

User · Answer

an example that worked for me    query    some buggy sql statement     this- gt db- gt db debug   false   if    this- gt db- gt query  query          error    this- gt db- gt error           do something in error case  else         do something in success case         Best

User · Answer

Disable debugging of errors        data user    this- gt getDataUser         id user      this- gt getId user          this- gt db- gt db debug   false       this- gt db- gt where   id    gt   id user         res    this- gt db- gt update self   table   data user  user          if   res                 error    this- gt db- gt error            return  error            return array  error  code    amp   error  message             else               return 1

User · Answer

Maybe this    db debug    this- gt db- gt db debug    save setting   this- gt db- gt db debug   FALSE    disable debugging for queries   result    this- gt db- gt query  sql     run query    check for errors  etc   this- gt db- gt db debug    db debug    restore setting

[php] CodeIgniter - how to catch DB errors?

Examples related to php

Examples related to codeigniter