<?php
$db = mysqli_connect("localhost", "john_john", "6Rt3Tsz79v", "john_john");
if(!$db)
{
  exit("Fail: ".mysqli_connect_error());
}

$sql = "INSERT INTO 24_api (username, email, password)
VALUES ('John', 'Doe', 'john@example.com')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>