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

48 votes356 views6 answers
Create migration with model laravel
PHP Laravel
52 votes241 views3 answers
Str_replace php variable
PHP
0 vote272 views1 answer
What is the mixmam size that php can take
PHP
0 vote271 views1 answer
Default null migration laravel
PHP Laravel
10 votes262 views3 answers
How to get week start date in php
PHP
1 vote251 views1 answer
Forelse in laravel
PHP Laravel
4 votes283 views1 answer
Laravel install production
PHP Laravel
2 votes296 views1 answer
Laravel get only relationship
PHP Laravel
0 vote255 views2 answers
Laravel download file from s3
PHP
0 vote249 views1 answer
Get page name wp
PHP