phpmysqlcodeignitersql-insertignore

How to test if a CodeIgniter query containing INSERT IGNORE was successful?

In Ci, I've got the following function. How do I test that the query successfully inserted without error's?

public function postToWall() {
    $entryData = $this->input->post('entryData');
    $myChurchId  = $this->session->userdata("myChurchId");
    $this->db->query("INSERT IGNORE INTO wallPosts (entryData, entryCreationDateTime, wpChurchId)
                      VALUES('$entryData', NOW(), '$myChurchId')");
}
Solution

  • You can use $this->db->affected_rows() function of codeigniter.

    See more information here

    You can do something like this:

    return ($this->db->affected_rows() != 1) ? false : true;