Show last modified date from DB in PHP

[bettina]

Is there a way to show in PHP automatic the date when a DB was last
modified?

[Jacob Atzen]

On 2005-07-04, be*****@coaster.ch <be*****@coaster.ch> wrote:

Is there a way to show in PHP automatic the date when a DB was last
modified?

I don't know of any way to get a database to tell you when it was last
modified. You'll probably have to record the modification time manually.

--
Cheers,
- Jacob Atzen

[usenet]

On 4 Jul 2005 04:52:35 -0700, be*****@coaster.ch wrote:

Is there a way to show in PHP automatic the date when a DB was last
modified?

In MySQL, I've accomplished this by adding a timestamp field to the table and
sorting for the most recent value. In this case, it's called recupdated :

$query = "SELECT DATE_FORMAT(recupdated, '%M %e, %Y %l:%i %p') AS datemod ";
$query .= "FROM myTable ";
$query .= "ORDER BY recupdated DESC LIMIT 1;";

Then just echo datemod.

But I'd be curious to find out if anyone else has an alternative ? As a real
kludge, I suppose you could look at the file system modification time on the
..MYD or .MYI file. But that feels very wrong to me . . .

[Andy Hassall]

On 4 Jul 2005 04:52:35 -0700, be*****@coaster.ch wrote:

Is there a way to show in PHP automatic the date when a DB was last
modified?

You'll have to define what a "DB" is and what constitutes a modification. The
answer, in general, is no. It might be possible for specific databases. Most of
the time you will have to add datetime fields to the data or tables or whatever
you're monitoring and update them along with the other changes in some way.

--
Andy Hassall / <an**@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

[Mladen Gogala]

On Mon, 04 Jul 2005 04:52:35 -0700, bettina wrote:

Is there a way to show in PHP automatic the date when a DB was last
modified?

Most of the DB varieties usually have auditing facilities.

--
http://www.mgogala.com