· 8 years ago · May 27, 2018, 10:30 AM
1<?php
2
3//Structura Database
4//DB: users
5//user_id INT(24) NOT NULL AUTO_INCREMENT
6//username VARCHAR(12) NOT NULL
7//password VARCHAR(10) NOT NULL
8
9if(isset($_POST['submit'])){
10
11$errors = array();
12
13 if(isset($_POST['username']))
14 {
15 if(strlen($_POST['username']) < 2)
16 {
17 $errors[] = 'Numele nu poate fi mai mic de 2 caractere.';
18 }
19 if(strlen($_POST['username']) > 10)
20 {
21 $errors[] = 'Numele nu poate fi mai lung de 10 caractere.';
22 }
23
24 }
25 else
26 {
27 $errors[] = 'Campul username nu poate fi gol.';
28 }
29
30
31 if(isset($_POST['password']))
32 {
33 if($_POST['password'] != $_POST['checkpassword'])
34 {
35 $errors[] = 'Cele 2 parole nu se potrivesc.';
36 }
37 }
38 else
39 {
40 $errors[] = 'Campul parola nu poate fi gol.';
41 }
42
43 if(!empty($errors))
44 {
45 foreach($errors as $key => $value)
46 {
47 echo $value;
48 }
49 }
50 else
51 {
52
53 $dbuser = $_POST['username'];
54
55 $tabela_utilizator = $dbuser.'_table';
56 $table = "CREATE TABLE $tabela_utilizator IF NOT EXISTS(
57 user_id INT(24) NOT NULL AUTO_INCREMENT,
58 username VARCHAR(12) NOT NULL,
59 password VARCHAR(10) NOT NULL
60 )";
61
62 $sqlq = mysql_query($table);
63 if(!$sqlq){
64 print 'Table can′t be created';
65 }else{
66 $sql = "INSERT INTO $tabela_utilizator(username, password) VALUES('" . mysql_real_escape_string($_POST['username']) . "','" . md5($_POST['password']) . "')";
67 $insert = mysql_query($sql);
68 print 'Utilizator inregistrat cu succes.';
69 }
70
71 }
72
73
74}else{
75
76print '
77<form action="" method="POST">
78<input type="text" name="username" size="21">
79<input type="password" name="password" size="21">
80<input type="password" name="checkpassword" size="21">
81<input type="submit" name="submit" value="Inregistreaza cont">
82</form>
83';
84
85}
86?>
87
88
89Sign in(logare)
90
91<?php
92
93if(isset($_SESSION['logat']) && $_SESSION['logat'] == true)
94{
95 echo 'Esti deja logat,te poti <a href="signout.php">deloga</a> daca vrei.';
96
97
98}
99else
100{
101
102if($_SERVER['REQUEST_METHOD'] != 'POST')
103 {
104 echo '<form method="post" action="">
105 <input type="text" name="username" size="21">
106 <input type="password" name="password" size="21">
107 <input type="submit" name="submit" value="Inregistreaza cont">
108 <input type="submit" value="Sign in" />
109 </form>';
110 }
111 else
112 {
113 $errors = array();
114
115 if(empty($_POST['username']))
116 {
117 $errors[] = 'Campul userului este gol.';
118 }
119
120 if(empty($_POST['password']))
121 {
122 $errors[] = 'Campul parola este gol.';
123 }
124
125 if(!empty($errors))
126 {
127 echo 'Cateva probleme la logare<br /><br />';
128 echo '<ul>';
129 foreach($errors as $key => $value)
130 {
131 echo '<li>' . $value . '</li>';
132 }
133 echo '</ul>';
134 }
135 else
136 {
137 $sql = "SELECT
138 user_id,
139 username,
140 password
141 FROM
142 users
143 WHERE
144 username = '" . mysql_real_escape_string($_POST['username']) . "'
145 AND
146 password = '" . md5($_POST['password']) . "'";
147
148 $result = mysql_query($sql);
149 if(!$result)
150 {
151
152 echo 'ERROR.';
153 /
154 }
155 else
156 if(mysql_num_rows($result) == 0)
157 {
158 echo 'Ai incercat gresit o combinatie de user si parola.Incearca mai tarziu.';
159 }
160 else
161 {
162 $_SESSION['logat'] = true;
163
164 while($row = mysql_fetch_assoc($result))
165 {
166 $_SESSION['user_id'] = $row['user_id'];
167 $_SESSION['username'] = $row['username'];
168 }
169
170 echo 'Bine ai venit, ' . $_SESSION['username'] . '. <br /><a href="index.php">Dute la pagina index.</a>.';
171 }
172 }
173 }
174 }
175
176 }
177?>