$this->db->replace() using where [duplicate]

Question

I'm trying to find something along the lines of insert_or_update (similar to what Laravel offers) in CodeIgniter 3. The closest I have found is $this->db->replace(), but I can't find anything that specifies that it can/can't be used alongside a ->where(). Based on the docs I don't believe this will work since it doesn't list ->where() as an option, but I wanted to double check this as well.

I'm hoping I can do something like...

$data = [...];
$whereSearch = [...];
$this->db->replace($data)->where($whereSearch);

Antony · Accepted Answer · 2018-05-21 19:01:36Z

1

The key here to quote the documentation is

using PRIMARY and UNIQUE keys as the determining factor.

Replace only works based on your keys to replace the values in a table. You might find Does replace into have a where clause? helpful as well.

answered May 21, 2018 at 19:01

Antony

4,4421 gold badge34 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zeduke · Accepted Answer · 2018-05-22 14:09:58Z

0

$this->db->where('column_name',$compared_data); 
$this->db->set('column_name',$updated_data);
$this->db->update('table_name');

Would this be what you're looking for?

answered May 22, 2018 at 14:09

zeduke

1203 silver badges12 bronze badges

1 Comment

Jared Over a year ago

I don't believe so. I was wanting a single function call that would determine if an insert or an update should be performed. The replace() function seemed like an option that might work, but the data that I'm needing this for doesn't have the required keys in this instance.

Collectives™ on Stack Overflow

$this->db->replace() using where [duplicate]

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related