How can PHP be used to search for changes in timestamp fields across multiple tables in a database?

One way to search for changes in timestamp fields across multiple tables in a database using PHP is to query the tables, retrieve the timestamp fields, and compare them to identify any differences. This can be achieved by looping through the tables and timestamp fields, fetching the data, and then comparing the timestamps to detect changes. 

<?php

// Database connection
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Array to store changes
$changes = [];

// Array of tables to search
$tables = ['table1', 'table2', 'table3'];

foreach ($tables as $table) {
    $sql = "SELECT timestamp_field FROM $table";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            // Compare timestamps and store changes
            // For demonstration purposes, let's assume a change occurs if timestamp is not current date
            if ($row['timestamp_field'] != date('Y-m-d')) {
                $changes[] = "Change detected in $table";
            }
        }
    }
}

// Output changes
if (!empty($changes)) {
    foreach ($changes as $change) {
        echo $change . "<br>";
    }
} else {
    echo "No changes detected";
}

$conn->close();

?>

Keywords

PHP timestamp database search multiple tables

Related Questions