Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- error_reporting(-1);
- ini_set('display_errors', true);
- $dbHost = "localhost";
- $dbUsername = "DBUser";
- $dbPassword = "DBPassword";
- $dbName = "DBName";
- $dbCharset = "utf-8";
- $dsn = sprintf("mysql:host=%s;dbname=%s;charset=%s", $dbHost, $dbName);
- try {
- $db = new Pdo($dsn, $dbUsername, $dbPassword);
- $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- } catch (Exception $e) {
- die("Failed to connect to database: error" . $e->getMessage());
- }
- $login = "Gena";
- $sql = "SELECT * FROM users WHERE name = " . $db->quote($login);
- try {
- $statement = $db->query($sql);
- } catch (PDOException $e) {
- die("Failed to execute SQL Command: " . $sql . " <br/> error: " . $e->getMessage());
- }
- if ($statement->rowCount() === 0) {
- die("User '" . $login . "' not found");
- }
- $rows = $statement->fetchAll(PDO::FETCH_ASSOC);
- header('Content-Type:text/html;charset=utf-8')
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <title>Users</title>
- <meta charset="UTF-8">
- </head>
- <body>
- <ul>
- <?php foreach ($rows as $row): ?>
- <li><?= $row["name"] ?>: <?= $row["age"] ?>: <?= $row["sity"] ?></li>
- <?php endforeach; ?>
- </ul>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement