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 vote311 views2 answers
Convert string to array laravel
PHP
0 vote285 views1 answer
Php curl async callback
PHP
0 vote305 views1 answer
PHP Resize
PHP
0 vote288 views3 answers
Caculator
PHP
0 vote287 views2 answers
Obtener rol de usuario registrado en WordPress
PHP
0 vote280 views1 answer
Composer_memory_limit
PHP
2 votes339 views1 answer
Magento 2 change customers password
PHP
0 vote297 views1 answer
Rest api response 404 wordpress
PHP
0 vote273 views1 answer
Magento 1.9 get all product
PHP
5 votes287 views2 answers
Php glue strings
PHP