halohalo

<?php error_reporting(E_ALL); ini_set('display_errors', 1); include 'admin/config.php'; echo "<h2>Database Fix Tool</h2>"; // 1. Try to add the column $sql = "ALTER TABLE product_variants ADD COLUMN variant_image VARCHAR(255) DEFAULT NULL"; if ($conn->query($sql)) { echo "<p style='color:green;'>✅ Column 'variant_image' added successfully!</p>"; } else { if (strpos($conn->error, "Duplicate column name") !== false) { echo "<p style='color:blue;'>ℹ️ Column 'variant_image' already exists.</p>"; } else { echo "<p style='color:red;'>❌ Error adding column: " . $conn->error . "</p>"; } } // 2. Verify table structure echo "<h3>Current Table Structure:</h3><pre>"; $res = $conn->query("DESCRIBE product_variants"); while($row = $res->fetch_assoc()) { print_r($row); } echo "</pre>"; echo "<br><a href='admin/product-add.php' style='padding:10px 20px; background:#007bff; color:white; text-decoration:none; border-radius:5px;'>Go back to Admin</a>"; ?>