Codeigniter3: How to get error or success info from db->insert?

Question

I would like to get return info from $CI->db->insert(...), both on success and failure.

I have tried to simply catch the return and echo it and print_r it, but neither gives me anything useful; And I have tried $CI->db->display_errors() (though I did not actually find it listed at CI docs).

$return = $this->db->insert( "some_table" , $table_data ) ;

print_r( $return  ) ; // 
// OR
print  ( $this->db->display_errors() ) ;

Does $CI->db->insert(...) offer a way to check success/failure?

UPDATES:

in CI3 ...

$this->db->_error_message() generates an error: Fatal error: Call to undefined method CI_DB_mysqli_driver::_error_message() (with or without the leading underscore).

$this->db->display_errors() generates an error: Fatal error: Call to undefined method CI_DB_mysqli_driver::display_errors()

$this->db->insert_id() generates a 0 (regardless of whether the insert succeeds or fails)

use if ( $this->db->_error_message() ) echo $this->db->_error_message() ; — AldoZumaran
– AldoZumaran, Commented Mar 31, 2016 at 6:13
@AldoZumaran These methods have been removed in CodeIgniter version 3. — Pathik Vejani
– Pathik Vejani, Commented Mar 31, 2016 at 6:35

Fabulous · Accepted Answer · 2018-07-11 10:01:44Z

4

$this->db->_error_message() is deprecated so instead of that try use following function.

$error = $this->db->error();

edited Jul 11, 2018 at 10:01

Fabulous

2,4562 gold badges22 silver badges28 bronze badges

answered Jul 11, 2018 at 8:54

Krishna thakor

18512 bronze badges

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

Comments

dsdsdsdsd · Accepted Answer · 2016-03-31 13:49:12Z

There are two methods that give me meaningful info, though I haven't seen in the CI3 documentation that the info is definitive, thus I consider this a weak-ish solution:

A ...

$return = $this->db->insert( "some_table" , $lvl_data ) returns...

// on SUCCESS: 1 ......... which indicates the boolean TRUE, not the number 1
// on FAILURE: nothing ... which indicates the boolean FALSe

However, I do not know from the docs if this is definitively always ensured.

PLEASE NOTE: this will generate an uncatch-able formatted CI error message on failure, unless you use affect $this->db->db_debug ... see working example below for usage.

B ...

$this->db->error() returns...

// on SUCCESS: Array ( [code] => 0    [message] => ) 
// on FAILURE: Array ( [code] => 1054 [message] => Unknown column 'some_bad_column_name' in 'field list' )

However, I do not know for certain (based on CI3 doc) that [code]=>0 necessarily equals success.

A+B, with $this->db->db_debug ...

Thus I believe that combining these two infos is loosely indicative:

$db_debug           = $this->db->db_debug ; //save setting
$this->db->db_debug = FALSE               ; //disable debugging for queries

$return = $this->db->insert( "some_table" , $lvl_data ) ;
$error  = $this->db->error ()                           ;
if ( $error['code'] === 0  &&  $return === true )
  { // almost surely SUCCESS
  }

$this->db->db_debug = $db_debug           ; //set it back

Collectives™ on Stack Overflow

Codeigniter3: How to get error or success info from db->insert?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related