· 10 years ago · Jun 25, 2016, 05:51 PM
1Estrutura:
2
3- /login
4--- index.php
5--- login.php
6
7- /new
8--- index.php
9--- new.php
10
11- database.php
12
13- logoff.php
14
15- valid.php
16
17- index.php
18
19
20
21*****************
22database.php
23*****************
24
25<?php
26 session_start();
27
28 // Database
29 $database_serv = 'localhost:3307'; // Serv MySQL
30 $database_user = 'root'; // User MySQL
31 $database_pass = 'usbw'; // Password MySQL
32 $database_bd = 'contador'; // Database
33
34 // Table user Database
35 $database_table_user = 'user';
36
37 // Connection
38 $database_conexBD = mysql_connect($database_serv, $database_user, $database_pass) or die("Could not connect to the server.");
39 mysql_set_charset('utf8',$database_conexBD);
40
41
42
43*****************
44valid.php
45*****************
46
47<?php
48session_start();
49if (!$_SESSION['user']) { header("Location: login/"); }
50
51
52*****************
53logoff.php
54*****************
55
56<?php
57 session_start();
58 session_destroy();
59 header("Location: login/");
60?>
61
62
63*****************
64user.sql
65*****************
66
67CREATE TABLE IF NOT EXISTS `user` (
68 `id` int(55) NOT NULL AUTO_INCREMENT,
69 `user` text NOT NULL,
70 `email` text NOT NULL,
71 `pass` text NOT NULL,
72 `first_name` text NOT NULL,
73 `last_name` text NOT NULL,
74 `age` text NOT NULL,
75 PRIMARY KEY (`id`)
76) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
77
78
79*****************
80login/index.php
81*****************
82
83<!DOCTYPE HTML>
84<html>
85 <head>
86 <meta charset="utf-8">
87 <title>Login</title>
88 </head>
89
90 <body>
91 <form method="post" action="login.php" method="post">
92 <div><input type="text" name="user" placeholder="User" autofocus></div>
93 <div><input type="password" name="pass" placeholder="Password"></div>
94 <div><button type="submit">Login</button></div>
95 </form>
96 <br>
97 <p><a href="../new/">Register</a></p>
98 </body>
99</html>
100
101
102*****************
103login/login.php
104*****************
105
106<?php
107 include "../database.php";
108
109 if (!$_POST['user']) { $rec_user = ""; } else { $rec_user = addslashes($_POST['user']); }
110 if (!$_POST['pass']) { $rec_pass = ""; } else { $rec_pass = addslashes($_POST['pass']); }
111
112 if (isset($rec_user)) {
113 mysql_select_db($database_bd, $database_conexBD) or die("Could not connect to database.");
114
115 $sql = "SELECT * FROM $database_table_user WHERE user = '$rec_user' AND pass = '$rec_pass' LIMIT 1";
116 $query = mysql_query($sql);
117 $result = mysql_fetch_assoc($query);
118 $count = mysql_num_rows($query);
119
120 if ($count == 0) {
121 header("Location: index.php?mess=no_user");
122 } else {
123 $_SESSION['id'] = $result['id'];
124 $_SESSION['user'] = $result['user'];
125 $_SESSION['email'] = $result['email'];
126 $_SESSION['first_name'] = $result['first_name'];
127 $_SESSION['last_name'] = $result['last_name'];
128 $_SESSION['age'] = $result['age'];
129
130 header("Location: ../index.php");
131 }
132 }
133
134?>
135
136
137*****************
138new/index.php
139*****************
140
141<!DOCTYPE html>
142<html>
143 <head>
144 <meta charset="utf-8">
145 <title>New User</title>
146 </head>
147 <body>
148 <h1>New User</h1>
149 <form method="post" action="new.php" method="post">
150 <div><input type="text" name="first_name" placeholder="First Name"></div>
151 <div><input type="text" name="last_name" placeholder="Last Name"></div>
152 <div><input type="email" name="email" placeholder="Email"></div>
153 <div><input type="text" name="user" autofocus="on" placeholder="Username"></div>
154 <div><input type="password" name="pass" placeholder="Password"></div>
155 <div><input type="number" name="age" placeholder="Age"></div>
156 <div><button type="submit">Save User</button>
157 </form>
158 <p>After registration, please <a href="../login/">Login</a></p>
159 </body>
160</html>
161
162
163
164*****************
165new/new.php
166*****************
167
168<?php
169 include "../database.php";
170
171 if (!$_POST['user']) { $rec_user = ""; } else { $rec_user = addslashes($_POST['user']); }
172
173 if (isset($rec_user)) {
174 mysql_select_db($database_bd, $database_conexBD) or die("Could not connect to database.");
175
176 $rec_user = addslashes($_POST['user']);
177 $rec_pass = addslashes($_POST['pass']);
178 $rec_email = addslashes($_POST['email']);
179 $rec_age = addslashes($_POST['age']);
180 $rec_first_name = addslashes($_POST['first_name']);
181 $rec_last_name = addslashes($_POST['last_name']);
182
183 $insert = "INSERT INTO $database_table_user (id, user, email, pass, age, first_name, last_name) VALUES (NULL, '$rec_user', '$rec_email', '$rec_pass', '$rec_age', '$rec_first_name', '$rec_last_name')";
184
185 if (mysql_query($insert)) {
186 header("Location: index.php?mess=ok");
187 } else {
188 header("Location: index.php?mess=no");
189 }
190 }
191?>