vvvsvsdgdsrytvvf<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "bookmov9_matrimonial2024";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

echo "Connected successfully<br>";

function create_table_simple($conn, $table_name, $values)
{
    echo "Creating $table_name... ";
    $conn->query("DROP TABLE IF EXISTS `$table_name`");
    $sql = "CREATE TABLE `$table_name` (
        `{$table_name}_id` int(11) NOT NULL AUTO_INCREMENT,
        `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
        PRIMARY KEY (`{$table_name}_id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;";

    if ($conn->query($sql) === TRUE) {
        // echo "Created. ";
    } else {
        echo "Error creating table: " . $conn->error . "<br>";
        return;
    }

    foreach ($values as $value) {
        $stmt = $conn->prepare("INSERT INTO $table_name (name) VALUES (?)");
        $stmt->bind_param("s", $value);
        $stmt->execute();
    }
    echo "Inserted " . count($values) . " rows.<br>";
}

function update_existing_table($conn, $table_name, $values)
{
    echo "Updating $table_name... ";
    // Try Truncate, if fails, manual delete
    if (!$conn->query("TRUNCATE TABLE `$table_name`")) {
        echo "Truncate failed (" . $conn->error . "), trying DELETE... ";
        $conn->query("DELETE FROM `$table_name`");
    }

    // Check if table uses 'name' or specific column
    $stmt_check = $conn->query("SHOW COLUMNS FROM `$table_name` LIKE 'name'");
    if ($stmt_check->num_rows == 0) {
        // Assume tableName_name if not 'name'
        // But for this app, standard seems to be 'name' or 'caste_name'
        // We know 'caste' has 'name' from check, 'occupation' likely 'name'.
        echo "Warning: 'name' column not found, assuming standard pattern?<br>";
    }

    foreach ($values as $value) {
        $stmt = $conn->prepare("INSERT INTO $table_name (name) VALUES (?)");
        if (!$stmt) {
            echo "Prepare failed: (" . $conn->errno . ") " . $conn->error;
            return;
        }
        $stmt->bind_param("s", $value);
        $stmt->execute();
    }
    echo "Inserted " . count($values) . " rows.<br>";
}

function update_caste_table($conn)
{
    $table_name = 'caste';
    echo "Updating $table_name... ";

    // We verified column is 'name'
    if (!$conn->query("TRUNCATE TABLE `$table_name`")) {
        echo "Truncate failed (" . $conn->error . "), trying DELETE... ";
        $conn->query("DELETE FROM `$table_name`");
    }

    $values = [
        'Telugu Devanga',
        'Devanga Chettiar',
        'Karna Bhakthulu',
        'Hathinetu Maneyavaru (18 House)',
        'Sivachar Devanga',
        'Other'
    ];

    foreach ($values as $value) {
        $stmt = $conn->prepare("INSERT INTO $table_name (name) VALUES (?)");
        if (!$stmt) {
            echo "Prepare failed: (" . $conn->errno . ") " . $conn->error;
            return;
        }
        $stmt->bind_param("s", $value);
        $stmt->execute();
    }
    echo "Inserted " . count($values) . " rows.<br>";
}

create_table_simple($conn, 'eating_habits', ['Vegetarian', 'Non-Vegetarian', 'Eggetarian', 'Vegan']);
create_table_simple($conn, 'drinking_habits', ['No', 'Drinks Socially', 'Yes']);
create_table_simple($conn, 'smoking_habits', ['No', 'Occasional', 'Yes']);
create_table_simple($conn, 'sampradayam', ['Saivam (Vibhuti / Shiva / Chowdeswari)', 'Vaishnavam (Namam / Vishnu)', 'Lingayat']);
create_table_simple($conn, 'family_value', ['Orthodox', 'Traditional', 'Moderate', 'Liberal']);

create_table_simple($conn, 'gothram', [
    'Agasthya',
    'Atreya',
    'Bharadwaja',
    'Gargeya',
    'Gautama',
    'Jamadagni',
    'Kashyapa',
    'Koundinya',
    'Kaushika',
    'Markandeya',
    'Parasara',
    'Srivatsa',
    'Vasishta',
    'Vishwamitra',
    'Mounagurusa',
    'Manu',
    'Others (Enter Manually)'
]);

create_table_simple($conn, 'family_status', ['Middle Class', 'Upper Middle Class', 'Rich / Affluent']);
create_table_simple($conn, 'perform_laxmi_puja', ['Yes', 'No']);
create_table_simple($conn, 'vegetarian_chowdeswari', ['Yes', 'No']);
create_table_simple($conn, 'mutt_peetham', ['Hampi Hemakuta Peetham', 'Gayathri Peetham', 'Srisailam', 'None']);

create_table_simple($conn, 'nakshatram', [
    'Anuradha',
    'Thiruvadhirai',
    'Ayilyam',
    'Aswni',
    'Barani',
    'Chithirai',
    'Avittem',
    'Astham',
    'Kettai',
    'Karthikai',
    'Magam',
    'Mulam',
    'Mirugasiridam',
    'Punarpoosam',
    'Puradam',
    'Purattadhi',
    'Pooram',
    'Pocsam',
    'Revathi',
    'Rohini',
    'Sadayam',
    'Tiruvonam',
    'Swathi',
    'Uthiradam',
    'Uttrttadhi',
    'Uthiram',
    'Visakam'
]);

create_table_simple($conn, 'dosham', ['No Dosham', 'Kuja Dosham (Manglik)', 'Kala Sarpa Dosham', 'Rahu / Ketu Dosham', 'Sarpa Dosham', "Don't Know"]);
create_table_simple($conn, 'jathakam_format', ['Pure Telugu Almanac (Panchangam)', 'Thirukanitham', 'Vakyam']);
create_table_simple($conn, 'horoscope_style', ['South Indian Style', 'North Indian Style']);

update_existing_table($conn, 'occupation', [
    'Other Private Company',
    'Government / Public Sector',
    'Defence / Civil Services',
    'Business / Self Employed',
    'Not Working'
]);

update_caste_table($conn);

echo "Done.";
$conn->close();