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="precess.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>
댓글 1개