Guest User

Untitled

a guest
Mar 3rd, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.84 KB | None | 0 0
  1. <style>
  2. table {
  3. border: 1px solid;
  4. }
  5. td {
  6. border: 1px solid;
  7. }
  8. </style>
  9. <?php
  10. ini_set("display_errors", 1);
  11. header("Content-Type: text/html; charset=UTF-8");
  12. Error_Reporting(E_ALL & ~E_NOTICE);
  13. session_start();
  14. $dsn = "mysql:host=localhost;dbname=test;charset=utf8";
  15. $opt = array (
  16. PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
  17. PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
  18. );
  19. $pdo = new PDO($dsn, '', '', $opt);
  20.  
  21. $login = $pdo->query('SELECT login FROM users')->fetchAll(PDO::FETCH_COLUMN);;
  22. $password = $pdo->query('SELECT password FROM users')->fetchAll(PDO::FETCH_COLUMN);;
  23. if (isset($_POST['enter'])) {
  24. $data = array_map("trim", $_POST);
  25. $data = array_map("strip_tags", $data);
  26. }
  27. foreach ($login as $i => $log) {
  28. foreach ($password as $j => $pass) {
  29. if ($log == $data['login'] && $pass == md5($data['password'].$data['login'])) {
  30. $_SESSION['login'] = $log;
  31.  
  32. }
  33. }
  34.  
  35. }
  36.  
  37. if(!isset($_SESSION['login'])){
  38. echo "Неверный логин и/или пароль"."<br>";
  39. echo "Доступ закрыт"."<br>";
  40. ?>
  41. <a href="logout.php">Надо авторизироваться</a>
  42. <?php
  43. }else{
  44. $user = $pdo->prepare('SELECT * FROM users WHERE login = :login');
  45. $user->execute(array('login'=>$_SESSION['login']));
  46. $table = "<table><tr><td>login</td><td>password</td><td>fio</td><td>email</td><td>address</td>";
  47. while ($row = $user->fetch()) {
  48. $table .= "<tr>";
  49. $table .= "<td>".$row['login']."</td>";
  50. $table .= "<td>".$row['password']."</td>";
  51. $table .= "<td>".$row['fio']."</td>";
  52. $table .= "<td>".$row['email']."</td>";
  53. $table .= "<td>".$row['address']."</td>";
  54. $table .= "</tr>";
  55. }
  56. $table .= "</table> ";
  57. echo $table;
  58. echo "<br>";
  59. ?>
  60. <a href="logout.php">Выход</a>
  61. <?php
  62. }
  63. echo "<br>";
  64.  
  65. ?>
Add Comment
Please, Sign In to add comment