How can database status be used to prevent multiple executions of a PHP script via Cronjob?

To prevent multiple executions of a PHP script via Cronjob, you can use a database status flag that indicates whether the script is currently running or not. Before the script starts, it checks this flag in the database. If the flag is set to indicate that the script is already running, the script should exit early to avoid duplicate executions. After the script finishes running, it should update the flag in the database to indicate that it has completed. 

// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Check the status flag in the database
$stmt = $pdo->prepare("SELECT status FROM script_status WHERE id = 1");
$stmt->execute();
$status = $stmt->fetchColumn();

// If the script is already running, exit
if ($status == 'running') {
    exit;
}

// Set the status flag to indicate that the script is running
$stmt = $pdo->prepare("UPDATE script_status SET status = 'running' WHERE id = 1");
$stmt->execute();

// Your script logic goes here

// Update the status flag to indicate that the script has completed
$stmt = $pdo->prepare("UPDATE script_status SET status = 'completed' WHERE id = 1");
$stmt->execute();

Keywords

PHP Cronjob database status prevent multiple executions

Related Questions