add new data to the MySQL Table .

insert data.php

<?php

//insert new data to the table myGuests : 
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";

//check if the statement successfully applicated : 
if ($conn->query($sql) === TRUE) {
  $last_id = $conn->insert_id;
  echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}


//close the connection to the database : 
$conn->close();

?>