php select 데이터 뿌리기

dev/PHP + MYSQL
php select 데이터 뿌리기

dev_0hoon 2021. 8. 7. 16:31
<?php
        $conn = mysqli_connect('localhost','root','manager','opentutorials');

        $sql = 'SELECT * FROM topic';
        $result = mysqli_query($conn,$sql);
        $list='';
        while($row = mysqli_fetch_array($result)){
            //
            $list = $list."<li><a href=\"index.php?id={$row['id']}\">{$row['title']}</a></li>";
        }    

        //파라미터값이 없을 경우 오류가 나기 때문에 미리 만들어준다. 
        $article = array(
            'title' =>'welcome',
            'description' =>'Hello, web'
        );
        if(isset($_GET['id'])){

            $sql = "SELECT * FROM topic WHERE id={$_GET['id']}";
            $result = mysqli_query($conn,$sql);
            $row = mysqli_fetch_array($result);
            $article['title'] = $row['title'];
            $article['description'] = $row['description'];
        }
            ?>

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>WEB</title>
    </head>
    <body>
        
        <h1><a href="index.php">WEB</a></h1>
        <ol>
            <?=$list?>
        </ol>
        <a href="create.php">create</a>
        <h2><?=$article['title']?></h2>
        <?=$article['description']?>
    </body>
</html>