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

2 votes293 views1 answer
Php time format am pm
PHP
5 votes333 views3 answers
Enum table in laravel
PHP Laravel
2 votes294 views6 answers
Laravel 8 ui auth
PHP
0 vote358 views1 answer
Array foreach only show value in php
PHP
0 vote345 views1 answer
Laravel where and blade
PHP Laravel
0 vote379 views1 answer
Migrate only one table laravel
PHP
8 votes290 views3 answers
Check if includes numbers php
PHP
0 vote299 views1 answer
Get name of join by id php
PHP
0 vote314 views2 answers
Laravel return new tab
PHP Laravel
0 vote294 views1 answer
Jquery serialize php decode
PHP