# CakePHP 3.x update multiple rows

**URL:** <https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316>\
**Category:** Need Help\
**Created:** [May 17, 2018, 2:56pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316 "2018-05-17T14:56:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mben](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/mben/32/1099_2.png) [@mben](https://discourse.cakephp.org/u/mben)\
**Post date:** [May 17, 2018, 2:56pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316/1 "2018-05-17T14:56:43Z")

</div>

have a table AssetsAssignations, with hundreds of rows. In some cases, the user needs to select many rows with a checkbox, and change the “status” for all of them together.

In my controller, I have this function

> public function editMultiple()  
> {  
> $assetStatuses = $this-\>AssetsAssignations-\>AssetStatuses-\>find(‘list’);  
> $this-\>paginate = [  
> ‘contain’ =\> [‘Assets’, ‘AssetStatuses’, ‘Clients’, ‘Rooms’],  
> ‘sortWhitelist’ =\> [  
> ‘Assets.model\_number’,  
> ‘Assets.serial\_number’,  
> ‘AssetStatuses.name’,  
> ‘Clients.last\_name’,  
> ‘Rooms.name’,  
> ]  
> ];

```
$assetsAssignations = $this->request->data;

$assetsAssignations_ids = array();

foreach($assetsAssignations as $a){
    $assetsAssignations_ids[$a['id']] = $a['id'];
    $this->AssetsAssignations->updateAll(

        array('AssetAssignation.id' => $assetsAssignations_ids)
    );
    $this->Session->setFlash(__('Statsus is updated for the selcted entries!'));
}            
debug($assetsAssignations);

$query = $this->AssetsAssignations->find()
    ->contain(['Assets', 'AssetStatuses', 'Clients', 'Rooms']);
$filter = $this->Filter->prg($query);
$assetsAssignations = $this->paginate($filter, ['maxLimit' => 10000, 'limit' => 10000]);        

$this->set(compact('assetsAssignations', 'assetStatuses'));
$this->set('_serialize', ['assetsAssignations']);

```

}

In my edit\_multiple.ctp, I use a javascript to filter the data. And I put this code:

> ```
> <thead>
> <tr>
> <th>Select</th><th>Model Number</th><th>Serial Number</th><th>Room</th><th>Client</th><th>Status</th>
> </tr>
> </thead>
> </thead>
> <?php foreach ($assetsAssignations as $assetsAssignation): ?>
> <tr>
> <td><input name="data[AssetsAssignations][id][]" value="<?= $assetsAssignation->id ?>" id="AssetsAssignationsId1" type="checkbox"></td>
> <td><?= $assetsAssignation->has('asset') ? $assetsAssignation->asset->model_number : '' ?></td>
> <td><?= $assetsAssignation->has('asset') ? $assetsAssignation->asset->serial_number : '' ?></td>
> <td><?= $assetsAssignation->has('room') ? $assetsAssignation->room->name : '' ?></td>
> <td><?= $assetsAssignation->has('client') ? $assetsAssignation->client->last_name . ', ' . $assetsAssignation->client->first_name: '' ?></td>
> <td><?= $assetsAssignation->has('asset_status') ? $assetsAssignation->asset_status->name : '' ?></td>
> </tr>
> <?php endforeach; ?>
> </table>
> <legend><?= __('') ?></legend>
> </div>
> <?= $this->Form->create($assetsAssignation) ?>
> <fieldset>
> <div class="row">
> <div class="col-xs-3"><?= $this->Form->input('asset_status_id', ['options' => $assetStatuses, 'empty' => true, 'label' => __('Change Status To')]) ?></div>
> </div>
> </fieldset>
> <?= $this->Form->button(__('Submit')) ?>
> <?= $this->Form->end() ?>
> 
> ```
> 
> When I debug the result, checking 3 entries, I get this:
> 
> > [  
> > ‘data’ =\> [  
> > ‘AssetsAssignations’ =\> [  
> > ‘id’ =\> [  
> > (int) 0 =\> ‘411’,  
> > (int) 1 =\> ‘413’,  
> > (int) 2 =\> ‘415’  
> > ]  
> > ]  
> > ],  
> > ‘asset\_status\_id’ =\> ‘3’  
> > ]
> 
> My question is: How to pass the selected row IDs to the “Submit” button after selecting the checkboxes ?
> 
> Thanks in advance.

---

<div class="post-metadata">

**Author:** ![jarekgol](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jarekgol](https://discourse.cakephp.org/u/jarekgol)\
**Post date:** [May 17, 2018, 5:33pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316/2 "2018-05-17T17:33:36Z")

</div>

Adding hidden fields with name according to scheme and value= “id” help for me with “passing” to submit.  
If I’m right your code works, but you want get it better/faster?  
Think of transactional and atomic-\>false or get updateAll,Flash outside foreach, but i’m not familiar with updateAll().

---

<div class="post-metadata">

**Author:** ![mben](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/mben/32/1099_2.png) [@mben](https://discourse.cakephp.org/u/mben)\
**Post date:** [May 17, 2018, 5:47pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316/3 "2018-05-17T17:47:51Z")

</div>

thanks @jarekgol . Sure, I’m interested in using the best/faster way.  
Can you suggest the changes to do in my code, or refer me to an example near to my case ?

---

<div class="post-metadata">

**Author:** ![mben](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/mben/32/1099_2.png) [@mben](https://discourse.cakephp.org/u/mben)\
**Post date:** [May 17, 2018, 6:48pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316/4 "2018-05-17T18:48:24Z")

</div>

I was reading and trying to use the code about transactional here:  
[https://book.cakephp.org/3.0/en/orm/saving-data.html](https://book.cakephp.org/3.0/en/orm/saving-data.html)  
but I failed to adapt to my need.  
Basically, this what I put:

```
  $assetsAssignations_ids = array();
  $connection = ConnectionManager::get('default');
  $assetsAssignations = $connection->transactional(function () use ($assetsAssignations, $entities) {
        foreach ($entities as $entity) {
            
            $assetsAssignations->save($entity, ['atomic' => false]);
        }
    });

```

I got three notices:

> Notice (8): Undefined variable: assetsAssignations [APP/Controller\AssetsAssignationsController.php, line 241]  
> Notice (8): Undefined variable: entities [APP/Controller\AssetsAssignationsController.php, line 241]  
> Warning (2): Invalid argument supplied for foreach() [APP/Controller\AssetsAssignationsController.php, line 242]

I dont understant where and how I should get the selected ID’s.  
I would appreciate if you can help more, @jarekgol.

---

<div class="post-metadata">

**Author:** ![jarekgol](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jarekgol](https://discourse.cakephp.org/u/jarekgol)\
**Post date:** [May 17, 2018, 7:18pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316/5 "2018-05-17T19:18:47Z")

</div>

for save() you must have ‘entity’ first. So official way is to load them from DB, change desired values (in foreach) or run patchEntity/patchEntities if you got proper structure of post (submited) data, and then save like you do.

Anyway you can try adapt this [https://book.cakephp.org/3.0/en/orm/database-basics.html#Cake\Database\Connection::transactional](https://book.cakephp.org/3.0/en/orm/database-basics.html#Cake%5CDatabase%5CConnection::transactional)  
in foreach inside transactional function for your UPDATE purpouse.  
Please note, that this don’t use ‘save()’ but almost direct UPDATE SQL statement, but with protection against injections = ? , [data]

---

<div class="post-metadata">

**Author:** ![mben](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/mben/32/1099_2.png) [@mben](https://discourse.cakephp.org/u/mben)\
**Post date:** [May 18, 2018, 2:51pm UTC](https://discourse.cakephp.org/t/cakephp-3-x-update-multiple-rows/4316/6 "2018-05-18T14:51:15Z")

</div>

I read the documentation, but I failed to configure it. The issue comes in 2 things:  
1- how to pass the selected asset\_status\_id to the controller ? for this, I wrote:

> if ($this-\>request-\>is([‘patch’, ‘post’, ‘put’])) {  
> $asset\_status\_id = $this-\>request-\>data(‘asset\_status\_id’);  
> }

and in the view:

> \<?= $this-\>Form-\>input('asset\_status\_id', ['options' =\> $assetStatuses, 'empty' =\> true, 'label' =\> \_\_('Change Status To')]) ?\>

2- how to pass the id of the selected rows (selected with checbox) ?  
I used:

> if ($this-\>request-\>is([‘patch’, ‘post’, ‘put’])) {  
> $ids = $this-\>request-\>data(‘AssetsAssignations.id’);  
> }

in the view:

> \< input name=“data[AssetsAssignations][id]” value=“\<?= $assetsAssignation-\>id ?\>” id=“AssetsAssignationsId1” type=“checkbox”\>