/home3/bmscom/apps.theaffluentman.com/update_db_v6.php
<?php
require_once 'config/database.php';
echo "<h2>Database Update Script (v6)</h2>";
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// SQL to add new columns if they don't exist
$alter_queries = [
// Header Info
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS item_number_total varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS item_number_current varchar(50) DEFAULT NULL",
// Detailed Suit Specs (Updates/News)
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS lapel_width_inches varchar(50) DEFAULT NULL",
// Vest Details (New Section)
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS vest_style varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS vest_fabric_color varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS vest_fabric_number varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS vest_notes text DEFAULT NULL",
// Shirt Measurements & Info (New Section)
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_neck varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_sleeve_measure varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_chest varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_back varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_length_measure varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_back_shoulder varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_fabric_color_number varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_cuff_type varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_cuff_style varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_embroidery varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_embroidery_color varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_embroidery_size varchar(100) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS shirt_notes text DEFAULT NULL",
// Pants Notes (If missing)
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS pants_notes text DEFAULT NULL"
];
foreach ($alter_queries as $sql) {
if ($conn->query($sql) === TRUE) {
echo "<div style='color:green'>Success: " . htmlspecialchars($sql) . "</div>";
} else {
// Ignore duplicate column errors, report others
if (strpos($conn->error, "Duplicate column") !== false) {
echo "<div style='color:orange'>Skipped (Exists): " . htmlspecialchars($sql) . "</div>";
} else {
echo "<div style='color:red'>Error: " . $conn->error . "</div>";
}
}
}
echo "<br><strong>Database update completed. Please delete this file after use.</strong>";
?>