Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <style>
- table {
- border: 1px solid;
- }
- td {
- border: 1px solid;
- }
- </style>
- <?php
- ini_set("display_errors", 1);
- header("Content-Type: text/html; charset=UTF-8");
- Error_Reporting(E_ALL & ~E_NOTICE);
- session_start();
- $dsn = "mysql:host=localhost;dbname=test;charset=utf8";
- $opt = array (
- PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
- PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
- );
- $pdo = new PDO($dsn, '', '', $opt);
- $login = $pdo->query('SELECT login FROM users')->fetchAll(PDO::FETCH_COLUMN);;
- $password = $pdo->query('SELECT password FROM users')->fetchAll(PDO::FETCH_COLUMN);;
- if (isset($_POST['enter'])) {
- $data = array_map("trim", $_POST);
- $data = array_map("strip_tags", $data);
- }
- foreach ($login as $i => $log) {
- foreach ($password as $j => $pass) {
- if ($log == $data['login'] && $pass == md5($data['password'].$data['login'])) {
- $_SESSION['login'] = $log;
- }
- }
- }
- if(!isset($_SESSION['login'])){
- echo "Неверный логин и/или пароль"."<br>";
- echo "Доступ закрыт"."<br>";
- ?>
- <a href="logout.php">Надо авторизироваться</a>
- <?php
- }else{
- $user = $pdo->prepare('SELECT * FROM users WHERE login = :login');
- $user->execute(array('login'=>$_SESSION['login']));
- $table = "<table><tr><td>login</td><td>password</td><td>fio</td><td>email</td><td>address</td>";
- while ($row = $user->fetch()) {
- $table .= "<tr>";
- $table .= "<td>".$row['login']."</td>";
- $table .= "<td>".$row['password']."</td>";
- $table .= "<td>".$row['fio']."</td>";
- $table .= "<td>".$row['email']."</td>";
- $table .= "<td>".$row['address']."</td>";
- $table .= "</tr>";
- }
- $table .= "</table> ";
- echo $table;
- echo "<br>";
- ?>
- <a href="logout.php">Выход</a>
- <?php
- }
- echo "<br>";
- ?>
Add Comment
Please, Sign In to add comment