Codeigniter 3.1 - Get database error number

Question

I have a mysql Stored procedure that is called when a user should be deleted. Procedure signals an SQL state and throws error when someone tries to delete the row of Administrator Account. My Code in procedure is -

SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Adminstrator cannot be deleted';

I am using CodeIgniter 3.1. I want to catch this error message WITH its sql state in my code. I looked into following links but no help -

1) CodeIgniter - how to catch DB errors?

2) Database Error Handling problem in CodeIngniter

What I observed was that there was a method $this->db->_error_number(); that could be used to get error number/sql state, but this is deprecated in latest version.

I wanted to know is there any way in CodeIgniter to get the SQL State if the database error occurs?

Any help would be appreciated.

stackoverflow.com/questions/5209332/… | stackoverflow.com/questions/7843406/… — TheRealVira
– TheRealVira, Commented Oct 4, 2016 at 6:13

Josh Kelley · Accepted Answer · 2018-10-04 17:50:55Z

3

The function you mention has been deprecated:

Replaced the _error_message() and _error_number() methods with error() - which returns an array containing the last database error code and message."

https://www.codeigniter.com/userguide3/changelog.html?highlight=_error_number#version-3-0-0

See https://www.codeigniter.com/userguide3/database/queries.html#handling-errors for details.

edited Oct 4, 2018 at 17:50

Josh Kelley

58.7k22 gold badges166 silver badges259 bronze badges

answered Apr 19, 2017 at 1:42

TV-C-1-5

7342 gold badges13 silver badges19 bronze badges

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

1 Comment

tatskie Over a year ago

CI's error() is empty during SQLSTATE 45000. I don't understand this behavior. Looks like it only shows error generated by my MySQL but not coming from user-defined errors from stored procedures and triggers.

Collectives™ on Stack Overflow

Codeigniter 3.1 - Get database error number

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related