01/hello.php
02/hello.php
02/comment.php
02/var.php
02/echo.php
02/quot.php
02/quot1.php
02/quot2.php
02/quot3.php
02/quot4.php
02/echo_error.php
02/echo_abb.php
02/number.php
02/string.php
02/bool.php
02/arith.php
02/string_merge.php
02/replace.php
03/even_odd.php
03/free_fee.php
03/besu.php
03/is_login.php
03/weight_control.php
03/grade.php
03/park_fee.php
03/num3.php
03/man_age.php
03/food_fee.php
03/food_fee_if.php
04/print_1_10_while.php
04/sum_1_10_while.php
04/besu_100_300_while.php
04/besu3_no_1_100_while.php
04/inch_to_cm_while.php
04/gugudan_2_while.php
04/print_1_10_for.php
04/sum_1_10_for.php
04/sum_besu_5_for.php
04/besu_4_no_for.php
04/c_to_f_for.php
04/gugudan1_for.php
04/gugudan2_for.php
04/star1_for.php
04/star2_for.php
04/total_1_10_while.php
04/total_1_10_do_while.php
04/print_10_do_while.php
04/print_10_while.php
05/array_avg.php
05/array_func.php
05/array_gugudan.php
05/bubble_sort.php
05/array_2d_avg.php
06/func_hello.php
06/func_plus.php
06/func_plus_ret.php
06/func_sum.php
06/func_man_age.php
06/func_park_fee.php
06/func_string.php
07/form.html
07/view.php
07/id_password.html
07/view2.php
07/textarea.html
07/view3.php
07/radio.html
07/view4.php
07/checkbox.html
07/view5.php
07/select.html
07/view6.php
07/hidden.html
07/view7.php
07/file_upload.html
07/view8.php
07/board1.php
07/board2.php
07/board_view.php
08/cookie_set.php
08/cookie_use.php
08/cookie_delete.php
08/session_set.php
08/session_use.php
08/session_delete.php
09/mem.sql
10/friend.sql
10/member.sql
10/sample.sql
part3/index.php
part3/member_form.php
part3/member_insert.php
part3/member_check_id.php
part3/login_form.php
part3/js/login.js
part3/login.php
part3/header.php
part3/footer.php
part3/logout.php
part3/member_modify_form.php
part3/member_modify.php
part3/message_form.php
part3/message_insert.php
part3/message_box.php
part3/message_view.php
part3/message_delete.php
part3/message_response_form.php
part3/board_form.php
part3/board_insert.php
part3/board_list.php
part3/board_view.php
part3/board_download.php
part3/board_modify_form.php
part3/board_modify.php
part3/board_delete.php
part3/main.php
part3/admin.php
part3/admin_member_update.php
part3/admin_member_delete.php
part3/admin_board_delete.php
part3/data/2018_12_30_20_07_45.php
part3/data/2018_12_31_01_52_52.php
part3/data/2018_12_31_02_20_34.php
part3/data/2018_12_31_02_22_35.php
part3/data/2018_12_31_02_23_20.php
part3/data/2018_12_31_02_34_28.php
¢¸ ÀÌÀü
´ÙÀ½ ¢º
(¼¹ö¿¡¼ ¼öÇàµÊ)
create table mem ( num int not null, id char(15) not null, name char(10) not null, sex char(1), post_num char(8), address char(80), tel char(20), age int, primary key(num) ); insert into mem values (1, 'yjhwang', 'Ȳ¿µÁÖ', 'M', '100-011', '¼¿ï½Ã Áß±¸ Ã湫·Î1°¡', '234-8879', 35); insert into mem values (2, 'khshul', '¼³±âÇü', 'M', '607-010', 'ºÎ»ê½Ã µ¿·¡±¸ ¸í·ûµ¿', '764-3784', 33); insert into mem values (3, 'chpark', '¹Úöȣ', 'M', '503-200', '±¤Áֽà ³²±¸ Áö¼®µ¿', '298-9730', 34); insert into mem values (4, 'shlee', 'ÀÌ»óÈÆ', 'M', '503-201', '±¤Áֽà ³²±¸ µµ±Ýµ¿', '838-4347', 32); insert into mem values (5, 'jyjang', 'À念¼÷', 'W', '606-065', 'ºÎ»ê½Ã ¿µµµ±¸ ºÀ·¡µ¿5°¡', '399-9809', 24); insert into mem values (6, 'yjbae', '¹è¿ëÁø', 'M', '122-014', '¼¿ï½Ã ÀºÆò±¸ ÀÀ¾Ï4µ¿', '857-5683', 30); insert into mem values (7, 'hbpark', '¹ÚÇýºó', 'W', '427-760', '°æ±âµµ °úõ½Ã Áß¾Óµ¿', '234-7677', 22); insert into mem values (8, 'mskim', '±è¹®¼ö', 'M', '429-020', '°æ±âµµ ½ÃÈï½Ã ½Åõµ¿', '370-6003', 63); insert into mem values (9, 'bkcha', 'Â÷¹ü±æ', 'M', '302-121', '´ëÀü½Ã ¼±¸ µÐ»ê1µ¿', '432-9877', 49); insert into mem values (10, 'kskim', '±è±æ¼ö', 'M', '440-747', '°æ±âµµ ¼ö¿ø½Ã Àå¾È±¸ ÆÄÀ嵿', '324-5875', 54); insert into mem values (11, 'srkim', '±è¼ö·Ã', 'M', '704-701', '´ë±¸½Ã ´Þ¼±¸ ½Å´çµ¿', '987-3688', 23); insert into mem values (12, 'shlee', 'À̼ºÇö', 'M', '441-081', '°æ±âµµ ¼ö¿ø½Ã ±Ç¼±±¸ ¸Å»ê·Î1°¡', '243-6844', 36); insert into mem values (13, 'hnjang', 'Á¤Çѳª', 'W', '502-763', '±¤Áֽà ¼±¸ ÈÁ¤4µ¿', '845-4547', 58); insert into mem values (14, 'mylee', 'ÀÌ¸í¿¬', 'W', '502-791', '±¤Áֽà ¼±¸ ½ÖÃ̵¿', '837-9432', 33); insert into mem values (15, 'yskim', '±è¿µ¼÷', 'W', '429-010', '°æ±âµµ ½ÃÈï½Ã ´ë¾ßµ¿', '374-8438', 53); insert into mem values (16, 'jekim', '±èÁ¤Àº', 'W', '503-202', '±¤Áֽà ³²±¸ ¿ø»êµ¿', '347-8873', 29); insert into mem values (17, 'yjko', '°í¿µÁÖ', 'W', '122-020', '¼¿ï½Ã ÀºÆò±¸ ³ì¹øµ¿', '479-3874', 32); insert into mem values (18, 'cyahn', '¾Èö¿µ', 'M', '122-030', '¼¿ï½Ã ÀºÆò±¸ ´ëÁ¶µ¿', '347-4687', 34); insert into mem values (19, 'jmkim', '±èÁø¸ð', 'M', '530-140', 'Àü¶ó³²µµ ¸ñÆ÷½Ã Ç×µ¿', '379-8349', 28); insert into mem values (20, 'ycshul', '¼³¿µÂù', 'M', '606-070', 'ºÎ»ê½Ã ¿µµµ±¸ ûÇе¿', '983-8748', 41); insert into mem values (21, 'jjko', '°íÀçÁø', 'M', '100-013', '¼¿ï½Ã Áß±¸ Ã湫·Î3°¡', '836-4655', 28); insert into mem values (22, 'hwlee', 'ÀÌÇö¿ì', 'M', '606-071', 'ºÎ»ê½Ã ¿µµµ±¸ ûÇÐ1µ¿', '346-8892', 32); insert into mem values (23, 'cskang', '°Âù¼÷', 'W', '668-890', '°æ»ó³²µµ ³²Çرº ¼³Ãµ¸é', '377-6879', 21); insert into mem values (24, 'ypji', 'Áö¿µÇÊ', 'M', '122-040', '¼¿ï½Ã ÀºÆò±¸ ºÒ±¤µ¿', '366-3747', 52); insert into mem values (25, 'jbkim', '±èÁø¹è', 'M', '427-600', '°æ±âµµ °úõ½Ã °úõµ¿', '382-4993', 47); insert into mem values (26, 'jepark', '¹ÚÁöÀº', 'W', '670-800', '°æ»ó³²µµ °Åⱺ °ÅâÀ¾', '328-8743', 26); insert into mem values (27, 'jhlee', 'ÀÌÁöÇö', 'W', '704-702', '´ë±¸½Ã ´Þ¼±¸ ¿ù¼ºµ¿', '386-7988', 27); insert into mem values (28, 'bykang', '°ºÎ¿µ', 'M', '302-120', '´ëÀü½Ã ¼±¸ µÐ»êµ¿', '798-3243', 62); insert into mem values (29, 'jymoon', '¹®Áø¿µ', 'W', '302-122', '´ëÀü½Ã ¼±¸ µÐ»ê2µ¿', '987-3248', 18); insert into mem values (30, 'jyjun', 'ÀüÁö¿¬', 'W', '100-012' , '¼¿ï½Ã Áß±¸ Ã湫·Î2°¡', '347-2236', 28); insert into mem values (31, 'jkko', '°íÁø±æ', 'M', '122-013', '¼¿ï½Ã ÀºÆò±¸ ÀÀ¾Ï3µ¿', '234-7466', 27); insert into mem values (32, 'myjung', 'Á¤¸íÀ±', 'M', '502-771', '±¤Áֽà ¼±¸ Ä¡Æòµ¿', '374-8786', 47); insert into mem values (33, 'jsyou', 'À¯Áö¼ö', 'W', '502-772', '±¤Áֽà ¼±¸ Ä¡Æòµ¿', '309-3897', 49); insert into mem values (34, 'dsshin', '½Å´Þ¼º', 'W', '530-145', 'Àü¶ó³²µµ ½Å¾È±º Àå»ê¸é', '399-8789', 53); insert into mem values (35, 'sjshin', '½Å¼öÁø', 'W', '606-796', 'ºÎ»ê½Ã ¿µµµ±¸ ºÀ·¡µ¿5°¡', '389-8930', 47);