<?php

$mysqli = new mysqli("localhost", "root", "", "constra_db");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

$sql = "ALTER TABLE projects ADD COLUMN client_name VARCHAR(255) AFTER title, ADD COLUMN client_details TEXT AFTER client_name";

if ($mysqli->query($sql)) {
    echo "Columns added successfully.";
} else {
    echo "Error adding columns: " . $mysqli->error;
}

$mysqli->close();
?>
