register file

<?php
include 'config.php';


//connect to database//

echo "db koppelen";
$connection = mysql_connect ("localhost", "root", "wachtwoord123") or die("couldn't connect to server!");
mysql_select_db("php", $connection) or die("couldn't connect to the database!");//

echo "variabelen voorzien van input";
if(!empty($_POST)) {
		$username = mysql_real_escape_string($_POST['username']);
		$email = mysql_real_escape_string($_POST['email']);
		$password = mysql_real_escape_string($_POST['password']);
        $password = password_hash($password);


	//Checkt of username bezet is//
    $sql = mysql_query("SELECT * FROM members WHERE col='username'");
echo "$username";
if ($sql == 'username'){
	die ("Username is al bezet! Probeer aub opnieuw! <a href='register.php'>back</a>");
};

//Check of email bezet is//
$connection = mysql_connect("localhost", "root", "wachtwoord123");
$sql = mysql_query("SELECT * FROM members WHERE col='email'"); // De SQL in caps, en de fields in noormaal, is overzichtelijker. 'email' hoeft niet tussen '' maar na = moet wel tussen ''\\
    /* @var $email type */
    if ($sql['email'] == $email){
	die ("Dit email is al in gebruik!");
} // als je FETCH array doet moet je ook zeggen welk field je wilt. En $email word gedifned hierboven bij MYSQL_REAL_ESCAPE_STRING //

//Mag niet langer uit 20 letters bestaan//
if (strlen($username)>20){
	die ("Username mag niet uit meer dan 20 letters bestaan! <a href='register.php'>Back</a>");
	};

	//create a table//
$sql = "create table members (
username vanchar(255) not null,
email vanchar (255),
password vanchar (255),
)";

//Insert in to database//
$sql = "insert into members (
username,
password,
email,
)

values (
'$username',
'$password',
'$email',
)";

	//select username  for succesfull registed//
	$salt = hash("md5", rand() . rand() . rand()); // HASH "MD5" is zelfde als MD5 zo alleen kan je extra dingen aan toevoegen als je HASH T_STRING gebruikt.//
$query = mysql_query("SELECT * FROM members WHERE username=$username");
$array = mysql_fetch_array($query);
if ($username == $array['username']);
setcookie("c_salt", $salt, time() + 24 * 60 * 60, "/");
setcookie("c_user", hash("md5", $username), time() + 24 * 60 * 60, "/");
die("welkom $username! Je account is succesvol aangemaakt!");
}

?>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="content-type" content="text/html; charset=utf-8" />
            <title>Registreren</title>
    </head>
        <body>
	<body style='font-family: verdana, sans-serif;'>
		<div style='width: 50%; padding: 5px 15px 5px; border: 5px solid #e3e3e3; background-color: #fff; margin-left: 25%;'>
	<h1>Register</h1>
		<br />
			<form action="" method="post">
				<table>
					<tr>
						<td>
							<b>Username</b>
						</td>
						<td>
							<input type='text' name='username' style='padding: 4px;' />
						</td>
					</tr>
					<tr>
						<td>
							<b>Email</b>
						</td>
						<td>
							<input type='email' name='email' style='padding: 4px;' />
						</td>
					</tr>
					<tr>
						<td>
							<b>Password</b>
						</td>
						<td>
							<input type='password' name='password' style='padding: 4px;' />
						</td>
					</tr>
					<tr>
						<td>
							<b>Confirm-password</b>
						</td>
						<td>
							<input type='password' name='password' style='padding: 4px;' />
						</td>
					</tr>
					<tr>
						<td>
							<input type='submit' value='Registreer!' />
						</td>
					</tr>
				</table>
			</form>
				<h3>Al een account? <a href='login.php'>Log in!</a>
		</div>
	</body>
</html>