{"id":2303,"date":"2014-09-22T17:02:23","date_gmt":"2014-09-22T08:02:23","guid":{"rendered":"http:\/\/www.happyfam.or.kr\/ysoh\/?p=2303"},"modified":"2016-06-01T11:34:06","modified_gmt":"2016-06-01T02:34:06","slug":"webdbii-%ec%8b%a4%ec%8a%b5%ec%98%88%ec%a0%9c-%ec%86%8c%ec%8a%a4-4","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-4\/","title":{"rendered":"WebDB(II) \uc2e4\uc2b5\uc608\uc81c \uc18c\uc2a4 #4"},"content":{"rendered":"
\"examSQL-10\"<\/a>

\ud68c\uc6d0\ubaa9\ub85d \ucd9c\ub825\ud615\ud0dc<\/p><\/div>\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-10.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                <tr>\r\n                    <td>1<\/td>\r\n                    <td>hong<\/td>\r\n                    <td>\ud64d\uae38\ub3d9<\/td>\r\n                    <td>hong<\/td>\r\n                    <td>hong@nomail.plz<\/td>\r\n                    <td>\r\n                        <a href=\".\/examSQL-14.php\">\uc0ad\uc81c<\/a>\r\n                        <a href=\".\/examSQL-15.php\">\uc218\uc815<\/a>\r\n                    <\/td>\r\n                <\/tr>\r\n                <tr>\r\n                    <td>2<\/td>\r\n                    <td>yskim<\/td>\r\n                    <td>\uae40\uc601\uc0bc<\/td>\r\n                    <td>yskim<\/td>\r\n                    <td>yskim@nomail.plz<\/td>\r\n                    <td>\r\n                        <a href=\"examSQL-14.php\">\uc0ad\uc81c<\/a>\r\n                        <a href=\"examSQL-15.php\">\uc218\uc815<\/a>\r\n                    <\/td>\r\n                <\/tr>\r\n                <tr>\r\n                    <td>3<\/td>\r\n                    <td>ysoh<\/td>\r\n                    <td>\uc624\uc601\uc218<\/td>\r\n                    <td>ysoh<\/td>\r\n                    <td>ysoh@nomail.plz<\/td>\r\n                    <td>\r\n                        <a href=\"examSQL-14.php\">\uc0ad\uc81c<\/a>\r\n                        <a href=\"examSQL-15.php\">\uc218\uc815<\/a>\r\n                    <\/td>\r\n                <\/tr>\r\n            <\/tbody>\r\n        <\/table>\r\n    <\/body>\r\n<\/html>\r\n<\/pre>\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-11.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                    echo \"<tr>\";\r\n                    echo \"<td>$no<\/td>\";\r\n                    echo \"<td>{$row[\"userid\"]}<\/td>\"; \/\/ \ud544\ub4dc\uba85\uc744 \ud0a4\ub85c\ud558\uc5ec \uc6d0\ud558\ub294 \ub370\uc774\ud130\uc5d0 \uc811\uadfc\r\n                    echo \"<td>{$row[\"passwd\"]}<\/td>\";\r\n                    echo \"<td>{$row[\"name\"]}<\/td>\";\r\n                    echo \"<td>{$row[\"email\"]}<\/td>\";\r\n                    echo \"<td><a href='.\/examSQL-14.php'>\uc0ad\uc81c<\/a><\/td>\";\r\n                    echo \"<td><a href='.\/examSQL-15.php'>\uc218\uc815<\/a><\/td>\";\r\n                    echo \"<\/tr>\";\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>\r\n<\/pre>\n
\"examSQL-11\"<\/a>
examSQL-11.php \uc2e4\ud589\uacb0\uacfc<\/p><\/div>\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-12.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\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><a href='.\/examSQL-14.php'>\uc0ad\uc81c<\/a><\/td>\r\n                        <td><a href='.\/examSQL-15.php'>\uc218\uc815<\/a><\/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>\r\n<\/pre>\n
\"examSQL-12\"<\/a>
examSQL-12.php \uc2e4\ud589\uacb0\uacfc<\/p><\/div>\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><a href='.\/examSQL-14.php?userid=<?= $row[\"userid\"] ?>'>\uc0ad\uc81c<\/a><\/td>\r\n                        <td><a href='.\/examSQL-15.php?userid=<?= $row[\"userid\"] ?>'>\uc218\uc815<\/a><\/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
\"examSQL-13\"<\/a>
examSQL-13.php \uc2e4\ud589\uacb0\uacfc<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
<!DOCTYPE html> <html> <head> <meta charset=”UTF-8″> <style> h1 {text-align: center;} table {margin: 0 auto;} <\/style> <title>examSQL-10.php<\/title> <\/head> <body> <h1>\ud68c\uc6d0\ubaa9\ub85d<\/h1> <table> <thead> <tr> <th>\uc21c\ubc88<\/th> <th>\uc544\uc774\ub514<\/th> <th>\uc131\uba85<\/th> <th>\ube44\ubc00\ubc88\ud638<\/th> <th>\uc774\uba54\uc77c<\/th> <th>\ub3d9\uc791<\/th> <\/tr> <\/thead> <tbody> <tr> <td>1<\/td> <td>hong<\/td> <td>\ud64d\uae38\ub3d9<\/td> <td>hong<\/td> <td>hong@nomail.plz<\/td> <td> <a href=”.\/examSQL-14.php”>\uc0ad\uc81c<\/a> <a href=”.\/examSQL-15.php”>\uc218\uc815<\/a> <\/td> <\/tr> <tr> <td>2<\/td> <td>yskim<\/td> <td>\uae40\uc601\uc0bc<\/td> <td>yskim<\/td> <td>yskim@nomail.plz<\/td> <td> <a href=”examSQL-14.php”>\uc0ad\uc81c<\/a> <a href=”examSQL-15.php”>\uc218\uc815<\/a>\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":3,"featured_media":2323,"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-2303","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-webdbii","category-2","tag-database","tag-html","tag-mysql","tag-php","tag-webdb"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.happyfam.or.kr\/ysoh\/wp-content\/uploads\/sites\/3\/2014\/09\/examSQL-10.png?fit=492%2C323&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p776QY-B9","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2303","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=2303"}],"version-history":[{"count":0,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/posts\/2303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media\/2323"}],"wp:attachment":[{"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/media?parent=2303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/categories?post=2303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.happyfam.or.kr\/ysoh\/wp-json\/wp\/v2\/tags?post=2303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}