<?php
header('Content-Type: text/html; charset=utf-8');

$conn = new mysqli(
    "localhost",
    "crmsahavasco",
    "sa123AWEsadfa",
    "crmsahavasco_arevastockexpsheet"
);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

/* Proper Unicode support for Marathi / Sanskrit */
$conn->set_charset("utf8mb4");

?><?php
$message = "";


if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $sql = "INSERT INTO vishnu_sahasranamam 
    (shlokas, single_words_marathi, meaning_marathi, details_marathi,
     single_words_english, simple_meaning, mythological_explanation, spiritual_message)
    VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

    $stmt = $conn->prepare($sql);

    if ($stmt) {

        $stmt->bind_param(
            "ssssssss",
            $_POST['shlokas'],
            $_POST['single_words_marathi'],
            $_POST['meaning_marathi'],
            $_POST['details_marathi'],
            $_POST['single_words_english'],
            $_POST['simple_meaning'],
            $_POST['mythological_explanation'],
            $_POST['spiritual_message']
        );

        if ($stmt->execute()) {
            $message = "<div class='success'>&#2358;&#2381;&#2354;&#2379;&#2325; &#2351;&#2358;&#2360;&#2381;&#2357;&#2368;&#2352;&#2367;&#2340;&#2381;&#2351;&#2366; &#2332;&#2340;&#2344; &#2333;&#2366;&#2354;&#2366;!</div>";
        } else {
            $message = "<div class='error'>Error: " . $stmt->error . "</div>";
        }

        $stmt->close();

    } else {
        $message = "<div class='error'>Prepare failed: " . $conn->error . "</div>";
    }
}
?>

<!DOCTYPE html>
<html lang="mr">
<head>
<meta charset="UTF-8">
<title></title>

<!-- Devanagari Google Font -->
<link href="https://fonts.googleapis.com/css2?family=Noto+Sans+Devanagari:wght@400;600&display=swap" rel="stylesheet">

<style>
body {
    font-family: 'Noto Sans Devanagari', sans-serif;
    background: linear-gradient(135deg, #fff8e1, #ffe0b2);
    padding: 40px;
}

.container {
    max-width: 950px;
    margin: auto;
    background: #ffffff;
    padding: 30px;
    border-radius: 15px;
    box-shadow: 0 10px 30px rgba(0,0,0,0.1);
}

h2 {
    text-align: center;
    margin-bottom: 25px;
    color: #d84315;
}

label {
    font-weight: 600;
    margin-top: 10px;
    display: block;
}

textarea {
    width: 100%;
    min-height: 90px;
    padding: 10px;
    border-radius: 8px;
    border: 1px solid #ccc;
    margin-top: 5px;
    margin-bottom: 15px;
    font-size: 15px;
}

button {
    width: 100%;
    padding: 12px;
    background: #d84315;
    color: white;
    font-size: 16px;
    border: none;
    border-radius: 8px;
    cursor: pointer;
}

button:hover {
    background: #bf360c;
}

.success {
    background: #e8f5e9;
    color: #2e7d32;
    padding: 10px;
    border-radius: 6px;
    margin-bottom: 15px;
}

.error {
    background: #ffebee;
    color: #c62828;
    padding: 10px;
    border-radius: 6px;
    margin-bottom: 15px;
}
</style>
</head>

<body>

<div class="container">
<h2>&#2405; &#2357;&#2367;&#2359;&#2381;&#2339;&#2369; &#2360;&#2361;&#2360;&#2381;&#2352;&#2344;&#2366;&#2350; &#2358;&#2381;&#2354;&#2379;&#2325; &#2344;&#2379;&#2306;&#2342;&#2357;&#2366; &#2405;</h2>

<?= $message ?>

<form method="POST">

<label> &#2358;&#2381;&#2354;&#2379;&#2325; (Sanskrit)</label>
<textarea name="shlokas" required></textarea>

<label>&#2319;&#2325; &#2358;&#2348;&#2381;&#2342; (&#2350;&#2352;&#2366;&#2336;&#2368;)</label>
<textarea name="single_words_marathi" required></textarea>

<label>&#2309;&#2352;&#2381;&#2341; (&#2350;&#2352;&#2366;&#2336;&#2368;)</label>
<textarea name="meaning_marathi" required></textarea>

<label>&#2360;&#2357;&#2367;&#2360;&#2381;&#2340;&#2352; &#2350;&#2366;&#2361;&#2367;&#2340;&#2368; (&#2350;&#2352;&#2366;&#2336;&#2368;)</label>
<textarea name="details_marathi" required></textarea>

<label>Meaning (English)</label>
<textarea name="single_words_english" required></textarea>

<label>Simple Meaning</label>
<textarea name="simple_meaning" required></textarea>

<label>Mythological Explanation</label>
<textarea name="mythological_explanation" required></textarea>

<label>Spiritual Message</label>
<textarea name="spiritual_message" required></textarea>

<button type="submit">&#2358;&#2381;&#2354;&#2379;&#2325; &#2332;&#2340;&#2344; &#2325;&#2352;&#2366;</button>

</form>
</div>

</body>
</html>