Advertisement
Guest User

Untitled

a guest
Aug 4th, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.18 KB | None | 0 0
  1. <?php
  2. error_reporting(-1);
  3. ini_set('display_errors', true);
  4. $dbHost = "localhost";
  5. $dbUsername = "DBUser";
  6. $dbPassword = "DBPassword";
  7. $dbName = "DBName";
  8. $dbCharset = "utf-8";
  9. $dsn = sprintf("mysql:host=%s;dbname=%s;charset=%s", $dbHost, $dbName);
  10. try {
  11.     $db = new Pdo($dsn, $dbUsername, $dbPassword);
  12.     $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  13.  
  14. } catch (Exception $e) {
  15.     die("Failed to connect to database: error" . $e->getMessage());
  16. }
  17.  
  18. $login = "Gena";
  19. $sql = "SELECT * FROM users WHERE name = " . $db->quote($login);
  20. try {
  21.     $statement = $db->query($sql);
  22. } catch (PDOException $e) {
  23.     die("Failed to execute SQL Command: " . $sql . " <br/> error: " . $e->getMessage());
  24. }
  25.  
  26. if ($statement->rowCount() === 0) {
  27.     die("User '" . $login . "' not found");
  28. }
  29.  
  30. $rows = $statement->fetchAll(PDO::FETCH_ASSOC);
  31. header('Content-Type:text/html;charset=utf-8')
  32. ?>
  33.  
  34. <!DOCTYPE html>
  35. <html>
  36. <head>
  37.     <title>Users</title>
  38.     <meta charset="UTF-8">
  39. </head>
  40. <body>
  41. <ul>
  42.     <?php foreach ($rows as $row): ?>
  43.         <li><?= $row["name"] ?>: <?= $row["age"] ?>: <?= $row["sity"] ?></li>
  44.     <?php endforeach; ?>
  45. </ul>
  46. </body>
  47. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement