fork download
  1. <?php
  2. $servername = "localhost";
  3. $username = "username";
  4. $password = "password";
  5. $dbname = "myDB";
  6.  
  7. // Create connection
  8. $conn = mysqli_connect($servername, $username, $password, $dbname);
  9. // Check connection
  10. if (!$conn) {
  11. die("Connection failed: " . mysqli_connect_error());
  12. }
  13.  
  14. $sql = "INSERT INTO MyGuests (firstname, lastname, email)
  15. VALUES ('John', 'Doe', 'john@example.com')";
  16.  
  17. if (mysqli_query($conn, $sql)) {
  18. $last_id = mysqli_insert_id($conn);
  19. echo "New record created successfully. Last inserted ID is: " . $last_id;
  20. } else {
  21. echo "Error: " . $sql . "<br>" . mysqli_error($conn);
  22. }
  23.  
  24. mysqli_close($conn);
  25. ?>
Success #stdin #stdout 0.24s 81168KB
stdin
Standard input is empty
stdout
Standard output is empty