     <?php
     $servername = "localhost"; 
     $username = "root";
     $password = "******";
     $dbname = "my_DB";
     // Создаём соединение
     $conn = new mysqli($servername, $username, $password, $dbname);
     // Проверим подключение
     if ($conn->connect_error) {
       die("Ошибка соединения: " . $conn->connect_error);
     }
     // подготовить и связать
     $stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, email) VALUES (?, ?, ?)");
     $stmt->bind_param("sss", $firstname, $lastname, $email);

     // задайте параметры и выполните
     $firstname = "John";
     $lastname = "Doe";
     $email = "john@example.com";
     $stmt->execute();

     $firstname = "Mary";
     $lastname = "Moe";
     $email = "mary@example.com";
     $stmt->execute();

     $firstname = "Julie";
     $lastname = "Dooley";
     $email = "julie@example.com";
     $stmt->execute();

     echo "New records created successfully";

     $stmt->close();
     // Закроем соединение
     $conn->close();
     ?>