<step48>'php_sql연동'

노력이 좋아서

<step48>'php_sql연동'

zoaseo 2022. 5. 26. 14:38

1) ex09_mysqli.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <?php
        echo "Mysql연결테스트<br>";
        // mysqli_connect("호스트주소", "아이디", "비밀번호", "데이터베이스명");
        $db = mysqli_connect("localhost", "root", "0115", "test");
        if($db){
            echo "성공<br>";
        }else {
            echo "실패<br>";
        }
        $query = "insert into members(name, tel, addr, license) 
        values('하율', '010-1234-4567', '울산시 북구', 'y');";
        $result = mysqli_query($db, $query);
        if($result){
            echo "전송되었습니다.<br>";
        }else {
            echo "전송되지 않았습니다.<br>";
        }
    ?>
</body>
</html>

2) ex10_select.php

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    <?php
        $conn = mysqli_connect('localhost', 'root', '0115', 'test');
        echo "<h1>한줄 조회하기</h1>";
        //쿼리문 작성 후 sql에 할당
        $sql = "select * from members where no = 3";
        $result = mysqli_query($conn, $sql);

        // mysqli_fetch_array
        //php에서 사용가능한 데이터 형태로 변경(배열)
        $row = mysqli_fetch_array($result);
        var_dump($row);
        echo "<p>{$row['addr']}</p>";

        //여러줄 select
        $sqlMul = "select * from members";
        $result2 = mysqli_query($conn, $sqlMul);
        echo "여기서부터 전체 조회";
        while($row2 = mysqli_fetch_array($result2)){
            echo "<p>{$row2['addr']}</p>";
        }
    ?>
</body>
</html>