Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- echo "privet";
- if ($_SERVER["REQUEST_METHOD"] == "POST") {
- // Подключение к базе данных
- include ('page1.php');
- $connection = new mysqli("127.0.0.1", "user", "12345", "geydb1");
- if ($connection->connect_error) {
- die("Connection failed: " . $connection->connect_error);
- }
- else {
- echo "Connected successfully to the database.";
- }
- // Дополнительные поля ввода
- // Выполнение SQL-запроса для добавления записи
- $query = "INSERT INTO test1 (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;
- }
- // Получение данных из формы
- $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"];
- $stmt->close();
- $connection->close();
- }
Add Comment
Please, Sign In to add comment