Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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!");//
- error_reporting(0);
- 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 = md5($password);
- //Checkt of username bezet is//
- $check = mysql_fetch_array(mysql_connect("localhost", "php", "members", "username"));
- echo "$username";
- if ($check == 'username'){
- die ("Username is al bezet! Probeer aub opnieuw! <a href='register.php'>back</a>");
- };
- //Check of email bezet is//
- $conn = mysql_connect($localhost, $root, $wachtwoord123);
- $check = mysql_fetch_array(mysql_connect("localhost", "php", "members", "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 ($check['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 (
- id int(11) unsigned auto_increment primary key,
- username vanchar(255) not null,
- email vanchar (255),
- password vanchar (255),
- )";
- //Insert in to database//
- $sql = "insert into members (
- id,
- username,
- password,
- email,
- )
- values (
- '$id',
- '$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 $usertname! 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>
Add Comment
Please, Sign In to add comment