blocks|key|2979225|text|将每条记录添加到集合对象上的调用save()的Doctrine_Collection。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2979226|$collection+=+new+Doctrine_Collection('tablename');
$collection->add($record1);
$collection->add($record2);
$collection->add($record3);
$collection->add($record4);
$collection->save();|code-block|syntax|javascript|2979227|只有当所有记录都在同一个表中时，这才能起作用。否则你就不走运了。|2979228|entityMap|0|LINK|mutability|MUTABLE|url|http://www.doctrine-project.org/api/common/2.2/class-Doctrine.Common.Collections.Collection.html^0|G|6|N|J|N|J|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|13|8|@]|D|@]|E|$]]|$1|M|3|-4|5|6|7|14|8|@]|D|@]|E|$]]]|N|$O|$5|P|Q|R|E|$S|T]]]]

Add each record to a <a href="http://www.doctrine-project.org/api/common/2.2/class-Doctrine.Common.Collections.Collection.html" rel="noreferrer"><code>Doctrine_Collection</code></a> the call <code>save()</code> on the collection object.

<pre><code>$collection = new Doctrine_Collection('tablename');
$collection-&gt;add($record1);
$collection-&gt;add($record2);
$collection-&gt;add($record3);
$collection-&gt;add($record4);
$collection-&gt;save();
</code></pre>

This only works if all the records are for the same table. Otherwise you're out of luck.

blocks|key|3192880|text|这里是另一个解决方案，在Doctrine+1.2上进行了测试。不需要保存每条记录，flush()会自动找出所有未保存的实例并将它们全部保存。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3192881|$row+=+new+\My_Doctrine_Record();
$row->name+=+'aaa';
$row->approved+=+1;

///+...

$row+=+new+\My_Doctrine_Record();
$row->name+=+'val';
$row->approved+=+'bbb';

Doctrine_Manager::connection()->flush();|code-block|syntax|javascript|3192882|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here another solution ,tested on Doctrine 1.2. 
No need to save each records, the flush() automatically finds out all the unsaved instances and saves them all.

<pre><code>$row = new \My_Doctrine_Record();
$row-&gt;name = 'aaa';
$row-&gt;approved = 1;

/// ...

$row = new \My_Doctrine_Record();
$row-&gt;name = 'val';
$row-&gt;approved = 'bbb';

Doctrine_Manager::connection()-&gt;flush();
</code></pre>

blocks|key|274967|text|我看了一下Doctrine+(1.2.x)+"Collection.php“的”保存“方法的代码，我看到的是这样的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|274968|foreach+($this->getData()+as+$key+=>+$record)+{
+++$record->save($conn);
}|code-block|syntax|javascript|274969|如何使用一次mysql插入来插入所有记录？|274970|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I took a look into the code of the "save" method of the Doctrine (1.2.x) "Collection.php" and all I saw is something like this:

<pre><code>foreach ($this-&gt;getData() as $key =&gt; $record) {
 $record-&gt;save($conn);
}
</code></pre>

How should this ever insert all records with one mysql INSERT?

blocks|key|2979256|text|如果你使用symfony2，那就太简单了|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2979257|//+get+the+manager
$em+=+$this->getDoctrine()->getManager();

//+enter+the+records
$em->persist($entitiy1);
$em->persist($entitiy2);
$em->persist($entitiy3);
$em->persist($entitiy4);
$em->persist($entitiy5);

//+save+the+entries
$em->flush();|code-block|syntax|javascript|2979258|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If you use symfony2 it is so easy

<pre><code>// get the manager
$em = $this-&gt;getDoctrine()-&gt;getManager();

// enter the records
$em-&gt;persist($entitiy1);
$em-&gt;persist($entitiy2);
$em-&gt;persist($entitiy3);
$em-&gt;persist($entitiy4);
$em-&gt;persist($entitiy5);

// save the entries
$em-&gt;flush();
</code></pre>

blocks|key|278509|text|1)声明所有表。2)创建表单。3)发送到多个表。4)持久化数据。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|278510|use+AppBundle\Entity\site;
use+AppBundle\Entity\nba;|code-block|syntax|javascript|278511|1)声明所有表。|278512|+$site+=+new+site;
+$nba+=+new+nba;|278513|2)创建表单|278514|$form+=+$this->createFormBuilder($site)




++++->add('site_id',+IntegerType::class,+array('attr'+=>+array('class'+=>+'form-control',+'style'+=>+'margin-bottom:15px')))
++++->add('category',+ChoiceType::class,+array('attr'+=>+array('class'+=>+'form-control',+'style'+=>+'margin-bottom:15px'),+'choices'+=>+$output))
++++->add('team',+ChoiceType::class,+array('attr'+=>+array('class'+=>+'form-control',+'style'+=>+'margin-bottom:15px'),+'choices'+=>+$nbat))
++++->add('save',+SubmitType::class,+array('label'+=>+"Create",'attr'+=>+array('class'+=>+'btn+btn-success',+'style'+=>+'margin-bottom:15px')))
++++->getForm();
++++$form->handleRequest($request);
++++if($form->isSubmitted()+&&+$form->isValid())|278515|3)插入多个表。|278516|++++{

++++++++$site_id+=+$form['site_id']->getData();
++++++++$category+=+$form['category']->getData();
++++++++$team+=+$form['team']->getData();




++++++++$site->setSiteId($site_id);
++++++++$site->setCategory($category);
++++++++$nba->setWinner($team);|278517|4)持久化数据|278518|++++++++++++$em+=+$this->getDoctrine()->getManager();
++++++++++++$em->persist($site);
++++++++++++$em->persist($nba);
++++++++++++$em->flush();|278519|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|14|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|16|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|17|8|@]|9|@]|A|$E|F]]|$1|W|3|-4|5|6|7|18|8|@]|9|@]|A|$]]]|X|$]]

1)Declare all the tables.
2)Create the form.
3)Send to multiple tables.
4)Persist data.

<pre><code>use AppBundle\Entity\site;
use AppBundle\Entity\nba;
</code></pre>

1)Declare all the tables.

<pre><code> $site = new site;
 $nba = new nba;
</code></pre>

2)Create form

<pre><code>$form = $this-&gt;createFormBuilder($site)




 -&gt;add('site_id', IntegerType::class, array('attr' =&gt; array('class' =&gt; 'form-control', 'style' =&gt; 'margin-bottom:15px')))
 -&gt;add('category', ChoiceType::class, array('attr' =&gt; array('class' =&gt; 'form-control', 'style' =&gt; 'margin-bottom:15px'), 'choices' =&gt; $output))
 -&gt;add('team', ChoiceType::class, array('attr' =&gt; array('class' =&gt; 'form-control', 'style' =&gt; 'margin-bottom:15px'), 'choices' =&gt; $nbat))
 -&gt;add('save', SubmitType::class, array('label' =&gt; "Create",'attr' =&gt; array('class' =&gt; 'btn btn-success', 'style' =&gt; 'margin-bottom:15px')))
 -&gt;getForm();
 $form-&gt;handleRequest($request);
 if($form-&gt;isSubmitted() &amp;&amp; $form-&gt;isValid())
</code></pre>

3)Insert into multiple tables.

<pre><code> {

 $site_id = $form['site_id']-&gt;getData();
 $category = $form['category']-&gt;getData();
 $team = $form['team']-&gt;getData();




 $site-&gt;setSiteId($site_id);
 $site-&gt;setCategory($category);
 $nba-&gt;setWinner($team);
</code></pre>

4)Persist data

<pre><code> $em = $this-&gt;getDoctrine()-&gt;getManager();
 $em-&gt;persist($site);
 $em-&gt;persist($nba);
 $em-&gt;flush();
</code></pre>

How do I insert multiple rows into table calling <code>save()</code> method once in Doctrine?

Doctrine - insert multiple rows with just one save()

如何在Doctrine中一次性调用save()方法将多行插入到表中

问原理-只用一次save()插入多行
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问原理-只用一次save()插入多行EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问原理-只用一次save()插入多行
EN