<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);
// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";
if (mysqli_query($conn, $sql)) {
$last_id = mysqli_insert_id($conn);
echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
?>
PD9waHAKJHNlcnZlcm5hbWUgPSAibG9jYWxob3N0IjsKJHVzZXJuYW1lID0gInVzZXJuYW1lIjsKJHBhc3N3b3JkID0gInBhc3N3b3JkIjsKJGRibmFtZSA9ICJteURCIjsKCi8vIENyZWF0ZSBjb25uZWN0aW9uCiRjb25uID0gbXlzcWxpX2Nvbm5lY3QoJHNlcnZlcm5hbWUsICR1c2VybmFtZSwgJHBhc3N3b3JkLCAkZGJuYW1lKTsKLy8gQ2hlY2sgY29ubmVjdGlvbgppZiAoISRjb25uKSB7CiAgZGllKCJDb25uZWN0aW9uIGZhaWxlZDogIiAuIG15c3FsaV9jb25uZWN0X2Vycm9yKCkpOwp9Cgokc3FsID0gIklOU0VSVCBJTlRPIE15R3Vlc3RzIChmaXJzdG5hbWUsIGxhc3RuYW1lLCBlbWFpbCkKVkFMVUVTICgnSm9obicsICdEb2UnLCAnam9obkBleGFtcGxlLmNvbScpIjsKCmlmIChteXNxbGlfcXVlcnkoJGNvbm4sICRzcWwpKSB7CiAgJGxhc3RfaWQgPSBteXNxbGlfaW5zZXJ0X2lkKCRjb25uKTsKICBlY2hvICJOZXcgcmVjb3JkIGNyZWF0ZWQgc3VjY2Vzc2Z1bGx5LiBMYXN0IGluc2VydGVkIElEIGlzOiAiIC4gJGxhc3RfaWQ7Cn0gZWxzZSB7CiAgZWNobyAiRXJyb3I6ICIgLiAkc3FsIC4gIjxicj4iIC4gbXlzcWxpX2Vycm9yKCRjb25uKTsKfQoKbXlzcWxpX2Nsb3NlKCRjb25uKTsKPz4=