There's a way to get which fields were modified after a update query?
I want to keep track what field XXX user modified... any ways using active records?
A:
solution
instructions:
SELECTrow, that user wants to modifyUPDATEit- Compute differences between selected and update it
- Store the differences somewhere (or mail it, show it, whatever)
simple
Adam Kiss
2010-03-03 21:41:08
But its a "edit page" using the original "add" form... so all fields are sent (via POST) by the view!
Roberto
2010-03-04 00:53:21
yes... and? when updating database in your module (or controller), you have new values at least in post array - with some id also. So first select by id, save to array. then update. and then just compare arrays - the one from `$_POST` and the second from `SELECT` - are we misunderstanding each other?
Adam Kiss
2010-03-04 07:50:37
i guess i got the ideia now.... Thank you very much ;)
Roberto
2010-03-08 17:27:44
A:
There is no way using active record to get this easily, but if you are only supporting one specific database type (let's say MySQL) you could always use Triggers?
Or, Adam is about right. If you have a WHERE criteria for your UPDATE you can SELECT it before you do the UPDATE then loop through the old and new versions comparing.
This is exactly the sort of work Triggers were created for, but of course that puts too much reliance on the DB which makes this less portable yada yada yada.
Phil Sturgeon
2010-03-04 08:58:11