How to Update Multi Record

Question

How to Update Multi Record

hinonashi Jul '15

Created Jul '15	Last Reply Jul '15	Replies 1	Views 604	Votes 0

hinonashi 8.6k

Jul '15

$tableLeft  = new Nested(); 
// Update left
$dataLeft = $tableLeft->find("pleft > 2");
foreach($dataLeft as $row){ 
    if(!empty($row->pleft)){
        $pleft = $row->pleft + 2;
        $tableLeft->assign(array(
            'pleft' => $pleft,
        ));
    $tableLeft->save();
    }
}

Not work , my columns "pleft" not plus 2 . And nothing happened . I want update multi record with conditions ( "pleft" > 2 ) . and get current value record plus 2 and update it . So what i can do now ?

Andres Gutierrez · Answer 1 · 2015-07-28T09:07:01-07:00

Have you checked if any validation messages are being returned?

if ($tableLeft->save() === false) {
    foreach ($tableLeft->getMessages() as $message) {
       echo $message->getMessage();
    }
}