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 vote338 views1 answer
Checks whether the session is set or not, if not it will redirect the user to login page.
PHP
0 vote317 views1 answer
Flutter fetch database from mysql using php
PHP
0 vote332 views2 answers
Parse error: syntax error, unexpected 'if' (T_IF) in /opt/lampp/htdocs/testphp.php on line 30
PHP
4 votes370 views3 answers
Laravel execute command from terminal
PHP Laravel
7 votes397 views2 answers
Update url wordpress
PHP Wordpress
1 vote320 views1 answer
Laravel optional route parameter in middle of url
PHP
0 vote307 views1 answer
Laravel mix disable notifications
PHP
14 votes457 views3 answers
Enqueue wordpress
PHP Wordpress
1 vote286 views1 answer
Only variables should be passed by reference in
PHP
6 votes315 views2 answers
How to add extra days from a date php
PHP