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

0 vote200 views1 answer
Confirm password in codeigniter
PHP
9 votes156 views3 answers
Laravel with select
PHP Laravel
0 vote166 views1 answer
Php script auf serve alle 5 minuten ausführen
PHP
0 vote269 views1 answer
Show sender name laravel
PHP Laravel
1 vote151 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP
2 votes154 views3 answers
Php setinterval
PHP
0 vote164 views1 answer
Hiding the extension of website
PHP
0 vote159 views1 answer
Laravel where false
PHP Laravel
0 vote145 views1 answer
Php get hour
PHP
1 vote174 views2 answers
Where clause with paginate laravel multiple column
PHP Laravel