Insert multiple rows with one query in Symfony 1.4 and Doctrine

Question

I have collections of clients, and every collection can contain many clients. This PHP code loops collections, and clients inside every collection. And saves the client to the database.

foreach ($collections as $key => $collection) {
      foreach ($collection as $k => $client) {
                 $name = $client['name'];
                 //...
                 $clientObj = new Client();
                 $clientObj->setName($name);
                 //..
                 $clientObj->save();
      }
}

What I want to do, is to group every collection in one Mysql query, then go to the next collection. Because the previous code executes one query per client, And for performance, we need one query per collection.

How can we do that?

Thank you so much my dear for the reference , I'm gonna give it a try — SmootQ
– SmootQ, Commented Mar 25, 2015 at 10:20
Woow, thanks my dear, that works perfectly... You can add your comment as an answer, to make it best answer ! — SmootQ
– SmootQ, Commented Mar 25, 2015 at 10:30

Matteo · Accepted Answer · 2015-03-25 10:46:08Z

2

Add each record to a Doctrine_Collection the call save() on the collection object.

 * Saves all records of this collection and processes the 
 * difference of the last snapshot and the current data

As Example:

$collection = new Doctrine_Collection('client');
$collection->add($client1);
$collection->add($client2);
$collection->save();

answered Mar 25, 2015 at 10:46

Matteo

39.8k11 gold badges110 silver badges129 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert multiple rows with one query in Symfony 1.4 and Doctrine

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related