connect_error) { die("Database connection failed."); } echo "Connected successfully to DB!
"; // Add column sort_order if not exists $res = $conn->query("SHOW COLUMNS FROM packages LIKE 'sort_order'"); if ($res) { if ($res->num_rows == 0) { if ($conn->query("ALTER TABLE packages ADD COLUMN sort_order INT DEFAULT 0")) { echo "Successfully added 'sort_order' column to 'packages' table.
"; } else { echo "Error adding column: " . $conn->error . "
"; } } else { echo "'sort_order' column already exists.
"; } } else { echo "Error querying table schema: " . $conn->error . "
"; }