main.html

//main.html
<style>
td{text-align:center;}
.subject:hover{
    cursor:pointer;
    color:pink;
}
</style>
<table align='center' border='1'>
<col width='100px'>
<col width='500px'>
<tr>
    <td colspan='2'>게시판</td>
</tr>
<tr>
    <td>No</td><td>Subject</td>
</tr>
<?php
$db = new mysqli("localhost", "test", "test", "test");
$result = $db->query("SELECT * FROM board");
while($row = $result->fetch_assoc()) print "<tr>\n\t<td>$row[idx]</td><td class='subject' onclick=\"location='view.php?idx='+$row[idx]\">$row[subject]</td>\n</tr>";
?>
</table>
<?php
$db = new mysqli("localhost", "test", "test", "test");
$result = $db->query("SELECT * FROM board WHERE idx = '$_GET[idx]'");
if($db->affected_rows > 0){
$row = $result->fetch_assoc();
print <<< EOF
<table border="1" align="center">
<col width="50px">
<col width="500px">
<tr>
    <td>번호</td><td>$row[idx]</td>
</tr>
<tr>
    <td>제목</td><td>$row[subject]</td>
</tr>
<tr>
    <td>내용</td><td>$row[content]</td>
</tr>
<tr>
    <td colspan="2" align="center"><button onclick="location='main.php'">뒤로</button></td>
</tr>
<tr>
    <td colspan="2">QUERY:SELECT * FROM board WHERE idx = '$_GET[idx]'</td>
</tr>
</table>
EOF;
}else{
    print "ERROR";
    print "QUERY:SELECT * FROM board WHERE idx = '$_GET[idx]'";
}
?>