Need to show last time updated data on site
I need to shoe on my website date and time when is data last time updated. Does anybody know where to fin开发者_如何学JAVAd any good looking javascript code for this ?
proof of concept
- your
DB
table should have a column like this:last_update TIMESTAMP(8),
- retrieve the last updated row with
SELECT * FROM table ORDER BY last_update DESC LIMIT 1
- make an
AJAX
request usignJavascript
( maybe using jQuery) and display it,
for that you have to keep tracking your files when it would updates or store datetime in database. not other way to track.
精彩评论