I built a web page to retrieve data from mysql database using php, all is fine. But I want to know when any data being updated, the web page will show the change via different color. It seems PHP is hard to do it.
-
-
You want to change the color of cells when the data that they represent has been updated? You need to have a way to determine when a data item has been updated. That means you need metadata. You could:
- Place a flag on the items when they are updated that is cleared when they are viewed (this would only apply to a single user, though), or
- Store the time that the user last viewed the items, save the time that items were last updated on the items, and compare these values.
Let us know what you come up with.
Comment