/home3/bmscom/apps.theaffluentman.com/update_db_v8.php
<?php
require_once 'config/database.php';
echo "<h2>Database Update Script (v8)</h2>";
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// SQL to add new columns for Women's measurements and Gender
$alter_queries = [
// Core info
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS gender varchar(20) DEFAULT 'man'",
// Women's Measurements (v8)
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_shoulder_to_bust varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_front_length varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_jacket_length varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_skirt_length varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_top_coat_length varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_high_shoulders varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_low_shoulders varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_back_length varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_bust varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_bust_width varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_waist varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_hips varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_sleeves varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_cuff varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_neck varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_slack_out_seam varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_slack_inseam varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_slack_cuff varchar(50) DEFAULT NULL",
"ALTER TABLE orders ADD COLUMN IF NOT EXISTS w_figure_type varchar(100) 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 v8 completed. Please delete this file after use.</strong>";
?>