Search code examples
codeignitercodeigniter-2

Check number of affected rows in CodeIgniter

I am trying to check in my model method if there was affected any rows if so return true else return false, but I don't know how to get it?:

class User_model extends CI_Model {

    function __construct()
    {
        parent::__construct();
    }

    function save_new_user ($name, $email, $password)
    {
        $data = array(
            'name' => $name,
            'email' => $email,
            'password' => $password,
            'time' => time()
        );

        $this->db->insert('users', $data);

        // if (affected rows > 0) return true else return false
        if ([AFFECTED_ROWS] > 0) return true;
        else return false;
    }

}
Solution

  • The method you are looking for is $this->db->affected_rows().

    So your return statement could look like this:

    return $this->db->affected_rows() > 0;