MySQLi

mysqli.php

<?php

   $mysqli = mysqli_connect('localhost', 'user', 'pass', 'database');

   if (mysqli_connect_errno())
   {
      print('Gat ekki tengst.');
   }

   if ($stmt = $mysqli->prepare('INSERT INTO `users` (`name`, `username`, `email`, `password`) VALUES (?, ?, ?, ?)'))
   {
       $stmt->bind_param('sssb', 'John Doe', 'john', 'john@doe.com', hash('sha256', 'password', TRUE));
       $stmt->execute();
       $stmt->close();

       echo $mysqli->insert_id.' var búinn til!';
   }

   $mysqli->close();

?>