How to keep history of record updates in MySQL?

Posted by Proxium on Stack Overflow See other posts from Stack Overflow or by Proxium
Published on 2010-03-29T09:16:08Z Indexed on 2010/03/29 9:33 UTC
Read the original article Hit count: 340

Filed under:
|
|
|

I have to create a code in PHP that will allow me to keep the history of record updates in MySQL database so I can find by date an old revision.

Here is the example of what I actualy want to achive: http://en.wikipedia.org/w/index.php?title=Tunisia&action=history

The data are mostly Numbers that we record about the company for generating reports and to extract indices.

I plan to use codeigniter for it's simplicity and I'm looking for idea about a framework or an opensource project that use the same approche to keep history of modifications in the database.

© Stack Overflow or respective owner

Related posts about php

Related posts about logging