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 vote155 views1 answer
Php split large text on line breaks into array
PHP
0 vote168 views1 answer
Laravel latest from relationship
PHP
0 vote175 views1 answer
How to make a simple mail system in Laravel without view or notification
PHP
11 votes196 views3 answers
Laravel auth 6
PHP Laravel
2 votes176 views3 answers
With in laravel
PHP Laravel
0 vote148 views3 answers
Https://stackoverflow.com/questions/58589741/angular-8-hide-divs-and-show-div-on-button-click
PHP
0 vote172 views1 answer
Ile_put_contents(/opt/bitnami/apache2/htdocs/bootstrap/cache/services.php): failed to open stream: Permission denied
PHP
1 vote192 views1 answer
How to check the laravel version mac
PHP Laravel
0 vote160 views1 answer
Date between query in codeigniter
PHP
3 votes153 views2 answers
How to get time php with am/pm
PHP