Codeigniter select for update

$table = "my_table";
$id = 1;
$update = ["status"=>"working"];
//Edit just above /\ if you don't need extra "where" clause
$query = $this->db->select()
            ->from($table)
            ->where('id', $id)
            ->get_compiled_select();
$data = $this->db->query("$query FOR UPDATE")->row_array();
$this->db->where('id', $data['id'])->update($table,$update);

-1

Source: grepper.com

Similar codes

1 vote216 views1 answer
Php create url with query sting from array
PHP
14 votes234 views6 answers
Laravel Password Validation
PHP Laravel
15 votes233 views6 answers
Laravel db transaction
PHP Laravel
0 vote219 views1 answer
Laravel request protected prop
PHP
0 vote227 views1 answer
Php get refferal
PHP
48 votes250 views6 answers
Laravel joins
PHP
4 votes224 views2 answers
Php create object without class
PHP
23 votes221 views6 answers
Laravel select count
PHP Laravel
1 vote202 views2 answers
{{count laravel
PHP Laravel
8 votes219 views1 answer
Php number padding
PHP