How can I tell when a mySQLi table was last updated?

Question

I've seen the mySQL example here:How can I tell when a MySQL table was last updated?

But it's not working in mySQLi. I have this function to return the last time a specific table was updated (I am connected via another function that produces $conn), but it's not working. I want to run the function and return a date and time text. Any help is greatly appreciated!

My code:

function getDatabaseUpdateTimes($conn,$databaseName,$tableName){
    mysqli_select_db($conn,$databaseName);
    $query = "SELECT UPDATE_TIME 
        FROM   information_schema.tables
        WHERE  TABLE_SCHEMA = '$databaseName'
          AND  TABLE_NAME = '$tableName'";
    $updateTime=mysqli_query($conn, $query);  
    return $updateTime;
}

This only works for MyISAM engine. I prefer to use triggers!! — Meysam Valueian, Jun 04 '16 at 22:29
@splash58 not sure the link is helping me much... any explanation why you linked it? — Alex, Jun 05 '16 at 04:18
this is incorrect `$updateTime=mysqli_query($conn, $query);` should be as: `$result=mysqli_query($conn, $query); $row = mysqli_fetch_assoc($result); $updateTime = $row['UPDATE_TIME'];` — splash58, Jun 05 '16 at 07:02

score 1 · Accepted Answer · answered Jun 06 '16 at 03:30

Thanks @splash58 for the fix.

Final code:

function getTableUpdateTimes($conn,$databaseName,$tableName){
    mysqli_select_db($conn,$databaseName);
    $query = "SELECT UPDATE_TIME 
        FROM   information_schema.tables
        WHERE  TABLE_SCHEMA = '$databaseName'
          AND  TABLE_NAME = '$tableName'";
    $result=mysqli_query($conn, $query); 
    $row = mysqli_fetch_assoc($result); 
    $updateTime = $row['UPDATE_TIME'];
    return $updateTime;
}

How can I tell when a mySQLi table was last updated?

1 Answers1