How can PHP beginners effectively use Audit Trail scripts in their projects?

Issue: PHP beginners can effectively use Audit Trail scripts in their projects by implementing a simple logging system that tracks changes made to data in the database. This can help track user actions, troubleshoot issues, and maintain data integrity. Code snippet: 

// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// Function to log changes
function logChanges($action, $data) {
    global $conn;
    $timestamp = date('Y-m-d H:i:s');
    $user = $_SESSION['username']; // Assuming user authentication is implemented
    $sql = "INSERT INTO audit_trail (action, data, user, timestamp) VALUES ('$action', '$data', '$user', '$timestamp')";
    $conn->query($sql);
}

// Example usage
$action = "Update";
$data = "Updated record with ID 123";
logChanges($action, $data);

Keywords

Audit Trail PHP beginners scripts projects usage

Related Questions