Thursday, April 12, 2012

INSERT, UPDATE, DELETE SQL queries on Cakephp into database

Hello,, I'm using cakePHP 1.3. I'd like to ask about how to save sql queries on Insert, Update and Delete on CakePHP into logs-table. What I need is everytime user do an insert/ update/ delete, the sql is saved with another user informations into logs-table. I've been searching around and found https://github.com/alkemann/CakePHP-Assets. But seems its not supporting to attach the executed-query; just something like 'user_id change this to this'. 

I also found some links told me to override the default DboMysql::_excute() but the result is just like when I saved all cake's sql dump into log file.. For your information, I have a menu that I need to be checked their 'visibility' based on users access right. That means, beside the normal cakes 'select', there are also hundreds of sql log on checked the menu.

No, that's not what I want. I just want insert-update-delete queries. Naaa,, Is that a possible thing to do that? Is there any way to do it? Some clues will kinda helpful.

--
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

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home


Real Estate