Database connection failure
Hi guys, To connect to a database, I have 2 hostnames which can be connected to. Both of them carry the same data. Basically they're used to balance the load. I can set the data source to any one of them. I'm able to do that. However, my problem is that, in case any of the hosts go down, I should be able to connect immediately to the other one. I mean how do I overload the app_model.php in such a way, that I should know immediately that the connection didn't get established, and I should connect to the other host. Can anybody help me with this? 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Issue with getNumRows
Well I agree it might not be a bug, however, I really don't understand the
need to have execute a find('count) function again to fetch the total number
of rows. I'm not getting into pagination coz I've already built something
and don't have the time now to move on to the cake pagination. I just wanted
to know if there's another function just like getNumRows() which could
provide me with the total rows selected for that particular where clause.
regards,
Rishab
On Tue, May 3, 2011 at 10:47 AM, ShadowCross wrote:
> This isn't a CakePHP bug. The Model::getNumRows() function returns the
> number of rows returned in the last query. Since you are using the
> limit clause, the number of rows in the query is less than or equal to
> the limit (10 rows in your example). To get the actual number of rows
> that could be returned based on your conditions, you should execute
> find('count') without the limit clause.
>
> CakePHP's built-in pagination automates this for you, and provides
> additional functionality. Is there a reason you need to implement
> your own pagination?
>
> On May 2, 12:52 pm, jairis...@gmail.com wrote:
> > Nobody has any idea about this?
> >
> > Rishab
> > Sent from BlackBerry® on Airtel
> >
> >
> >
> > -Original Message-
> > From: jairis...@gmail.com
> > Date: Mon, 2 May 2011 14:41:24
> > To: cake-php
> >
> > Reply-To: jairis...@gmail.com
> > Subject: Issue with getNumRows
> >
> > Hi all,
> >
> > I am working on my own pagination in my setup. It works on 3 variables:
> > 1. Page no requested.
> > 2. Number of records to be shown on each page
> > 3. Total records for that particular where condition.
> >
> > Now, the first point is taken runtime. The second point is pre-decided.
> The third point is what I use getNumRow() function. The problem is the
> number this function returns.
> >
> > For eg, if there are 40 records on result of any where condition. And we
> show 10 rows per page. Then, on page one the limit clause will be 0,10. For
> page 2, it will be 10,10. And 20,10 and 30,10 for the rest. But, to
> calculate this I need to execute the getNumRows() function on each request.
> But when I do that, I get 10 as the result of that function. Though, the
> expected result which normally mysql returns for SQL_CALC_FOUND_ROWS is
> '40'.
> >
> > Can anybody help me fixing this cakephp bug?
> >
> > Rishab
> > Sent from BlackBerry® on Airtel
>
> --
> 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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
How to use a function of a controller from another controller
Hi all,
There's a controller:
class PhotosController extends AppController {
var $name = 'Photos';
function index()
{
// I need to call the method getAllUsers() of the Users
Controller here.
}
}
And, there's another controller.
class UsersController extends AppController {
var $name = 'Users';
function index()
{
}
function getAllUsers($userid)
{
// get the array for all the users from the database
and return the same.
}
}
===
Can anybody tell me how can this be done. I tried searching on the
internet, where people say that there are 2 ways of doing this.
===
1. App::import('Controller', 'Posts');
class CommentsController extends AppController {
//Instantiation
$Posts = new PostsController;
//Load model, components...
$Posts->constructClasses();
function index($passArray = array(1,2,3)) {
//Call a method from PostsController with parameter
$Posts->doSomething($passArray);
}
}
===
2. Making it a model.
===
I get an error trying the first alternative. And I dont want to make
the function in the model. Let me know how can we do this.
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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: thumbnail generator
Thanks everyone. I tried the video suggested by Chris, and it worked ! Thanks again Rishab On 4/9/11, Chris wrote: > This video on cake TV worked for me fyi. I tried just about every > single image upload I could find. This tutorial is the only one I > found that worked perfectly for me without too much effort > (disclaimer: I'm am still very much a beginner so that is probably why > those other's never worked for me) > > http://tv.cakephp.org/video/jasonwydro/2011/01/29/cakephp_1_3_-_meio_image_upload_resize_gallery_tutorial > > On Apr 8, 10:51 pm, "Krissy Masters" > wrote: >> I usually resize the uploaded file to a manageable size but no crop, full >> image so the user never loses anything, Then allow them to crop the part >> they want which crates 2 images used in the site, the thumb and the large >> size image. In total upload 1 but end up with 3 (original version of >> uploaded file, 1 thumb and 1 "large" for use on the site) >> >> Also as cricket mentions all data is saved to the db, (name x,y,w,h) >> >> Just to give you an idea but every case is different and may require >> different sizes, number of version, and there are plenty of options on >> things you can do with images dynamically thru functions. >> >> K >> >> >> >> >> >> >> >> -Original Message- >> From: cake-php@googlegroups.com [mailto:cake-php@googlegroups.com] On >> Behalf >> >> Of cricket >> Sent: Friday, April 08, 2011 11:38 PM >> To: cake-php@googlegroups.com >> Subject: Re: thumbnail generator >> >> On Fri, Apr 8, 2011 at 9:47 PM, Krissy Masters >> wrote: >> > I would say on upload you make the sizes needed once. Why constantly >> resize >> > for each page load or on initial view / load check to see if its been >> > created if not create it. But as for performance I have no proof to say >> > which is better. >> >> I agree with you both. Libs like phpThumb do offer caching but I I >> usually offer to let the user crop the thumb themselves, so it may not >> be a reduced version of the image but offset, as well. Also, I >> normally save the thumbnail info in the DB anyway. >> >> -- >> Our newest site for the community: CakePHP Video >> Tutorialshttp://tv.cakephp.org >> Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help >> others with their CakePHP related questions. >> >> To unsubscribe from this group, send email to >> cake-php+unsubscr...@googlegroups.com For more options, visit this group >> athttp://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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
thumbnail generator
Hi, I tried so many thumbnail generators available over internet. But none of them proved to be of a good quality. I need a thumbnail generator which I can use to generate 2 separate copies the image uploaded of 2 different sizes. Has someone used any generator in cakephp? 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: check for the users who are logged in
@Ravi: Could u please tell me the changes we need to make in core.php? regards, Rishab On Fri, Apr 1, 2011 at 3:47 PM, Ravi Verma wrote: > Hi Jeremy, > > CakePHP takes care of it. they updates the session table on each refresh of > the page by user and if there is long delay in session updation, cakephp > considers it a non-authentic and removes it. So you do not need to worry > about it. > > Let me know if I'm wrong in any point. > > Thanks, > Ravi Verma > > On Fri, Apr 1, 2011 at 3:38 PM, Jeremy Burns | Class Outfit < > jeremybu...@classoutfit.com> wrote: > >> Not true as it doesn't remove users who just navigate away. This is an >> inexact science at best. >> >> Jeremy Burns >> *Class Outfit* >> * >> * >> jeremybu...@classoutfit.com >> http://www.classoutfit.com >> >> On 1 Apr 2011, at 11:03, Ravi Verma wrote: >> >> Hi Rishab, >> >> You just need to make changes in the core.php file to keep the sessions in >> database. In this regard you will be able to count and display, which user >> is currently logged in. >> >> >> >> >> On Fri, Apr 1, 2011 at 12:13 AM, cricket wrote: >> >>> On Thu, Mar 31, 2011 at 1:03 PM, Rishab Jain >>> wrote: >>> > Hi, >>> > >>> > Since cake is taking care of the session, I want to know who all >>> members of >>> > the site are currently logged in. >>> > >>> > Has anybody ever written code something similar to this? It would be >>> great >>> > if you could help me here. >>> >>> Rishab, have a look at this recent thread: >>> >>> http://groups.google.com/group/cake-php/browse_thread/thread/fda520971695ce5d >>> >>> -- >>> 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+unsubscr...@googlegroups.com For more options, visit this group >>> at http://groups.google.com/group/cake-php >>> >> >> >> >> -- >> Thanks & Regards >> = >> Ravi Verma >> Software Engineer >> >> -- >> 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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group >> at http://groups.google.com/group/cake-php >> > > > > -- > Thanks & Regards > = > Ravi Verma > Software Engineer > > -- > 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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: multiple file upload in php
Hi,
This works fine when I created a non-cakephp based setup. However, when I
try to use it in a cake based setup, it gives me an error. After almost an
hour of debugging, I saw that the problem lies in,
$('#file_upload').uploadify({
'uploader' : 'path_to_uploadifyswf/uploadify.swf',
'script': 'http://dev.mydomain.com/multiupload/',
'cancelImg' : 'pathtoimages/cancel.png',
'folder': 'uploaded_files',
'multi' : true,
Here, when I give the script URL to be of an action of a controller, it
gives me a 302 Error. However, when I change it to
'script': '
http://dev.mydomain.com/non_cake_based_setup/multiupload.php',
It works then.
Really have no idea about this behaviour. Anybody having any idea here?
regards,
Rishab
On Thu, Mar 31, 2011 at 1:19 PM, Ravi wrote:
> Hi Rishab,
>
> You can use Uploadify (http://www.uploadify.com/). This is a free
> flash uploading utility for PHP.
>
> And also it is quite easy to implement your own multiple file
> uploading functionality. Do let me know if you need instructions to
> implement your own functionality.
>
> Thanks,
> Ravi Verma
>
> On Mar 31, 12:46 pm, Rishab Jain wrote:
> > Hi,
> >
> > Does anybody know of a good multiple file upload in cakephp (or even php
> for
> > that matter). I'm not looking for many input tags for upload, but for an
> > interface where I can upload many files in one go.
> >
> > And it should be a freeware.
> >
> > 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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
check for the users who are logged in
Hi, Since cake is taking care of the session, I want to know who all members of the site are currently logged in. Has anybody ever written code something similar to this? It would be great if you could help me 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
implement comet in cakephp
Hi, Does anybody know how to implement comet in cakephp? 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: multiple file upload in php
Thanks Ravi. It worked. And implementing it was pretty easy as well. regards, Rishab On Thu, Mar 31, 2011 at 1:19 PM, Ravi wrote: > Hi Rishab, > > You can use Uploadify (http://www.uploadify.com/). This is a free > flash uploading utility for PHP. > > And also it is quite easy to implement your own multiple file > uploading functionality. Do let me know if you need instructions to > implement your own functionality. > > Thanks, > Ravi Verma > > On Mar 31, 12:46 pm, Rishab Jain wrote: > > Hi, > > > > Does anybody know of a good multiple file upload in cakephp (or even php > for > > that matter). I'm not looking for many input tags for upload, but for an > > interface where I can upload many files in one go. > > > > And it should be a freeware. > > > > 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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
multiple file upload in php
Hi, Does anybody know of a good multiple file upload in cakephp (or even php for that matter). I'm not looking for many input tags for upload, but for an interface where I can upload many files in one go. And it should be a freeware. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
session management
Hi All, I'm using the Auth for session management in cakephp. But I have no idea as to how to configure the timeout and other variables. Can someone help? 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
issues with document root and rewrite urls
Hi, I have a setup where I want the document root to set to the main directory where my application is residing. Currently, the path to my directory is something like this: /var/www/html/dev.mydomain.com/aaa/code_project/ app/ cake/ index.php plugins README vendors Now the point where all this started was when I was writing URLs for my navigation tabs. For eg, to access the tab 'inbox', I wanted to write the URL in the file to be was '/inbox/'. But when I did that, the URL actually pointed to http://dev.mydomain.com/inbox/. I guess that means my document root is not pointing to the code_project directory but to the dev.mydomain.com directory. I wrote the following line in the .htaccess file, RewriteEngine on RewriteRule^$ app/webroot/[L] RewriteRule(.*) app/webroot/$1 [L] # this line was added by me #DocumentRoot /var/www/html/dev.mydomain.com/aaa/bbb/code_project/app/webroot/ But, when I tried accessing the url, it gave me a 500 error. Can anybody help me gaining knowledge of how exactly this thing works and how to set it all up? Thanking you guys in advance and looking forward to some replies. 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
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 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
>
> jeremybu...@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` = 31 1 0
>> 7 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
>> `Message`.`id` = 31 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` = 31 1 0
>> 10 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
>> `Message`.`id` = 31 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+unsubscr...@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+unsubscr...@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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
issue with saving data in model
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` = 31 1 0
7 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
`Message`.`id` = 31 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` = 31 1 0
10 SELECT COUNT(*) AS `count` FROM `messages` AS `Message` WHERE
`Message`.`id` = 31 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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Need a 'video capturing through webcam' tool or code
Hi All, I need a "video capturing through webcam" plugin for cakephp. If not cake, then in simple php will also do. Does anybody know of such a plugin? 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Implementing social networking using CakePHP
Hi guys, I am planning to write a social networking website from the scratch. I wish to use CakePHP. Can anybody let me know the positives and negatives of using cakephp? Also, it would be great if anybody can provide me any information related to the development. or even the source code. Thanks 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
