milq/learn/php/login/sign_up.php at master · Sweetharry1992/milq · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<!DOCTYPE html>
<html xmlns='http://www.w3.org/1999/xhtml' lang='en'>
  <head>
    <meta charset='utf-8' />
    <title>Log in and sign up template</title>
    <link rel='stylesheet' type='text/css' href='src/css/style.css' />
    <script type='text/javascript' src='src/js/app.js'></script>
  </head>

  <body>

  <h1>Sign up</h1>

  <?php

	require_once('connect_db.php');

	$username = $_POST['username'];
	$password = $_POST['password'];

	if (strlen($username) === 0 || strlen($password) === 0) {
	    echo '<p>Your username and/or password is missing.</p>';
	}
	else {
		$sql = 'INSERT INTO users(username,password,active,role) values(?,?,?,?)';
        $sth = $dbh->prepare($sql);
        $success = $sth->execute(array($username, $password, 'yes', 'user'));

        if ($success) {
			echo '<p>Congratulations! You create an username with an user role.</p>';
		}
		else {
			echo '<p>There was an error during registration. Maybe username already exists.</p>';
		}
	}
  ?>

  <a href='index.php'>Back to index.</a>

  </body>
</html>