Friday, October 18, 2013

Re: INSERT, UPDATE, DELETE SQL queries on Cakephp into database



On Thursday, April 12, 2012 3:41:08 PM UTC-7, thom wrote:
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.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.

No comments: