<?php
echo "privet";

$connection = new mysqli("127.0.0.1", "root", "123", "geydb1");
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}
else {
    echo "Connected successfully to the database.";
}
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Подключение к базе данных
    include ('page1.php');


    // Получение данных из формы
    $role = $_POST["role"];
    $subject = $_POST["subject"];
    $price = $_POST["price"];
    $delivery_date = $_POST["delivery_date"];
    $payment1 = $_POST["payment1"];
    $payment2 = $_POST["payment2"];
    $payment3 = $_POST["payment3"];
    $supply = $_POST["supply"];
    $supply_size =$_POST["supply_size"];
    $pnd = $_POST["pnd"];
    $delivery = $_POST["delivery"];
    // Дополнительные поля ввода

    // Выполнение SQL-запроса для добавления записи
    $query = "INSERT INTO doc_sogl_create (role, subject, price, delivery_date, payment1, payment2, payment3, supply,supply_size, pnd, delivery) VALUES ('$role', '$subject', '$price','$delivery_date', '$payment1', '$payment2', '$payment3','$supply', '$supply_size','$pnd', '$delivery')";
    $stmt = $connection->prepare($query);
    $stmt->bind_param("ssdsdddsssss", $role, $subject, $price, $delivery_date, $payment1, $payment2, $payment3, $supply, $supply_size, $pnd, $delivery);
    if ($stmt->execute()) {
        echo "Data inserted successfully.";
    } else {
        echo "Error: " . $stmt->error;
    }

    $stmt->close();

    $connection->close();
}