Re: issue with saving data in model

Thanks Jeremy. It worked.

If possible, do feed in your 2 cents on how this worked.

regards,
Rishab

On 3/28/11, Jeremy Burns | Class Outfit <jeremyburns@classoutfit.com> wrote:
> Add $this->create(); to your loop before you do the save. If not, you are
> just updating the same record.
>
> Jeremy Burns
> Class Outfit
>
> jeremyburns@classoutfit.com
> http://www.classoutfit.com
>
> On 28 Mar 2011, at 16:21, Rishab Jain wrote:
>
>> Hi All,
>>
>> I'm facing a very weird problem. I'm trying to save data in a loop
>> where 1 person is sending msg to many people.. Here's the print_r of
>> the 3 arrays before I call the 'save' function in the model.
>>
>> Array
>> (
>> [Message] => Array
>> (
>> [sender_uid_fk_users] => 1
>> [subject] => hey
>> [body] => hey
>> [recipient_uid_fk_users] => 2
>> [date] => 2011:03:28 10:52:41
>> )
>>
>> )
>> Array
>> (
>> [Message] => Array
>> (
>> [sender_uid_fk_users] => 1
>> [subject] => hey
>> [body] => hey
>> [recipient_uid_fk_users] => 4
>> [date] => 2011:03:28 10:52:41
>> )
>>
>> )
>> Array
>> (
>> [Message] => Array
>> (
>> [sender_uid_fk_users] => 1
>> [subject] => hey
>> [body] => hey
>> [recipient_uid_fk_users] => 6
>> [date] => 2011:03:28 10:52:41
>> )
>>
>> )
>>
>> The only difference here is the different 'recipient_uid_fk_users' in
>> all the 3 arrays with values '2', '4', and, '6'.
>>
>> All I'm doing then is,
>> foreach(recipient...)
>> {
>> /// prepare $arrayMessagesInfo /////
>> $this->save($arrayMessagesInfo);
>> }
>>
>> The issue I'm facing is that only the first value gets inserted, and
>> the rest of the two queries becomes 'update' queries. I'm not even
>> mentioning the primary key in the array.
>>
>> These are the cakephp debugging logs:
>>
>> 4 INSERT INTO `messages` (`sender_uid_fk_users`, `subject`,
>> `body`, `recipient_uid_fk_users`, `date`) VALUES (1, 'hey', 'hey', 2,
>> '2011:03:28 10:48:33') 1 0
>> 5 SELECT LAST_INSERT_ID() AS insertID 1 1 0
>> 6 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
>> `Message`.`id` = 3 1 1 0
>> 7 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
>> `Message`.`id` = 3 1 1 0
>> 8 UPDATE `messages` SET `sender_uid_fk_users` = 1, `subject` =
>> 'hey', `body` = 'hey', `recipient_uid_fk_users` = 4, `date` =
>> '2011:03:28 10:48:33' WHERE `messages`.`id` = 3 1
>> 0
>> 9 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
>> `Message`.`id` = 3 1 1 0
>> 10 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
>> `Message`.`id` = 3 1 1 0
>> 11 UPDATE `messages` SET `sender_uid_fk_users` = 1, `subject` =
>> 'hey', `body` = 'hey', `recipient_uid_fk_users` = 6, `date` =
>> '2011:03:28 10:48:33' WHERE `messages`.`id` = 3
>>
>> Here's the table structure:
>> CREATE TABLE `messages` (
>> `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
>> `subject` varchar(100) NOT NULL,
>> `body` varchar(500) NOT NULL,
>> `sender_uid_fk_users` int(10) unsigned NOT NULL,
>> `date` datetime NOT NULL,
>> `recipient_uid_fk_users` int(10) unsigned NOT NULL,
>> PRIMARY KEY (`id`),
>> KEY `sender_uid_fk_users` (`sender_uid_fk_users`),
>> KEY `recipient_uid_fk_users` (`recipient_uid_fk_users`),
>> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
>>
>>
>> It would be great if anybody can help me out here.
>>
>> regards,
>> Rishab
>>
>> --
>> Our newest site for the community: CakePHP Video Tutorials
>> http://tv.cakephp.org
>> Check out the new CakePHP Questions site http://ask.cakephp.org and help
>> others with their CakePHP related questions.
>>
>>
>> To unsubscribe from this group, send email to
>> cake-php+unsubscribe@googlegroups.com For more options, visit this group
>> at http://groups.google.com/group/cake-php
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> cake-php+unsubscribe@googlegroups.com For more options, visit this group at
> http://groups.google.com/group/cake-php
>

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php