Valeri173

Untitled

Apr 20th, 2021
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang='en'>
  3. <head>
  4. <meta charset="UTF-8">
  5. <meta http-equiv="X-UA-Compatible" content="IE=edge">
  6. <meta name="viewport" content="width=device-width, initial-scale=1.0">
  7. <title>Site</title>
  8.  
  9. <style>
  10. h1{
  11. color: blue;
  12. border: 1px red;
  13. text-align: center;
  14. }
  15.  
  16. .even{
  17. background-color: brown;
  18. text-align: center;
  19. }
  20.  
  21. .even:hover{
  22. background-color: darkorange;
  23. text-align: center;
  24. }
  25.  
  26. .odd{
  27. background-color: dodgerblue;
  28. text-align: center;
  29. }
  30.  
  31. div{
  32. width: 50%;
  33. margin: auto;
  34. }
  35.  
  36. .password{
  37. background-color: darkorange;
  38. text-align: center;
  39. font-size: 50px;
  40. color: lightgreen;
  41. }
  42.  
  43. .password:hover{
  44. background-color: dodgerblue;
  45. }
  46. </style>
  47. </head>
  48.  
  49. <body>
  50. <h1>Passwords</h1>
  51. <div>
  52. <?php
  53. $servername = "localhost";
  54. $username = "root";
  55. $password = "valio.28122003";
  56.  
  57. $db = new PDO("mysql:host=$servername;dbname=project173", $username, $password);
  58. // set the PDO error mode to exception
  59. $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  60.  
  61. $query = "SELECT password FROM users";
  62. $pdo = $db->prepare($query);
  63. $pdo->execute();
  64.  
  65. echo "<pre>";
  66. $data = $pdo->fetchAll();
  67. //var_dump($data);
  68. echo "<pre>";
  69.  
  70. for($i = 0; $i < count(data); $i++){
  71. if($i % 2 == 0){
  72. echo "<p class=\"even\">" . $i . "</p>";
  73. }else{
  74. echo "<p class=\"odd\">" . $i . "</p>";
  75. }
  76. echo "<p class=\"password\">" . $data[$i][0] . "</p>";
  77. }
  78. ?>
  79. </div>
  80. </body>
  81. </html>
Advertisement
Add Comment
Please, Sign In to add comment