JezK
Edit File: scratch_db_update2.php
<?php try { $pdo = new PDO("mysql:host=localhost;dbname=trust_software2;charset=utf8mb4", "root", ""); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $pdo->exec("ALTER TABLE sessions ADD COLUMN attendance ENUM('pending', 'present', 'absent') DEFAULT 'pending' AFTER status"); echo "SUCCESS: Added attendance to sessions.\n"; } catch(Exception $e) { if(strpos($e->getMessage(), 'Duplicate column name') !== false) { echo "SUCCESS: attendance column already exists.\n"; } else { echo "ERROR (sessions): " . $e->getMessage() . "\n"; } }