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

4 votes151 views3 answers
Laravel migration index
PHP
0 vote164 views1 answer
How to set application key in lumen
PHP
0 vote184 views1 answer
Make() laravel
PHP Laravel
0 vote180 views1 answer
Wordpress remove current post in sidebar php
PHP Wordpress
0 vote151 views1 answer
Php How do you remove an array element in a foreach loop?
PHP
0 vote241 views4 answers
Form::select laravel
PHP Laravel
1 vote176 views1 answer
Php salto de linea
PHP
52 votes145 views6 answers
Foreach in php
PHP
6 votes134 views1 answer
Change website address wordpress
PHP
13 votes174 views5 answers
Console.log in php
PHP