index.php

<?php

include "header.php";
include "db.php";

// echo "PHP 테스트"
?>


<!-- body 시작부분 -->

<div id="wrap">
    <div id="header">
       
        <div id="login_info">
            <h3>홍길동님 환영합니다! </h3>
        </div>

        <div id="login_form">
            <form action="login_ok.php" method="post">
                <ul>
                    <!-- placeholder: 힌트 require: 필수 입력 지정  -->
                <li><input type="text" name="userid" placeholder="아이디" require></li>
                <li><input type="text" name="userpw" placeholder="비밀번호" require></li>
                <li><input type="submit" value="로그인"></li>
                <li><a href="/board/join_form.php">회원가입하기 </a></li>
                </ul>
            </form>
        </div>
    </div>

    <div id="board_list">
        <table class="list_table">
            <thead>
                <tr>
                    <th width="70">번호</th>
                    <th width="100">제목</th>
                    <th width="120">글쓴이</th>
                    <th width="100">작성일</th>
                </tr>
            </thead>
            <tbody>
                <!-- 최대 10개 -->
                    <?php
                    //idx 기준 내림차순(최신글) 최대 5개만 가져옴 
                    $sql="SELECT * FROM board ORDER BY idx desc limit 0,5";
                    $result=req_query($sql);
                    while($row=$result->fetch_array(MYSQLI_BOTH)){
                            echo "<tr>";
                            echo "<td>". $row["idx"]. "</td>";
                            echo "<td>". $row["name"]. "</td>";
                            echo "<td>". $row["title"]. "</td>";
                            // echo "<td>". $row["content"]. "</td>";
                            echo "<td>". $row["date"]. "</td>";

                            // echo $row["idx"].",".$row["name"].",".$row["title"].",".$row["content"].",".$row["date"]."<br />";
                            echo "</tr>";
                    }

                    $result->free();
                    $db->close();


                    ?>



                <!-- <tr>
                    <td>0</td>
                    <td>타이틀입니다.</td>
                    <td>hong</td>
                    <td>2019.11.25</td>
                </tr>     

                <tr>
                    <td>1</td>
                    <td>타이틀입니다.</td>
                    <td>hong2</td>
                    <td>2019.11.25</td>
                </tr>       -->

            </tbody>
        </table>

        <div id="write_btn">
            <a href="/board/write.php"><button>글쓰기</button></a>
        
        </div>
    </div>
</div>
</body>
</html>