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

4 votes107 views2 answers
Datetime blade laravel
PHP Laravel
23 votes90 views6 answers
Carbon datetime test online
PHP
0 vote112 views1 answer
Php ?? vs ?:
PHP
2 votes97 views4 answers
Laravel has many
PHP
0 vote104 views3 answers
Laravel public ParseError syntax error, unexpected '$conversion' (T_VARIABLE), expecting ',' or ')' /
PHP Laravel
30 votes111 views6 answers
Laravel migration column types
PHP Laravel
0 vote118 views1 answer
Disable wordpress editor - gutenberg on Post type post
PHP Wordpress
0 vote107 views1 answer
Php, Africa timezones
PHP
0 vote88 views1 answer
How to check if PHP variable contains non-numbers?
PHP
0 vote114 views1 answer
How to add script in WordPress admin page
PHP Wordpress