Tetris/signup.php at master · chitrasingla/Tetris · 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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<?php

//signup.php

// connect database
include('../demotetris/database/database_connection.php');

session_start();

if(isset($_POST["action"]))
{
	// for sign up action
		// variables
		$newuser_user_name = '';
		$newuser_email = '';
		$newuser_password = '';

		$error_newuser_user_name = '';
		$error_newuser_email = '';
		$error_newuser_password = '';

		$error = 0;

		// newuser user_name empty
		if(empty($_POST["newuser_user_name"]))
		{
			$error_newuser_user_name = 'User name is required';
			$error++;
		}
		else
		{
			$newuser_user_name = $_POST["newuser_user_name"];
		}

		if(empty($_POST["newuser_email"]))
		{
			$error_newuser_email = 'User email id is required';
			$error++;
		}
		else
		{
			// check email format
			if(!filter_var($_POST["newuser_email"], FILTER_VALIDATE_EMAIL))
			{
				$error_newuser_email = 'Invalid email-id format';
				$error++;
			}
			else
			{
				$newuser_email = $_POST["newuser_email"];
			}
		}

		// password empty
		if(empty($_POST["newuser_password"]))
		{
			$error_newuser_password = 'Password is required';
			$error++;
		}
		else
		{
			$newuser_password = $_POST["newuser_password"];
		}

		// if any validation error
		if($error > 0)
		{
			// output array
			$output = array(
				'error'								=>	true,
				'error_newuser_user_name'			=>	$error_newuser_user_name,
				'error_newuser_email'				=>  $error_newuser_email,
				'error_newuser_password'			=>	$error_newuser_password,
			);
		}
		else
		{

			// for adding newuser
				$data = array(
					':newuser_user_name'			=>	$newuser_user_name,
					':newuser_doj'					=>  date("Y-m-d"),
					':newuser_email'				=> 	$newuser_email,
					':newuser_password'				=>	password_hash($newuser_password, PASSWORD_DEFAULT)
				);

				// select query
				$query = "
				INSERT INTO tbl_user
				(user_name, user_doj, user_emailid, user_password)
				SELECT * FROM (SELECT :newuser_user_name, :newuser_doj, :newuser_email, :newuser_password) as temp
				WHERE NOT EXISTS (
					SELECT user_emailid FROM tbl_user WHERE user_emailid = :newuser_email
				) LIMIT 1
				";

				$statement = $connect->prepare($query);
				if($statement->execute($data)){

					if($statement->rowCount() >0)
					{
						// data added
						$output = array(
							'success'		=>	'User Added Successfully',
						);
					}
					else
					{
						// error
						$output = array(
							'error'					=> 	true,
							'error_newuser_email' 	=> 'Email ID already exists'
						);
					}

				}
		}
		echo json_encode($output);
}

?>