Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang='en'>
- <head>
- <meta charset="UTF-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <title>Site</title>
- <style>
- h1{
- color: blue;
- border: 1px red;
- text-align: center;
- }
- .even{
- background-color: brown;
- text-align: center;
- }
- .even:hover{
- background-color: darkorange;
- text-align: center;
- }
- .odd{
- background-color: dodgerblue;
- text-align: center;
- }
- div{
- width: 50%;
- margin: auto;
- }
- .password{
- background-color: darkorange;
- text-align: center;
- font-size: 50px;
- color: lightgreen;
- }
- .password:hover{
- background-color: dodgerblue;
- }
- </style>
- </head>
- <body>
- <h1>Passwords</h1>
- <div>
- <?php
- $servername = "localhost";
- $username = "root";
- $password = "valio.28122003";
- $db = new PDO("mysql:host=$servername;dbname=project173", $username, $password);
- // set the PDO error mode to exception
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $query = "SELECT password FROM users";
- $pdo = $db->prepare($query);
- $pdo->execute();
- echo "<pre>";
- $data = $pdo->fetchAll();
- //var_dump($data);
- echo "<pre>";
- for($i = 0; $i < count(data); $i++){
- if($i % 2 == 0){
- echo "<p class=\"even\">" . $i . "</p>";
- }else{
- echo "<p class=\"odd\">" . $i . "</p>";
- }
- echo "<p class=\"password\">" . $data[$i][0] . "</p>";
- }
- ?>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment