You could generate a multiple insert query like that:
INSERT INTO 'some_table'(field1, field2) VALUES
('value1', 'value2'),
('value3', 'value3'), (...)
And execute it by $this->SomeModel->query();
cheers!
On Jul 26, 4:21 pm, Femi Taiwo <[EMAIL PROTECTED]> wrote:
> Hi,
> Question Summary: Is there a way to insert multiple rows into just one
> table without using a for...loop or something similar?
>
> I need to insert about several new rows into a table.
> By using a loop I use something similar to what I've written below
>
> <code>
> <?php
> .....
> foreach($largeData as $currentData){
>
> $this->Classperiod->create($currentData);
> $this->Classperiod->save($currentData);}
>
> .......
> ?>
> </code>
> Is there a better way? When I need to insert say 100 rows, that could
> really cause a overhead since it will probably run 100rows x 2 queries
> to do that. Any ideas?
>
> Thanks
>
> Femi T
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
