hello-programmer-world/public/sample/sql/list.php at fcdfffeebaa24661f3edecd6e4142928a8f4f746

Fork: 0

h.sakamoto / hello-programmer-world

Find file

Newer

Older

hello-programmer-world / public / sample / sql / list.php

h.sakamoto on 5 Feb 1 KB sql

Raw Blame History

<?php

define('DB_HOST', "db");
define("DB_PORT", "3306");
define('DB_USER', "user");
define('DB_PASSWORD', "password");
define('DB_NAME', "trainee_db");

define('DSN', "mysql:host=" . DB_HOST . ";port=" . DB_PORT . ";dbname=" . DB_NAME . ";charset=utf8mb4");

$dbh = new PDO(DSN, DB_USER, DB_PASSWORD);

// エラーが発生した場合に例外をスローする設定
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query = $dbh->query("SELECT * FROM sweepstakes");
$rows = $query->fetchAll(PDO::FETCH_ASSOC);

$dbh = null;

?>
<!DOCTYPE html>
<html lang="ja">

<head>
  <meta charset="UTF-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <title>応募一覧</title>
  <link rel="stylesheet" href="./styles.css">
</head>

<body>
  <h1>応募一覧</h1>
  <div class="container">
    <table class="bordered-table">
      <tr>
        <th>ID</th>
        <th>お名前</th>
        <th>住所</th>
        <th>応募商品</th>
        <th>応募日時</th>
      </tr>

      <?php foreach ($rows as $row): ?>
      <tr>
        <td>
          <?php echo $row["id"]; ?>
        </td>
        <td>
          <?php echo $row["name"]; ?>
        </td>
        <td>
          <?php echo $row["address"]; ?>
        </td>
        <td>
          <?php echo $row["product"]; ?>
        </td>
        <td>
          <?php echo $row["created_at"]; ?>
        </td>
      </tr>
      <?php endforeach; ?>
    </table>

    <a href="./form.html">応募ページへ</a>
  </div>
</body>

</html>