{"id":3775,"date":"2014-10-23T21:23:26","date_gmt":"2014-10-23T12:23:26","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/?p=3775"},"modified":"2016-06-13T10:13:39","modified_gmt":"2016-06-13T01:13:39","slug":"webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-10","status":"publish","type":"post","link":"https:\/\/www.happyfam.or.kr\/ysoh\/webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-10\/","title":{"rendered":"WebDB(II) \uc2e4\uc2b5\uc608\uc81c \uc18c\uc2a4 #10"},"content":{"rendered":"
<?php session_start(); ?>\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <title>examSQL-19.php<\/title>\r\n    <\/head>\r\n    <body>\r\n        <?php\r\n        require '.\/dbConn.php';\r\n\r\n        $link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\n        if (!$link) { \/\/ DB\uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!link, $link!=true, $link==false \ubaa8\ub450 \ub3d9\uc77c)\r\n            echo \"DB \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.\";\r\n            exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n        }\r\n\r\n        $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd\r\n        if (!$db) {  \/\/ DB\uc120\ud0dd\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$db, $db!=true, $db==false \ubaa8\ub450 \ub3d9\uc77c)\r\n            echo \"{$dbName} \uc774\ub984\uc758 DB\ub97c \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.\";\r\n            exit();  \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n        }\r\n\r\n        $char = mysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n        if (!$char) { \/\/ \ubb38\uc790\uc14b \uc124\uc815\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$char, $char!=true, $char==false \ubaa8\ub450 \ub3d9\uc77c)\r\n            echo \"UTF-8 \ubb38\uc790\uc14b\uc744 \uc124\uc815\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4.\";\r\n            exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n        }\r\n\r\n        $sql = \"SELECT `userid` FROM `user` WHERE `userid` = '{$_POST[\"a\"]}' AND `passwd` = '{$_POST[\"b\"]}'\";\r\n        echo $sql;\r\n\r\n        $result = mysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\n        if (!$result) { \/\/ SQL\uc5d0 \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0\r\n            echo \"SQL\uc5d0 \uc624\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4.\";\r\n            exit();     \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n        }\r\n\r\n        $num = mysqli_num_rows($result);\r\n        if ($num != 0) {\r\n            echo \"\uc778\uc99d\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\";\r\n            $row = mysqli_fetch_array($result);\r\n            $_SESSION[\"session_loginid\"] = $row[\"userid\"];\r\n        } else {\r\n            echo \"\uc778\uc99d\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.\";\r\n        }\r\n\r\n        mysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n        ?>\r\n        <a href=\".\/examSQL-13.php\">\ubaa9\ub85d\uc73c\ub85c<\/a>\r\n    <\/body>\r\n<\/html><\/pre>\n
<?php session_start(); ?>\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <style>\r\n            h1 {text-align: center;}\r\n            table {margin: 0 auto;}\r\n        <\/style>\r\n        <title>examSQL-13.php<\/title>\r\n    <\/head>\r\n    <body>\r\n        <h1>\ud68c\uc6d0\ubaa9\ub85d<\/h1>\r\n        <table>\r\n            <thead>\r\n                <tr>\r\n                    <th>\uc21c\ubc88<\/th>\r\n                    <th>\uc544\uc774\ub514<\/th>\r\n                    <th>\uc131\uba85<\/th>\r\n                    <th>\ube44\ubc00\ubc88\ud638<\/th>\r\n                    <th>\uc774\uba54\uc77c<\/th>\r\n                    <th>\ub3d9\uc791<\/th>\r\n                <\/tr>\r\n            <\/thead>\r\n            <tbody>\r\n                <?php\r\n                require '.\/dbConn.php';\r\n\r\n                $link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\n                if (!$link) { \/\/ DB\uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!link, $link!=true, $link==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                    echo \"DB \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n                    exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n                }\r\n\r\n                $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd\r\n                if (!$db) {  \/\/ DB\uc120\ud0dd\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$db, $db!=true, $db==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                    echo \"{$dbName} \uc774\ub984\uc758 DB\ub97c \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n                    exit();  \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n                }\r\n\r\n                $char = mysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n                if (!$char) { \/\/ \ubb38\uc790\uc14b \uc124\uc815\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$char, $char!=true, $char==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                    echo \"UTF-8 \ubb38\uc790\uc14b\uc744 \uc124\uc815\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n                    exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n                }\r\n\r\n                $sql = \"SELECT `userid`, `passwd`, `name`, `email` FROM `user`\";\r\n\r\n                $result = mysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\n                if (!$result) { \/\/ SQL\uc5d0 \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0\r\n                    echo \"SQL\uc5d0 \uc624\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n                    exit();     \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n                }\r\n\r\n                $no = 1;\r\n                while ($row = mysqli_fetch_array($result)) { \/\/ \ub8e8\ud504\ub97c \ub3cc\uba70 \uac80\uc0c9\ub41c \uacb0\uacfc\uc5d0\uc11c \ub9c8\uc9c0\ub9c9\uc774 \ub420 \ub54c\uae4c\uc9c0 \ub808\ucf54\ub4dc\ub97c \ud558\ub098\uc529 \uac00\uc838\uc634\r\n                    ?>\r\n                    <tr>\r\n                        <td><?= $no ?><\/td>\r\n                        <td><?= $row[\"userid\"] ?><\/td>\r\n                        <td><?= $row[\"passwd\"] ?><\/td>\r\n                        <td><?= $row[\"name\"] ?><\/td>\r\n                        <td><?= $row[\"email\"] ?><\/td>\r\n                        <td>\r\n                            <?php if ($_SESSION[\"session_loginid\"] == $row[\"userid\"]) { ?>\r\n                                <a href='.\/examSQL-14.php?userid=<?= $row[\"userid\"] ?>'>\uc0ad\uc81c<\/a>\r\n                            <?php } ?>\r\n                        <\/td>\r\n                        <td>\r\n                            <?php if ($_SESSION[\"session_loginid\"] == $row[\"userid\"]) { ?>\r\n                                <a href='.\/examSQL-16.php?userid=<?= $row[\"userid\"] ?>'>\uc218\uc815<\/a>\r\n                            <?php } ?>\r\n                        <\/td>\r\n                    <\/tr>\r\n                    <?php\r\n                    $no ++;\r\n                }\r\n\r\n                mysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n                ?>\r\n            <\/tbody>\r\n        <\/table>\r\n    <\/body>\r\n<\/html><\/pre>\n
<?php session_start(); ?>\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <title>examSQL-07.php<\/title>\r\n    <\/head>\r\n    <body>\r\n        <?php\r\n        require '.\/dbConn.php';\r\n        if ($_SESSION[\"session_loginid\"] == $_GET[\"userid\"]) {\r\n            $link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\n            if (!$link) { \/\/ DB\uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!link, $link!=true, $link==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                echo \"DB \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.\";\r\n                exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd\r\n            if (!$db) {  \/\/ DB\uc120\ud0dd\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$db, $db!=true, $db==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                echo \"{$dbName} \uc774\ub984\uc758 DB\ub97c \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.\";\r\n                exit();  \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $char = mysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n            if (!$char) { \/\/ \ubb38\uc790\uc14b \uc124\uc815\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$char, $char!=true, $char==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                echo \"UTF-8 \ubb38\uc790\uc14b\uc744 \uc124\uc815\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4.\";\r\n                exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $sql = \"DELETE FROM `user` WHERE `userid` = '{$_GET[\"userid\"]}'\";\r\n            echo $sql;\r\n\r\n            $result = mysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\n            if (!$result) { \/\/ SQL\uc5d0 \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0\r\n                echo \"SQL\uc5d0 \uc624\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4.\";\r\n                exit();     \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            mysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n        }\r\n        else {\r\n            echo \"\ub2e4\ub978 \uc0ac\uc6a9\uc790\uc758 \uc815\ubcf4\ub294 \uc0ad\uc81c\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.\";\r\n        }\r\n        ?>\r\n    <\/body>\r\n    <a href=\".\/examSQL-13.php\">\ubaa9\ub85d\uc73c\ub85c<\/a>\r\n<\/html><\/pre>\n
<?php\r\nsession_start();\r\n\r\nrequire '.\/dbConn.php';\r\n\r\nif ($_SESSION[\"session_loginid\"] == $_GET[\"userid\"]) {\r\n    $link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\n    if (!$link) { \/\/ DB\uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!link, $link!=true, $link==false \ubaa8\ub450 \ub3d9\uc77c)\r\n        echo \"DB \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n        exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n    }\r\n\r\n    $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd\r\n    if (!$db) {  \/\/ DB\uc120\ud0dd\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$db, $db!=true, $db==false \ubaa8\ub450 \ub3d9\uc77c)\r\n        echo \"{$dbName} \uc774\ub984\uc758 DB\ub97c \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n        exit();  \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n    }\r\n\r\n    $char = mysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n    if (!$char) { \/\/ \ubb38\uc790\uc14b \uc124\uc815\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$char, $char!=true, $char==false \ubaa8\ub450 \ub3d9\uc77c)\r\n        echo \"UTF-8 \ubb38\uc790\uc14b\uc744 \uc124\uc815\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n        exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n    }\r\n\r\n    $sql = \"SELECT `userid`, `passwd`, `name`, `email` FROM `user` WHERE `userid` = '{$_GET[\"userid\"]}'\";\r\n\r\n    $result = mysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\n    if (!$result) { \/\/ SQL\uc5d0 \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0\r\n        echo \"SQL\uc5d0 \uc624\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4.<br\/>\";\r\n        exit();     \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n    }\r\n\r\n    $row = mysqli_fetch_array($result); \/\/ \uac80\uc0c9\ub41c \ud68c\uc6d0\uc815\ubcf4\ub97c \uac00\uc838\uc634\r\n\r\n    mysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n    ?>\r\n    <!DOCTYPE html>\r\n    <html>\r\n        <head>\r\n            <meta charset=\"UTF-8\">\r\n            <title>examSQL-16.php<\/title>\r\n            <style>\r\n                .field-name {float:left; width:100px;text-align:right;}\r\n                .field-input input {margin-left: 10px;}\r\n            <\/style>\r\n        <\/head>\r\n        <body>\r\n            <h1>\ud68c\uc6d0\uc815\ubcf4\uc218\uc815<\/h1>\r\n            <form method=\"post\" action=\"examSQL-17.php\">\r\n                <div class=\"field-name\">\uc544\uc774\ub514 : <\/div>\r\n                <div class=\"field-input\"><input type=\"text\" value=\"<?= $row[\"userid\"] ?>\" disabled \/>\r\n                    <input type=\"hidden\" name=\"a\" value=\"<?= $row[\"userid\"] ?>\" \/><\/div>\r\n                <div class=\"field-name\">\ube44\ubc00\ubc88\ud638 : <\/div>\r\n                <div class=\"field-input\"><input type=\"password\" name=\"b\" value=\"<?= $row[\"passwd\"] ?>\"\/><\/div>\r\n                <div class=\"field-name\">\uc131\uba85 : <\/div>\r\n                <div class=\"field-input\"><input type=\"text\" name=\"c\" value=\"<?= $row[\"name\"] ?>\"\/><\/div>\r\n                <div class=\"field-name\">\uc774\uba54\uc77c : <\/div>\r\n                <div class=\"field-input\"><input type=\"text\" name=\"d\" value=\"<?= $row[\"email\"] ?>\"\/><\/div>\r\n                <div class=\"field-name\">&nbsp<\/div>\r\n                <div class=\"field-input\"><input type=\"submit\" value=\"\ub4f1\ub85d\" \/><\/div>\r\n            <\/form>\r\n        <\/body>\r\n    <\/html>\r\n    <?php\r\n}\r\n?><\/pre>\n
<?php session_start(); ?>\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <title>examSQL-17.php<\/title>\r\n    <\/head>\r\n    <body>\r\n        <?php\r\n        require '.\/dbConn.php';\r\n        if ($_SESSION[\"session_loginid\"] == $_GET[\"userid\"]) {\r\n            $link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\n            if (!$link) { \/\/ DB\uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!link, $link!=true, $link==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                echo \"DB \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.\";\r\n                exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd\r\n            if (!$db) {  \/\/ DB\uc120\ud0dd\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$db, $db!=true, $db==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                echo \"{$dbName} \uc774\ub984\uc758 DB\ub97c \ucc3e\uc744 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.\";\r\n                exit();  \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $char = mysqli_set_charset($link, \"utf8\"); \/\/ DB \ubb38\uc790\uc14b \uc124\uc815\r\n            if (!$char) { \/\/ \ubb38\uc790\uc14b \uc124\uc815\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$char, $char!=true, $char==false \ubaa8\ub450 \ub3d9\uc77c)\r\n                echo \"UTF-8 \ubb38\uc790\uc14b\uc744 \uc124\uc815\ud558\uc9c0 \ubabb\ud588\uc2b5\ub2c8\ub2e4.\";\r\n                exit();   \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $sql = \"UPDATE `user` SET `passwd` = '{$_POST[\"b\"]}', `name` = '{$_POST[\"c\"]}', `email` = '{$_POST[\"d\"]}' WHERE `userid` = '{$_POST[\"a\"]}'\";\r\n            echo $sql;\r\n\r\n            $result = mysqli_query($link, $sql); \/\/ SQL \uc2e4\ud589\r\n            if (!$result) { \/\/ SQL\uc5d0 \uc624\ub958\uac00 \uc788\ub294 \uacbd\uc6b0\r\n                echo \"SQL\uc5d0 \uc624\ub958\uac00 \uc788\uc2b5\ub2c8\ub2e4.\";\r\n                exit();     \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc\r\n            }\r\n\r\n            $num = mysqli_affected_rows($link);\r\n            if ($num == 0) {\r\n                echo \"\uc218\uc815\ub41c \ub0b4\uc6a9\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.\";\r\n            } else {\r\n                echo \"\uc815\ubcf4\uac00 \uc218\uc815\ub418\uc5c8\uc2b5\ub2c8\ub2e4.\";\r\n            }\r\n\r\n            mysqli_close($link); \/\/ MySQL \uc5f0\uacb0 \uc885\ub8cc\r\n        }\r\n        else {\r\n            echo \"\ub2e4\ub978 \uc0ac\uc6a9\uc790\uc758 \uc815\ubcf4\ub294 \uc218\uc815\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.\";\r\n        }\r\n        ?>\r\n        <a href=\".\/examSQL-13.php\">\ubaa9\ub85d\uc73c\ub85c<\/a>\r\n    <\/body>\r\n<\/html><\/pre>\n
<?php\r\nsession_start();\r\nsession_unset();\r\n?>\r\n<?php start_session() ?>\r\n<!DOCTYPE html>\r\n<html>\r\n    <head>\r\n        <meta charset=\"UTF-8\">\r\n        <title>examSQL-20.php<\/title>\r\n    <\/head>\r\n    <body>\r\n        \ub85c\uadf8\uc544\uc6c3 \ub418\uc5c8\uc2b5\ub2c8\ub2e4.\r\n    <\/body>\r\n<\/html><\/pre>\n","protected":false},"excerpt":{"rendered":"
<?php session_start(); ?> <!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <title>examSQL-19.php<\/title> <\/head> <body> <?php require ‘.\/dbConn.php’; $link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0 if (!$link) { \/\/ DB\uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!link, $link!=true, $link==false \ubaa8\ub450 \ub3d9\uc77c) echo “DB \uc5f0\uacb0\uc5d0 \uc2e4\ud328\ud588\uc2b5\ub2c8\ub2e4.”; exit(); \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc } $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd if (!$db) {\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[134,2],"tags":[233,21,34,40,53],"class_list":["post-3775","post","type-post","status-publish","format-standard","hentry","category-webdbii","category-2","tag-database","tag-html","tag-mysql","tag-php","tag-webdb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-YT","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/3775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/comments?post=3775"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/3775\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=3775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=3775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=3775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}