PHP_Life

mysql select 자료 출력

<?php include "database.php"; ?>
<?php
  //Create Select Query
  $query = "SELECT * FROM shout";
  $shouts = mysqli_query($con, $query);
?>
<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Talk and Talk</title>
    <link rel="stylesheet" href="css/style.css" type="text/css" />
  </head>
  <body>
    <div id="container">
      <header>
        <h1>Talk And Talk</h1>
      </header>
      <div id="shouts">
        <ul>
          <?php while($row = mysqli_fetch_assoc($shouts)) : ?>
              <li class="shout"><span><?php echo $row['time'] ?> - </span><strong><?php echo $row['user'] ?>:</strong> <?php echo $row['message'] ?></li>
          <? endwhile; ?>
        </ul>
      </div>
      <div id="input">
        <form action="process.php" method="post">
          <input type="text" name="user" placeholder="이름을 입력하세요" />
          <input type="text" name="message" placeholder="메세지를 입력하세요" />
          <br />
          <input class="shout-btn" type="submit" name="submit" value="글쓰기">
        </form>
      </div>
    </div>
  </body>
</html>

 

댓글

댓글 본문
작성자
비밀번호
버전 관리
Frank
현재 버전
선택 버전
graphittie 자세히 보기