Michael Grigsby Michael Grigsby - 2 months ago 17
MySQL Question

How to test if Ci successfully inserted data

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')");
}

Answer

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;