What are some best practices for updating timestamps in a database for user activity tracking in PHP?

When tracking user activity in a database, it is important to update timestamps to reflect the most recent activity. One best practice is to use the CURRENT_TIMESTAMP function in MySQL to automatically update the timestamp whenever a record is modified. This ensures that the timestamp accurately reflects the last time the record was updated. 

// Update user activity timestamp in database using MySQL CURRENT_TIMESTAMP function
$query = "UPDATE users SET last_activity = CURRENT_TIMESTAMP WHERE user_id = :user_id";
$stmt = $pdo->prepare($query);
$stmt->bindParam(':user_id', $user_id, PDO::PARAM_INT);
$stmt->execute();

Keywords

timestamps database user activity tracking PHP updating

Related Questions