<?php

$mysqli = new mysqli('localhost', 'root', 'admin');

$mysqli->select_db('authentication');

$user = "john";
$password = sha1("paxton");

$query = "INSERT INTO accounts (username, password) VALUES ('{$user}', '{$password}');";
echo $query;

$mysqli->query("LOCK TABLES accounts WRITE");
$mysqli->query($query);
$mysqli->query("UNLOCK TABLES");

$mysqli->close();

?>