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 vote201 views1 answer
Magento 1.9 print blank page error
PHP
3 votes205 views1 answer
Php encode url parameters
PHP
0 vote222 views1 answer
Iterating rows in php
PHP
39 votes183 views3 answers
Php get first 5 characters of string
PHP
0 vote173 views1 answer
Keep line breaks in textarea
PHP
7 votes187 views2 answers
Passport install
PHP
1 vote188 views3 answers
Unique check two clolumn in laravel validation
PHP
0 vote212 views2 answers
Laravel notification database
PHP Laravel
4 votes184 views5 answers
Php run command terminal
PHP
5 votes156 views3 answers
Enum table in laravel
PHP