<?php
// This is a simple script to update the database table
$hostname = 'localhost';
$database = 'constra_db';
$username = 'root';
$password = '';

try {
    $pdo = new PDO("mysql:host=$hostname;dbname=$database", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $sql = "ALTER TABLE attendance ADD COLUMN image_path VARCHAR(255) AFTER status";
    $pdo->exec($sql);
    echo "Column 'image_path' added successfully.";
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
