<?php

    $servername="localhost";
    $username="guest";
    $password="guest";
    $dbname="guest";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if(!$conn) {
    die("connection failed: " . mysqli_connect_error());
}

$sql = "INSERT INTO usernames (firstname, lastname, email, password) VALUES ('{$_GET['firstname']}','{$_GET['lastname']}', '{$_GET['email']}', '{$_GET['password']}')";

if(mysqli_query($conn, $sql)) {
    echo "Record in the table created succesfully!";
}


else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

mysqli_close($conn);
?>