{"id":2341,"date":"2014-10-05T15:57:06","date_gmt":"2014-10-05T06:57:06","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/?p=2341"},"modified":"2016-05-30T11:41:33","modified_gmt":"2016-05-30T02:41:33","slug":"webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-6","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-6\/","title":{"rendered":"WebDB(II) \uc2e4\uc2b5\uc608\uc81c \uc18c\uc2a4 #6"},"content":{"rendered":"
<?php\r\nrequire '.\/dbConn.php';\r\n\r\n$link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\nif (!$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\nif (!$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\nif (!$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\nif (!$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\nmysqli_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-15.php<\/title>\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            \uc544\uc774\ub514 : <input type=\"text\" name=\"a\" value=\"<?=$row[\"userid\"]?>\" \/><br\/>\r\n            \ube44\ubc00\ubc88\ud638 : <input type=\"password\" name=\"b\" value=\"<?=$row[\"passwd\"]?>\"\/><br\/>\r\n            \uc131\uba85 : <input type=\"text\" name=\"c\" value=\"<?=$row[\"name\"]?>\"\/><br\/>\r\n            \uc774\uba54\uc77c : <input type=\"text\" name=\"d\" value=\"<?=$row[\"email\"]?>\"\/><br\/>\r\n            <input type=\"submit\" value=\"\ub4f1\ub85d\" \/>\r\n        <\/form>\r\n    <\/body>\r\n<\/html><\/pre>\n
<?php\r\nrequire '.\/dbConn.php';\r\n\r\n$link = mysqli_connect($dbHost, $dbUser, $dbPass); \/\/ MySQL \uc11c\ubc84 \uc5f0\uacb0\r\nif (!$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\nif (!$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\nif (!$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\nif (!$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\nmysqli_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><\/pre>\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\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        <a href=\".\/examSQL-13.php\">\ubaa9\ub85d\uc73c\ub85c<\/a>\r\n    <\/body>\r\n<\/html>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
<?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.<br\/>”; exit(); \/\/ \ud504\ub85c\uadf8\ub7a8 \uc885\ub8cc } $db = mysqli_select_db($link, $dbName); \/\/ Database \uc120\ud0dd if (!$db) { \/\/ DB\uc120\ud0dd\uc5d0 \uc2e4\ud328\ud55c \uacbd\uc6b0 ($!$db, $db!=true, $db==false \ubaa8\ub450 \ub3d9\uc77c) echo “{$dbName} \uc774\ub984\uc758\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-2341","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-BL","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2341","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=2341"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2341\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}