Error: Could not connect to database. Check config/db.php path."); }
echo "Checking Database & Fixing Columns...
";
// --- LIST OF COLUMNS TO ADD ---
$columns = [
"site_title VARCHAR(100) DEFAULT 'SejiStore'",
"favicon VARCHAR(255) DEFAULT ''",
"meta_title VARCHAR(255) DEFAULT ''",
"meta_description TEXT",
"meta_keywords TEXT",
"hero_title TEXT",
"hero_subtitle TEXT",
"footer_text TEXT",
"razorpay_key VARCHAR(100)",
"razorpay_secret VARCHAR(100)",
"contact_email VARCHAR(100)",
"whatsapp_number VARCHAR(20)",
"founder_name VARCHAR(100)",
"founder_image VARCHAR(255)"
];
// --- EXECUTE UPDATE ---
foreach ($columns as $col) {
// Extract column name for display
$colName = explode(' ', $col)[0];
try {
// Try to add column
$sql = "ALTER TABLE theme_settings ADD COLUMN $col";
$pdo->exec($sql);
echo "✔ Added column: $colName
";
} catch (PDOException $e) {
// Error code 42S21 means 'Duplicate column name' (already exists)
if ($e->errorInfo[1] == 1060) {
echo "• Column $colName already exists (Skipped).
";
} else {
echo "✘ Error adding $colName: " . $e->getMessage() . "
";
}
}
}
echo "✅ Database Update Complete!
";
echo "Go Back to Settings Page";
?>