{"id":2334,"date":"2018-09-27T21:30:17","date_gmt":"2018-09-27T12:30:17","guid":{"rendered":"https:\/\/now0930.tk\/wordpress\/?p=2334"},"modified":"2018-09-27T21:33:42","modified_gmt":"2018-09-27T12:33:42","slug":"openface%eb%a1%9c-%ec%96%bc%ea%b5%b4-%ed%8c%90%eb%b3%84","status":"publish","type":"post","link":"https:\/\/now0930.pe.kr\/wordpress\/openface%eb%a1%9c-%ec%96%bc%ea%b5%b4-%ed%8c%90%eb%b3%84\/","title":{"rendered":"openface\ub85c \uc5bc\uad74 \ud310\ubcc4"},"content":{"rendered":"

\ud734\ub300\ud3f0\uc73c\ub85c \uc0ac\uc9c4\uc744 \uc5f4\uc2ec\ud788 \ubaa8\uc558\uc9c0\ub9cc, \ub108\ubb34 \ub9ce\uc544 \ud0dc\uadf8\ub97c \uc785\ub825\ud560 \uc5c4\ub450\uac00 \ub098\uc9c0 \uc54a\uc558\ub2e4. \uc785\ub825\ud560 \ub54c \ud30c\uc77c\uc758 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud558\uc5ec \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc815\ub9ac\ud588\ub2e4. \uc5b8\uc820\uac00 \uc5bc\uad74\uc744 \uc778\uc2dd\ud558\ub294 \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub97c \uc751\uc6a9\ud558\uc5ec \ud310\ubcc4\ud558\ub824\uace0 \ud588\ub294\ub370, 2016\ub144 \uc815\ub3c4\uc5d0 \uac1c\ubc1c\ub41c openface<\/a>\ub97c \ucc3e\uc558\uace0 \uc774\ub97c \uc0ac\uc6a9\ud558\uae30\ub85c \ud588\ub2e4. \uc778\ud130\ub137\uc758 \ub204\uad70\uac00 \uc88b\uc740 \ud29c\ud1a0\ub9ac\uc5bc\uc744<\/a> (\uc601\ubb38<\/a>)\ub9cc\ub4e4\uc5c8\uace0 \uc774\ub97c \ub9ce\uc774 \ucc38\uc870\ud588\ub2e4. \ub610\ud55c openface\uac00 \uc218\uc815\uc5c6\uc774 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud560 \uc815\ub3c4\uc758 \uc644\uc131\ub3c4\ub97c \ubcf4\uc5ec\uc900\ub2e4. docker \uc774\ubbf8\uc9c0\ub85c \uc81c\uacf5\ub418\ub294\ub370 \ubc14\ub85c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n

\ubaa9\ud45c\ud55c 4\uba85\uc758 \uc5bc\uad74\uc744 \ud559\uc2b5\uc2dc\ucf30\uace0, \uc774 \ubaa8\ub378\uc744 \uae30\ubc18\uc73c\ub85c \ubaa8\ub4e0 \ud30c\uc77c\uc744 \ubd84\ub958 \ud588\ub2e4. \ubaa8\ub378\uc744 \ub9cc\ub4e4\uae30\ub294 \uae08\ubc29\uc778\ub370, \uc0ac\uc9c4\uc5d0\uc11c \uc5bc\uad74\ucc3e\uae30, \uadf8 \uc5bc\uad74\uc774 \ub204\uad6c\uc778\uc9c0\ub294 \ud655\uc778\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub9ce\uc740 \uc2dc\uac04(\ub0b4\uac00 \uac00\uc9c4 PC\ub85c 3\uc77c..)\uc744 \uc37c\ub2e4. \uc5bc\uad74 \uc778\uc2dd \ud6c4 \uc774\ub97c \ud30c\uc77c\ub85c \uae30\ub85d\ud558\uc600\uace0 \uc544\ub798\uc640 \uac19\ub2e4.<\/p>\n

=== \/root\/picture\/\uc0ac\uc9c4\/20150211_202325.jpg ===\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/MyPhoto_0149.jpg ===\r\nPredict Daewon @ x=2075 with 0.66 confidence.\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/20140412_162452.jpg ===\r\nList of faces in image from left to right\r\nPredict Minsu @ x=1377 with 0.63 confidence.\r\nPredict Daewon @ x=1549 with 0.86 confidence.\r\nPredict Minsu @ x=1780 with 0.60 confidence.\r\nPredict Daewon @ x=1893 with 1.00 confidence.\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/20130219_152444.jpg ===\r\nPredict Daewon @ x=63 with 0.52 confidence.\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/20121208_110821.jpg ===\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/\uc0ac\uc9c4110702_003.jpg ===\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/\uc0ac\uc9c4120207_010.jpg ===\r\nPredict Minsu @ x=732 with 0.59 confidence.\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/20140405_160811.jpg ===\r\nPredict Miae @ x=1288 with 0.99 confidence.\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/20140406_085437_ShearesAve.jpg ===\r\nPredict Daewon @ x=775 with 0.98 confidence.\r\n\r\n=== \/root\/picture\/\uc0ac\uc9c4\/20131013_134752_\uacfc\ucc9c\ub3d9.jpg ===\r\n\r\n<\/pre>\n
\uac00\ub054 \ud55c \ud30c\uc77c\uc5d0 \uc5ec\ub7ec \uc774\ub984\uc744 \uae30\ub85d\ud558\ub294\ub370, \uc544\ub9c8 \ud559\uc2b5\ud558\uc9c0 \uc54a\uc740 \uc778\ubb3c\uc774 \uc0ac\uc9c4\uc5d0 \uc788\uae30 \ub54c\ubb38\uc774\ub2e4. \uc2e0\ub8b0\ub3c4 0.8 \ubbf8\ub9cc\uc774\uba74 \ubbff\uc744 \uc218 \uc5c6\ub2e4\uace0 \ud310\ub2e8\ud558\uc5ec \uc9c0\uc6e0\ub2e4. \uacf5\ubc31\uc744 \uc9c0\uc6b0\uace0, \uc5ec\ub7ec \ud589\uc744 \ud55c \ud589\uc73c\ub85c \ub9cc\ub4e4\uae30 \uc704\ud574 \ub2e4\uc74c python \uc2a4\ud06c\ub9bd\uc744 \uc0ac\uc6a9 \ud588\ub2e4. sed\ub97c \uc0ac\uc6a9\ud558\ub824 \ud588\uc73c\ub098, python\uc774 \ub0ab\ub2e4.<\/del> docker\ub85c \ub514\ub809\ud1a0\ub9ac\ub97c root \uc544\ub798\uc5d0 \ubc14\ub85c \ub9c8\uc6b4\ud2b8\ud558\uc5ec \uacbd\ub85c\uc5d0 root\uac00 \ud3ec\ud568\ub418\uc5c8\ub2e4. vim\uc73c\ub85c \ud574\ub2f9 \uacbd\ub85c\ub85c \ubaa8\ub450 \ubcc0\uacbd\ud588\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uad73\uc774 \uc2e0\ub8b0\ub3c4\uc640 \uc5bc\uad74 \uc704\uce58\ub97c \ub123\uc9c0 \uc54a\uc544\ub3c4 \ub418\uc5b4 \ubaa8\ub450 \uc9c0\uc6e0\ub2e4.<\/p>\n
#_*_ coding: utf-8 _*_\r\nimport re\r\nimport sys \r\nfrom signal import signal, SIGPIPE, SIG_DFL\r\n\r\nsignal(SIGPIPE,SIG_DFL)\r\nresult_file = open('.\/resultv3.txt','r')\r\nflag_found_path=False;\r\nflag_found_prediction=False;\r\n\r\nnum_lines = sum(1 for line in open('.\/resultv3.txt'))\r\n\r\nfor x in range(num_lines):\r\n    context=result_file.readline()\r\n    #path\ub97c \ucc3e\ub294\ubd80\ubd84.\r\n    path = re.compile(\"=== .* ===\")\r\n    searched_path = path.search(context)\r\n\r\n    #predict\ub97c \ucc3e\ub294 \ubd80\ubd84\r\n    prediction = re.compile(\"Predict.*\")\r\n    searched_prediction = prediction.search(context)\r\n\r\n    #===\ub85c \uc2dc\uc791\ud558\ub294 \ubd80\ubd84. \r\n    if searched_path != None:\r\n        flag_found_path=True\r\n\r\n        #\uac04\ub2e8\ud55c \ubc84\uc804.\r\n        path_str = searched_path.group()\r\n        print('\\n'+path_str,end=',')\r\n\r\n    if searched_prediction != None:\r\n\r\n        predict_str = searched_prediction.group()\r\n        print(predict_str,end=',')\r\n<\/pre>\n
\ub300\ubd80\ubd84 \ucf54\ub4dc\ub97c stack overflow\uc5d0\uc11c \ucc3e\uc544 \uc0ac\uc6a9\ud588\ub2e4.<\/p>\n
\uc544\ub798\uc640 \uac19\uc740 “\ud30c\uc77c \uacbd\ub85c” \ub300 “\uc0ac\ub78c \uc774\ub984”\uc744 \ub9cc\ub4e4 \uc218 \uc788\ub2e4.<\/p>\n
\/imageOtherPar\/\uc0ac\uc9c4\/20130225_163915.jpg,\ubbf8\uc560\r\n\/imageOtherPar\/\uc0ac\uc9c4\/20121224_203050.jpg,\ucc44\uc724\r\n\/imageotherpar\/\uc0ac\uc9c4\/20130926_151133_\u4eba\u5927\u4f1a\u5802\u897f\u8def.jpg,\ucc44\uc724\r\n\/imageotherpar\/\uc0ac\uc9c4\/20130926_151133_\u4eba\u5927\u4f1a\u5802\u897f\u8def.jpg,\ub300\uc6d0\r\n\/imageOtherPar\/\uc0ac\uc9c4\/\uc0ac\uc9c4110612_018.jpg,\ubbfc\uc218\r\n\/imageOtherPar\/\uc0ac\uc9c4\/\uc0ac\uc9c4110612_018.jpg,\ub300\uc6d0\r\n\/imageOtherPar\/\uc0ac\uc9c4\/20130128_212312.jpg,\ubbfc\uc218\r\n\/imageOtherPar\/\uc0ac\uc9c4\/\uc0ac\uc9c4110612_004.jpg,\ubbfc\uc218\r\n\/imageOtherPar\/\uc0ac\uc9c4\/20150331_131747.jpg,\ubbf8\uc560\r\n\/imageOtherPar\/\uc0ac\uc9c4\/20150505_142947.jpg,\ubbfc\uc218\r\n\/imageOtherPar\/\uc0ac\uc9c4\/20150505_141543.jpg,\ub300\uc6d0\r\n\/imageOtherPar\/\uc0ac\uc9c4\/20140405_160859.jpg,\ubbf8\uc560\r\n\/imageOtherPar\/\uc0ac\uc9c4\/\uc0ac\uc9c4111016_021.jpg,\ubbf8\uc560\r\n<\/pre>\n
\uc774 \ud30c\uc77c\uc744 \ubcc4\ub3c4 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4 \uad73\uc774 python\uc73c\ub85c mysql\uc5d0 \uc785\ub825\ud588\ub2e4.<\/p>\n
#_*_ coding: utf-8 _*_\r\nimport pymysql\r\nimport re\r\nimport sys \r\nimport datetime\r\nfrom signal import signal, SIGPIPE, SIG_DFL\r\n\r\n#pipe\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574.\r\nsignal(SIGPIPE,SIG_DFL)\r\n\r\n\r\n\r\npresent = datetime.datetime.now()\r\n\r\nprint(present.date())\r\n\r\nconn = pymysql.connect(host='localhost', user='*****', password='*****',\r\n        db='*****', charset='utf8')\r\n\r\n#column\uc744 \uc811\uadfc\ud558\uae30 \uc704\ud574 Dictionary cursor \uc0ac\uc6a9\r\n#curs = conn.cursor(pymysql.cursors.DictCursor)\r\ncurs = conn.cursor()\r\n\r\n\r\n#read path from file\r\n\r\nresult_file = open('.\/\ucc3e\uc744\uc218\uc788\ub294\uc5bc\uad74v3.txt','r')\r\n\r\nnum_lines = sum(1 for line in open('.\/\ucc3e\uc744\uc218\uc788\ub294\uc5bc\uad74v3.txt'))\r\n\r\n\r\n#\uc774\ub984\uc744 ID\ub85c \ubcc0\uacbd.\r\n#\ubbfc\uc218-2, \ubbf8\uc560-9, \ub300\uc6d0-10, \ucc44\uc724-6\r\n\r\n\r\nfor x in range(num_lines):\r\n    #\ud55c \uc904\uc744 \uc77d\uc74c.\r\n    context=result_file.readline()\r\n\r\n    #\uacbd\ub85c \ucc3e\uc74c.\r\n    path = re.compile(\"\\\/.*jpg\")\r\n    searched_path = path.search(context)\r\n\r\n\r\n    #tag \ud655\uc778.\r\n    #tag_from_file = re.compile(\"\ubbfc\uc218|\ub300\uc6d0|\ubbf8\uc560|\ucc44\uc724\")\r\n    tag_from_file = re.compile(\"jpg,.*$\")\r\n    tag_searched_from_file_tmp = tag_from_file.search(context)\r\n\r\n    if tag_searched_from_file_tmp != None:\r\n        #print(tag_searched_from_file_tmp.group())\r\n        tmp_start = tag_searched_from_file_tmp.start()\r\n        tmp_end = tag_searched_from_file_tmp.end()\r\n\r\n        #file\uc5d0\uc11c \ucc3e\uc740 \ud0dc\uadf8.\r\n        tag_searched_from_file = context[tmp_start+4:tmp_end]\r\n        print(tag_searched_from_file)\r\n        #print(type(tag_searched_from_file))\r\n\r\n\r\n    if searched_path != None:\r\n        found_path = searched_path.group()\r\n        print(found_path)\r\n\r\n    #sql = \"select '\" + found_path + \"' from picture\"\r\n    sql = \"select * from `picture` where `\uacbd\ub85c`='\"+found_path+\"' order by id desc\"\r\n    #sql = \"insert into `id_with_photo_path`(`id`,`\uacbd\ub85c`) values (22,'test2\/');\"\r\n\r\n    no_tag = 0\r\n    if tag_searched_from_file == \"\ubbfc\uc218\" :\r\n        no_tag = 2\r\n    if tag_searched_from_file == \"\ucc44\uc724\" :\r\n        no_tag = 6\r\n    if tag_searched_from_file == \"\ubbf8\uc560\" :\r\n        no_tag = 9\r\n    if tag_searched_from_file == \"\ub300\uc6d0\" :\r\n        no_tag = 10\r\n\r\n    print(type(no_tag))\r\n    print(found_path)\r\n\r\n    sql = \"insert into `id_with_photo_path`(`id`,`\uacbd\ub85c`,`updated`) values ('\"+str(no_tag)+\"','\"+found_path+\"','\"+str(present.year)+\"-\"+str(present.month)+\"-\"+str(present.day)+\"');\"\r\n    #sql = \"\"\" insert into `id_with_photo_path`(`id`,`\uacbd\ub85c`) values (%s, %s)\"\"\"\r\n\r\n\r\n    print(sql)\r\n\r\n\r\n    #print(\"sql is\", sql)\r\n    curs.execute(sql)\r\n\r\n    #rows = curs.fetchall()\r\n\r\n    #rows\ub294 \uc804\uccb4 \ud589\uc744 \ud45c\uc2dc.\r\n    #column\uc744 \ubf51\uae30 \uc704\ud574 \ub8e8\ud504\ub85c \ub3cc\ub9bc.\r\n\r\n    #for row in rows:\r\n\r\n        #print(type(rows))\r\n        #print(len(rows))\r\n    #    tag=row[\"\ud0dc\uadf8\"]\r\n\r\n\r\n        #\ud0dc\uadf8 \ud655\uc778\ubd80\ubd84.\r\n        #print(tag)\r\n        #rows.strip(\",\").split(\",\")\r\n\r\n\r\n#conn.commit()\r\n\r\n\r\nconn.close()\r\n<\/pre>\n
\ub9c8\uc9c0\ub9c9\uc5d0 conn.commit()\uc744 \ud558\uc9c0 \uc54a\uc73c\uba74 sql\ub85c insert\ub97c \ud560 \uc218 \uc5c6\ub2e4. \ub450\ubc88 \uc2e4\ud589\uc744 \ubc29\uc9c0\ud558\uae30 \uc704\ud574 #conn.commit()\ub85c \uc8fc\uc11d\ucc98\ub9ac \ud588\ub2e4.<\/p>\n
\ub2e4\uc74c\uc73c\ub85c \ud648\ud398\uc774\uc9c0\uc5d0\uc11c \ud30c\uc77c\uc744 \uad00\ub9ac\ud558\uae30 \uc704\ud574, \uae30\uc874\uc5d0 \uc791\uc131\ud55c \uc0ac\uc9c4 \uc870\ud68c \ud398\uc774\uc9c0\ub97c \uc218\uc815\ud588\ub2e4. php\ub97c \uc798 \uc54c\uba74 \ub354 \uace0\uae09\uc9c0\uac8c \ud560 \uc218 \uc788\uaca0\uc73c\ub098, \ub531 \uc774\uc815\ub3c4 \uc218\uc900\uc774\uba74 \ucda9\ubd84\ud558\ub2e4.<\/p>\n
<?php \/* Template Name: myPhotoQuery*\/ ?>\r\n<?php\r\nget_header(); ?>\r\n\r\n<div id=\"main-content\" class=\"main-content\">\r\n\r\n<?php\r\n\tif ( is_front_page() && twentyfourteen_has_featured_posts() ) {\r\n\t\t\/\/ Include the featured content template.\r\n\t\tget_template_part( 'featured-content' );\r\n\r\n\t}\r\n?>\r\n\t<div id=\"primary\" class=\"content-area\">\r\n\t\t<div id=\"content\" class=\"site-content\" role=\"main\">\r\n\t\t\t<?php\r\n\t\t\t\t\/\/ Start the Loop.\r\n\t\t\t\twhile ( have_posts() ) : the_post();\r\n\r\n\t\t\t\t\t\/\/ Include the page content template.\r\n\t\t\t\t\tget_template_part( 'content', 'page' );\r\n\r\n\r\n\t\t\t\t\t\/\/ If comments are open or we have at least one comment, load up the comment template.\r\n\t\t\t\t\tif ( comments_open() || get_comments_number() ) {\r\n\t\t\t\t\t\tcomments_template();\r\n\t\t\t\t\t}\r\n\t\t\t\tendwhile;\r\n\t\t\t?>\r\n\r\n<?php\r\n\/\/\ub85c\uadf8\uc778 \ub418\uc5c8\ub294\uc9c0  \ud655\uc778\ud558\ub294 \ubd80\ubd84..\r\nif( is_user_logged_in())\r\n{\r\n\techo '\ud658\uc601\ud569\ub2c8\ub2e4.';\r\n\t?>\r\n<html>\r\n<body>\r\n<?php\r\n\t$config = parse_ini_file(\"****\"); \r\n\r\n\t$link = mysqli_connect('localhost',$config['user'],$config['passwd']);\r\n\r\n\t\r\n\tif(!$link)\r\n\t{\r\n\t\techo 'Could not connect';\r\n\t\techo '<br \/>';\r\n\t\texit;\r\n\t}\r\n\telse\r\n\t{\r\n\t\techo '<br \/>';\r\n\t\techo 'Connected<br \/>';\r\n\t\techo '<br \/>';\r\n\t}\r\n\r\n\tmysqli_set_charset($link,\"utf8\");\r\n\tif(!mysqli_select_db($link,'myHome')){\r\n\t\techo \"could not select DB<br \/>\";}\r\n\telse{\r\n\t\techo \"data base selected<br \/>\";}\r\n\t\r\n\r\n\t\/\/\ud55c\uad6d \uc2dc\uac01 \uae30\uc900\uc73c\ub85c \uc124\uc815..\r\n\tdate_default_timezone_set(\"Asia\/Seoul\");\r\n\t$today = date(\"Y-m-d\");\r\n\t$time = time();\r\n\t#echo $time;\r\n\t$minus30Day = date(\"Y-m-d\", strtotime(\"-30 day\", $time));\r\n\t#echo $today;\r\n\t#echo $targetDay;\r\n\r\n\r\n\t\/\/\ucc98\uc74c \uc811\uc18d\uc2dc \uc0ac\uc6a9\uc790\uac00 \uc785\ub825\ud558\ub294 \ubd80\ubd84..\r\n?>\r\n\t<form method=\"POST\" action=\"\" name=\"\ub0a0\uc790 \uc785\ub825\">\r\n\t<br><hr>\r\n\t\uc2dc\uc791 \ub0a0\uc790\r\n\t<input value=\" <?php echo $minus30Day ?>\" name=\"InputStartDay\" type=\"datetime-local\" >\r\n\t\ub05d \ub0a0\uc790\r\n\t<input value=\" <?php echo $today?>\" name=\"InputEndDay\" type=\"datetime-local\">\r\n\t<br><br>\r\n\t\uc0ac\ub78c \uc774\ub984<br>\r\n\t<input value=\"\" name=\"InputTag\"><br>\r\n\t<br><br>\r\n\t\ud45c\uc2dd \uac1c\uc218<br>\r\n\t<input value=\"10\" name=\"InputLimit\" type=\"number\" min=\"1\" max=\"200\">\r\n\t<br><br>\r\n\t\r\n\t\uc120\ud0dd \uc644\ub8cc\r\n\t<input name=\"submitSelect\" type=\"submit\">\r\n\r\n\t<\/form>\r\n\r\n<?php\r\n\t\/\/\uc120\ud0dd\ud6c4 \ucffc\ub9ac\ub85c \uc804\uc1a1..\r\n\tif(isset($_POST[\"submitSelect\"])){\r\n\r\n\t\t#InputTag\uac00 \ub204\uad6c\ub97c \uac00\ub9ac\ud0a4\ub294\uc9c0 \ud655\uc778.\r\n\t\t$numbered_person = 0;\r\n\t\tif ($_POST[InputTag] == '\ub300\uc6d0') $numbered_person = 10;\r\n\t\tif ($_POST[InputTag] == '\ubbf8\uc560') $numbered_person = 9;\r\n\t\tif ($_POST[InputTag] == '\ubbfc\uc218') $numbered_person = 2;\r\n\t\tif ($_POST[InputTag] == '\ucc44\uc724') $numbered_person = 6;\r\n\r\n\r\n\t\t$file_limiter = 50;\r\n\t\tif( $_POST[InputLimit] > 0 and $_POST[InputLimit] < 1000)\r\n\t\t\t$file_limiter = $_POST[InputLimit];\r\n\r\n\r\n\r\n\t\t#$query=\"select * from picture where (`\uc885\ub958`='\uc774\ubbf8\uc9c0' and (`\ub0a0\uc790` >= '$_POST[InputStartDay]' and `\ub0a0\uc790` <='$_POST[InputEndDay]')) limit $_POST[InputLimit]\";\r\n\t\t#\r\n\t\t#\r\n\t\t#InputTag\uac00 \uc788\uc744 \uacbd\uc6b0 query.\r\n\t\tif($numbered_person != 0){\r\n\t\t\t$queryCount= \"select count(*) from `picture` inner join `id_with_photo_path` on `id_with_photo_path`.`\uacbd\ub85c`= `picture`.`\uacbd\ub85c` where (`\uc885\ub958`='\uc774\ubbf8\uc9c0' and `picture`.`\ub0a0\uc790` >= '$_POST[InputStartDay]' and `\ub0a0\uc790` <='$_POST[InputEndDay]' and `id_with_photo_path`.`ID` = $numbered_person) limit $file_limiter\";\r\n\r\n\t\t\t$query =\"select * from `picture` inner join `id_with_photo_path` on `id_with_photo_path`.`\uacbd\ub85c`= `picture`.`\uacbd\ub85c` where (`\uc885\ub958`='\uc774\ubbf8\uc9c0' and `picture`.`\ub0a0\uc790` >= '$_POST[InputStartDay]' and `\ub0a0\uc790` <='$_POST[InputEndDay]' and `id_with_photo_path`.`ID` = $numbered_person) limit $file_limiter\";\r\n\r\n\t\t}\r\n\t\t\r\n\r\n\t\telse {\r\n\t\t\t$queryCount=\"select count(*) from picture where (`\uc885\ub958`='\uc774\ubbf8\uc9c0' and (`\ub0a0\uc790` >= '$_POST[InputStartDay]' and `\ub0a0\uc790` <='$_POST[InputEndDay]'))\";\r\n\r\n\t\t\t$query = \"select * from picture where (`\uc885\ub958`='\uc774\ubbf8\uc9c0' and (`\ub0a0\uc790` >= '$_POST[InputStartDay]' and `\ub0a0\uc790` <='$_POST[InputEndDay]')) limit $file_limiter\";\r\n\r\n\t\t}\r\n\r\n\t\t$resultCount=mysqli_query($link,$queryCount) or die(\"error\");\r\n\r\n\t\twhile($rowCount=mysqli_fetch_array($resultCount)){\r\n\r\n\t\t\techo \"\ucd1d \uac2f\uc218\ub294 \".$rowCount[0];\r\n\t\t}\r\n\r\n\r\n\t\techo $query;\r\n\t\t$result=mysqli_query($link,$query) or die(\"error\");\r\n\t\t$index=0;\r\n\t\twhile($row=mysqli_fetch_array($result)){\r\n\t\t\t$index=$index+1;\r\n\r\n\r\n\t\t\t?>\r\n\t\t\t<div class=\"layout\">\r\n\t\t\t\t<div class=\"text\" align=\"middle\">\r\n\t\t\t\t<br>\r\n\t\t\t\t\t\t<?php\r\n\t\t\t\t\t\t\techo $row['\uc124\uba85'].\"<br>\";\r\n\t\t\t\t\t\t\techo $row['\ub0a0\uc790'].\"<br>\";\r\n\t\t\t\t\t\t\techo $row['\ud0dc\uadf8'].\"<br>\";\r\n\t\t\t\t\t\t\techo $row['\uacbd\ub85c'].\"<br>\";\r\n\t\t\t\t\t\t?>\r\n\t\t\t\t<\/div>\r\n\t\t\t\t<div class=\"polaroid\" align=\"right\">\r\n\t\t\t\t<img width=\"100%\" alt=\"\" src=<?=$row['\uacbd\ub85c']?> >\r\n\t\t\t\t<\/div>\r\n\t\t\t<\/div>\r\n\t<?php\r\n\t\t\t}\r\n\t}\r\n?>\r\n\r\n<\/body>\r\n\r\n<\/html>\r\n\t<?php\r\n}\r\nelse\r\n{\r\n\techo '\ub85c\uadf8\uc778\ud558\uc9c0 \uc54a\uace0\ub294 \ubcfc\uc218 \uc5c6\uc2b5\ub2c8\ub2e4.';\r\n}\r\n?>\r\n\r\n\r\n\r\n\t\t<\/div><!-- #content -->\r\n\r\n\t<\/div><!-- #primary -->\r\n\r\n\t<?php get_sidebar( 'content' ); ?>\r\n\r\n\r\n<\/div><!-- #main-content -->\r\n\r\n<?php\r\nget_sidebar();\r\nget_footer();\r\n<\/pre>\n
\uc544\ub798 \ub3d9\uc601\uc0c1\uc5d0 \ub098\uc624\ub4ef\uc774 \uc870\ud68c\ud558\ub294\ub370, \uacf5\uac1c \ud504\ub85c\uadf8\ub7a8\uc778\uc9c0 \uc815\ud655\ub3c4\uac00 \uc880 \ub5a8\uc5b4\uc9c4\ub2e4. \ub610\ud55c\u00a0 2018\ub144 \uc774\ud6c4 \ucc0d\uc740 \uc0ac\uc9c4\uc744 \uc778\uc2dd\ud560 \uc218 \uc5c6\ub2e4. \ud574\uc0c1\ub3c4\ub97c \ub192\uc5ec \ub2e4\uc2dc \ud559\uc2b5\uc2dc\ucf1c\uc57c \ud560 \ub4ef \ud558\ub2e4. \uc774 \uc9d3\uc744 \uc644\ub8cc\ud558\uae30\uae4c\uc9c0 \uc57d \uc77c\uc8fc\uc77c\uc815\ub3c4 \uac78\ub838\ub2e4.
\n