/PHP/CodeIgniter/Codeigniter update or create

Codeigniter update or create

   $this->db->where('user_id',$id);
   $q = $this->db->get('profile');

   if ( $q->num_rows() > 0 ) 
   {
      $this->db->where('user_id',$id);
      $this->db->update('profile',$data);
   } else {
      $this->db->set('user_id', $id);
      $this->db->insert('profile',$data);
   }

Source: stackoverflow.com

Similar codes

0 vote214 views1 answer
Rand in codeigniter
PHP CodeIgniter
0 vote225 views1 answer
Return only one column data from table in codeigniter
PHP CodeIgniter
0 vote200 views1 answer
Confirm password in codeigniter
PHP CodeIgniter
0 vote202 views1 answer
Codeigniter sms send
PHP CodeIgniter
0 vote227 views2 answers
How to upload two files on same form different path in codeigniter
PHP CodeIgniter
0 vote241 views2 answers
How to insert last id from crud grocery codeigniter
PHP CodeIgniter
2 votes228 views2 answers
Route codeigniter
PHP CodeIgniter
0 vote239 views1 answer
Function id codeigniter 3
PHP CodeIgniter
0 vote208 views1 answer
Applying multiple order by in codeigniter
PHP CodeIgniter
0 vote197 views1 answer
Codeigniter update query return value
PHP CodeIgniter