[FIXED] How to find query executed successfully or not?

Issue

im using codeigniter 2.0.2 and this is from its userguide

$data = array(
               'title' => $title,
               'name' => $name,
               'date' => $date
            );

$this->db->where('id', $id);
$this->db->update('mytable', $data); 

my question is once this executed how do you find its executed correctly or not?

Solution

The update function returns a value:

$result = $this->db->update('mytable', $data);

Check that value for either being TRUE (success) or FALSE (failure). update runs query internally and then returns the return value of query (Ref):

The query() function returns a database result object when "read" type queries are run, which you can use to show your results. When "write" type queries are run it simply returns TRUE or FALSE depending on success or failure.

Answered By - hakre

Answer Checked By - Clifford M. (PHPFixing Volunteer)