you are probably looking for sth like this: http://bakery.cakephp.org/articles/alkemann/2008/10/21/logablebehavior
it is a behavior that can be attached to models in order to log the changes. Am Freitag, 13. April 2012 00:41:08 UTC+2 schrieb thom: > > 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. > > Thank you for any responses. > > -- > Regards,,, > thom > http://mynameisthom.blogspot.com > http://www.twitter.com/iamthom_ > http://id.linkedin.com/in/mastanto > > -- 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 [email protected] For more options, visit this group at http://groups.google.com/group/cake-php
