PHP 기초 게시판 만들기

sample 데이터베이스에 board라는 테이블을 만듭니다.

 

 

mysqli_fetch_array() 함수로 쿼리 결과 중 하나의 행(row)을 배열 형태로 얻어옵니다.

그 결과를 $row 변수에 저장하고 <tr> 태그로 새로운 행을 만든 후 <td> 태그로 셸을 생성합니다.

 

 

<?php

if(isset($_POST['write'])){
$username = $_POST['username'];
$title = $_POST['title'];
$comment = $_POST['comment'];
$date = date("Y-m-d");
$file = NULL;

$con = mysqli_connect("localhost","root","apmsetup","sample");
$result = mysqli_query($con,"insert into board(user,title,comment,file,date)values
('$username','$title','$comment','$file','$date')");
}

else{
?>
<form action="" method=post>
<table>
<tr><td>subject</td><td><input type=text name=title></td></tr>
<tr><td>name</td><td><input type=text name=username></td></tr>
<tr><td>content</td><td><textarea cols=30 rows=8 name=comment></textarea></td></tr>
</table>
<input type=submit value=save name=write>
</form>
<?php }?>

 

---

<?php

$id = $_GET['id'];
$con = mysqli_connect('localhost','root','apmsetup','sample');
$result = mysqli_query($con,"select * from board where id=".$id);

$row = mysqli_fetch_array($result);
?>

<table width=400 border=1px cellpadding=2 style=border-collapse:collapse>
<tr><td align=center>subject</td><td><?=$row['title']?></td></tr>
<tr><td align=center>name</td><td><?=$row['user']?></td></tr>
<tr><td align=center>date</td><td><?=$row['date']?></td></tr>
<tr><td align=center>content</td><td><?=$row['comment']?></td></tr>

---

<input type=button value=write onclick=location.href="write.php">

<table width=580 border=1px cellpadding=2 style=border-collapse:collapse>
<thead>
<tr align=center>
<th width=30>number</th>
<th width=300>title</th>
<th width=50>name</th>
<th width=60>date</th>
</tr>
</thead>

<?php
$con = mysqli_connect("localhost","root","apmsetup","sample");
$result = mysqli_query($con,"select * from board order by id desc");
while($row = mysqli_fetch_array($result)){
?>
<tr align=center>
<td><?=$row['id']?></td>
<td><a href=view.php?id=<?=$row['id']?>><?=$row['title']?></a></td>
<td><?=$row['user']?></td>
<td><?=$row['date']?></td>
</tr>

<?php
}
?>
</table>