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

6 votes245 views2 answers
Compare two arrays and return the difference php
PHP
1 vote187 views1 answer
Operador in laravel
PHP
0 vote141 views1 answer
Laravel 8 mail attach multiple files
PHP
0 vote196 views1 answer
Lumen framework promise
PHP
21 votes188 views2 answers
Run a php site
PHP
1 vote240 views2 answers
Php number format 2 decimal no comma
PHP
0 vote189 views1 answer
Use s3 storage laravel
PHP
0 vote198 views1 answer
Laravel Testing send raw data in GET method
PHP
0 vote438 views1 answer
Envoyer mail php depuis localhost
PHP
0 vote168 views1 answer
Php getgmail name
PHP