<?php
require("config.php");

if(isset($_POST['submit']))
{
$password = $_POST['password'];
$rpassword = $_POST['rpassword'];

if($password == $rpassword)
{
    $fname = mysql_escape_string($_POST['first_name']);
    $lname = mysql_escape_string($_POST['last_name']);
    $uname = mysql_escape_string($_POST['username']);
    $mail = mysql_escape_string($_POST['email']);
    $pass = mysql_escape_string($_POST['password']);

    mysql_query("INSERT INTO 'users'     ('id','first_name','last_name','username','email','password') VALUES (NULL, '$fname','$lname','$uname','$mail','$pass')");
}
else
{
    echo "Your passwords must match!";
    exit();
}
}
else
{
echo '
<form action="register.php" method="post">
First Name: <input type="text" name="first_name"><br>
Last Name: <input type="text" name="last_name"><br>
Username: <input type="text" name="username"><br>
E-mail: <input type="text" name="email"><br>
Password: <input type="password" name="password"><br>
Confirm Password: <input type="password" name="rpassword"><br>
<input type="submit" value="Sign Out" name="submit"><br>
</form>';
}
?>

<?php
mysql_connect("localhost","root","");
mysql_select_db("registr");
?>

$res=mysql_query("INSERT INTO 'users'
 ('id','first_name','last_name','username','email','password') VALUES
 (NULL, '".$fname."','".$lname."','".$uname."','".$mail."','".$pass."')") or die(mysql_error());

$res=mysql_query("
INSERT INTO  `users` (
`id` ,
`first_name` ,
`last_name` ,
`username` ,
`email`  ,
`password` ,
)
VALUES (NULL, '".$fname."','".$lname."','".$uname."','".$mail."','".$pass."')") or die(mysql_error());

mysql_query("INSERT INTO 'users'     ('id','first_name','last_name','username','email','password') VALUES (NULL, '$fname','$lname','$uname','$mail','$pass')");

mysql_query("INSERT INTO `users`     (first_name,last_name,'username,email, password) VALUES ('$fname','$lname','$uname','$mail','$pass')");

'username,

mysql_query("INSERT INTO `users` (`first_name`,`last_name`,`username`,`email`,`password`) VALUES ('$fname','$lname','$uname','$mail','$pass')") or die(mysql_error());