<?php

$connect = mysqli_connect("myservername" , "myusername" , "mypassword" , "mydatabase");

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$username = mysqli_real_escape_string($connect, "$_POST[post_username]");
$password = md5(mysqli_real_escape_string($connect, "$_POST[post_password]" . "sKd_4tW31_2"));
$firstName = mysqli_real_escape_string($connect, "$_POST[post_firstName]");
$lastName = mysqli_real_escape_string($connect, "$_POST[post_lastName]");


$sql = "INSERT INTO users (username, password, firstName, lastName) VALUES ($username, $password, $firstName, $lastName)";


if (!mysqli_query($connect,$sql)) {
  die('Error: ' . mysqli_error($connect));
}
header('Location: http://localhost/myblog/sucess.php');

mysqli_close($connect);

?>