{"id":1379,"date":"2017-03-25T23:10:30","date_gmt":"2017-03-25T14:10:30","guid":{"rendered":"http:\/\/now0930.tk\/wordpress\/?p=1379"},"modified":"2017-03-25T23:10:30","modified_gmt":"2017-03-25T14:10:30","slug":"wordpress%eb%a1%9c-%ec%97%90%eb%b2%84%eb%85%b8%ed%8a%b8-%eb%8c%80%ec%8b%a0%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/now0930.pe.kr\/wordpress\/wordpress%eb%a1%9c-%ec%97%90%eb%b2%84%eb%85%b8%ed%8a%b8-%eb%8c%80%ec%8b%a0%ed%95%98%ea%b8%b0\/","title":{"rendered":"WordPress\ub85c \uc5d0\ubc84\ub178\ud2b8 \ub300\uc2e0\ud558\uae30"},"content":{"rendered":"<h1>\uc6cc\ub4dc \ud504\ub808\uc2a4 \ud15c\ud50c\ub9bf\uc73c\ub85c \uc5d0\ubc84\ub178\ud2b8 \ub300\uc2e0\ud558\uae30<\/h1>\n<p>\uc5d0\ubc84\ub178\ud2b8\ub97c \ud55c 5\ub144\uc815\ub3c4 \uc798 \uc0ac\uc6a9\ud588\uc5c8\ub2e4. \uc791\ub144\uc5d0 \uc5d0\ubc84\ub178\ud2b8\uc758 \ub0b4\uc6a9\uc744 \ubc31\uc5c5\ud558\uae30 \uc704\ud574 database\uc5d0 \uc811\uadfc\ud588\uc73c\ub098, \uc5d0\ubc84\ub178\ud2b8 \uc81c\uc791\uc0ac\uc5d0\uc11c \uc811\uadfc\uc744 \ud5c8\uc6a9\ud558\uc9c0 \uc54a\uc558\ub2e4. \uad00\ub828 \ud504\ub85c\uadf8\ub7a8\ub4e4\uc774 \uc788\uc5c8\uc73c\ub098, \uc798 \ub418\uc9c0 \uc54a\uc558\uace0, \ub370\uc774\ud130\uac00 \ub108\ubb34 \ub9ce\uc740\uc9c0 \ud30c\uc77c\uc744 \ubc1b\ub294\ub370 \ud55c\uacc4\uac00 \uc788\uc5c8\ub2e4. \ub0b4\uac00 \ub9cc\ub4e0 \ub370\uc774\ud130\uc778\ub370 \ub0b4\uac00 \uc81c\ub300\ub85c \uc18c\uc720\ub97c \ubabb\ud558\uace0 \uc788\ub2e4\uace0 \uc0dd\uac01\ud558\ub2c8 \uc501\uc501\ud588\ub2e4. \uc774\ubc88 \uae30\ud68c\uc5d0 \uc5d0\ubc84\ub178\ud2b8\ub97c \ub5a0\ub098\uae30\ub85c \ud558\uace0, WordPress\ub85c \ub9cc\ub4e0 \ube14\ub85c\uadf8\uc5d0 \uc5d0\ubc84\ub178\ud2b8\ub97c \ub300\uc2e0\ud560 \uae30\ub2a5\uc744 \ucd94\uac00\ud588\ub2e4. \uae30\ub2a5\uc740 \ubd80\uc871\ud558\uc9c0\ub9cc, \ub098\ub984 \uc368\ubcf4\ub2c8 \uad1c\ucc2e\uc740 \ub4ef \ud558\ub2e4. \ud14d\uc2a4\ud2b8\ub294 \uc5b4\ub290 \uc815\ub3c4 \uc785\ub825, \uc870\ud68c, \uc218\uc815\uc774 \uac00\ub2a5\ud588\uc5c8\uace0, \uc624\ub298 \uba87\ubc88\uc758 \uc2dc\ud589\ucc29\uc624 \ub05d\uc5d0 \ud55c\uac1c\uc758 \uc0ac\uc9c4\uc744 \ucd94\uac00 \uac00\ub2a5\ud558\ub3c4\ub85d \ud588\ub2e4.<\/p>\n<h2>\ud398\uc774\uc9c0\ub85c php\ub97c \uc81c\uacf5\ud558\ub294 \ud15c\ud50c\ub9bf \ub9cc\ub4e4\uae30<\/h2>\n<p>\uc6cc\ub4dc\ud504\ub808\uc2a4\ub294 \uae30\ubcf8\uc73c\ub85c php\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub2e4. \ub2e4\ud589\ud788? \uc0ac\uc6a9\uc790\uac00 page\uc5d0\uc11c \ud15c\ud50c\ub9bf\uc744 \ub9cc\ub4e0\ub2e4\uba74 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc791\uc5c5\uc744 \uc870\ud68c\/\uc218\uc815\/\uc785\ub825\ud558\ub294 \ud15c\ud50c\ub9bf\uc744 3\uac1c\ub97c \ub9cc\ub4e4\uc5c8\ub2e4.<\/p>\n<h3>\uc791\uc5c5 \uc870\ud68c\ud558\ub294 php<\/h3>\n<p>\uc774 \ud15c\ud50c\ub9bf\uc740 mysql\uc5d0 \uc811\uadfc\ud558\uc5ec \uc644\ub8cc\ub418\uc9c0 \uc54a\uc740 \uc791\uc5c5\uc744 \ud45c\uc2dc\ud55c\ub2e4. \uc0ac\uc6a9\uc790\uac00 \uc791\uc5c5\uc744 \ucd94\uac00\ud560 \uacbd\uc6b0, \uadf8\ub8f9ID\ub97c \ud560\ub2f9\ud558\ub294\ub370, \uc774 \uadf8\ub8f9ID\ub97c \uae30\uc900\uc73c\ub85c \uc791\uc5c5\uc744 \ud45c\uc2dc\ud55c\ub2e4. mysql\uc758 database\ub294 \ub450 \uac1c\ub97c \ub9cc\ub4e4\uc5c8\ub294\ub370 \ud558\ub098\ub294 \uc791\uc5c5 \ub0b4\uc6a9\uc774\uace0, \ud558\ub098\ub294 \uc774\ubbf8\uc9c0 \ud30c\uc77c\uc758 \uacbd\ub85c\uc774\ub2e4. \uc870\ud68c\ub97c \ub20c\ub800\uc744 \ub54c, grpId\ub85c \uadf8\ub9bc\uc758 \uacbd\ub85c\uac00 \uc788\uc73c\uba74 \uc774\ub97c \ud654\uba74\uc5d0 \ud45c\uc2dc\ud55c\ub2e4.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-full wp-image-1382\" src=\"http:\/\/now0930.tk\/wordpress\/wp-content\/uploads\/2017\/03\/\uacbd\ub85c.png\" alt=\"\" width=\"949\" height=\"222\" srcset=\"https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2017\/03\/\uacbd\ub85c.png 949w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2017\/03\/\uacbd\ub85c-300x70.png 300w, https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2017\/03\/\uacbd\ub85c-768x180.png 768w\" sizes=\"auto, (max-width: 949px) 100vw, 949px\" \/><br \/>\nwordpress \uc124\uce58 \ub514\ub809\ud1a0\ub9ac \uc911 wp-content\uac00 \ub0b4\uc6a9\uc744 \ub2f4\ub2f9\ud558\uace0 \uc788\ub2e4. \uc0ac\uc6a9\ud558\ub294 theme\uc758 \uacbd\ub85c\ub85c \uc774\ub3d9\ud55c \ub2e4\uc74c \ub2e4\uc74c 3\uac1c\uc758 \ud30c\uc77c\uc744 \ub9cc\ub4e4\uc5c8\ub2e4.<br \/>\nmyJob.php, myJobInsert.php, myJobModify.php<br \/>\n\uc544\ub798 Template Name\uc744 \uc6d0\ud558\ub294 \ub0b4\uc6a9\uc73c\ub85c \ubcc0\uacbd\ud558\uace0 page\ub97c \ub9cc\ub4e4 \ub54c \uc774\ub97c \uc120\ud0dd\ud558\uba74 \ud574\ub2f9 \ud30c\uc77c\uc758 php \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n<pre class=\"lang:pgsql decode:true \">&lt;?php \/* Template Name: myJob*\/ ?&gt;\r\n&lt;?php\r\nget_header(); ?&gt;\r\n\r\n&lt;div id=\"main-content\" class=\"main-content\"&gt;\r\n\r\n&lt;?php\r\n    if ( is_front_page() &amp;&amp; twentyfourteen_has_featured_posts() ) { \r\n        \/\/ Include the featured content template.\r\n        get_template_part( 'featured-content' );\r\n\r\n    }   \r\n?&gt;\r\n<\/pre>\n<p>\ub300\ub7b5 \uc544\ub798\uc640 \uac19\uc774 \uc791\uc5c5\uc744 \ud55c\ub2e4.<br \/>\n1. \ub85c\uadf8\uc778\uc774 \ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778<br \/>\n2. mysql user\uc640 password\ub97c \uc2dc\uc2a4\ud15c\uc5d0\uc11c \uc77d\uc5b4\uc62e<br \/>\n3. \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0<br \/>\n4. query\ub97c \ub0a0\ub9bc..\ucffc\ub9ac\ub294 \ub300\ub7b5 \ub2e4\uc74c\uacfc \uac19\uc774 \ud588\ub2e4.<\/p>\n<pre class=\"lang:default decode:true \">$query=\"select * from\r\n        (select * from  \r\n        (select* from `workList` order by `id` desc, `\uc5c5\ub370\uc774\ud2b8\uc77c` desc) as target \r\ngroup by `grpId`)\r\nas target2 where year(`\uc644\ub8cc\uc77c`) = '0000' order by `\ub9c8\uac10\uc77c` asc\";\r\n<\/pre>\n<p>php\uc5d0\uc11c template table\uc744 \ub9cc\ub4e4 \uc218 \uc788\uc73c\ub098, \uc170\uc158\uc774 \ub04a\uae30\uba74 \uc784\uc2dc \ud14c\uc774\ube14\ub3c4 \uc5c6\uc5b4\uc9c4\ub2e4. \uadc0\ucc2c\uace0 \ub370\uc774\ud130\ub3c4 \uc5bc\ub9c8 \ub418\uc9c0 \uc54a\uc544 select\ub97c \uc911\ucca9\ud588\ub2e4.<br \/>\n5. query\uc758 \uacb0\uacfc\ub97c html\ub85c \ud45c\uc2dc\ud574 \uc8fc\ub294 \ubd80\ubd84<br \/>\n6. \uc774\ubbf8\uc9c0\uac00 \uc788\uc73c\uba74 \uc774\ubbf8\uc9c0\ub3c4 \uac19\uc774 \ud45c\uc2dc<\/p>\n<h3>\uc791\uc5c5\uc744 \uc785\ub825\ud558\ub294 php<\/h3>\n<p>\uc774 \ud15c\ud50c\ub9bf\uc740 \uadf8\ub8f9ID\ub97c \ud560\ub2f9\ud558\uc5ec \uc791\uc5c5\uc744 \uc785\ub825\ud55c\ub2e4. \uc624\ub298 \uc0ac\uc9c4\ub3c4 \ud55c\uc7a5 \uc785\ub825\uc744 \ud560 \uc218 \uc788\ub3c4\ub85d \uc218\uc815\ud588\ub2e4. submit \ubc84\ud2bc\uc744 \ub204\ub974\uba74 \uac00\uc7a5 \ub9c8\uc9c0\ub9c9\uc758 GrpId\ub85c \uc624\ub298 \ub0a0\uc790\ub97c \uc5c5\ub370\uc774\ud2b8 \ub0a0\uc790\ub85c \ud558\uc5ec \uc0c8\ub85c \ud56d\ubaa9\uc744 \ub9cc\ub4e0\ub2e4. \ud30c\uc77c\uc744 \uc5c5\ub85c\ub4dc \ud588\ub2e4\uba74, \ud30c\uc77c \uacbd\ub85c\ub97c \ub0b4\uc6a9\uc5d0 \ub300\ud55c \ub370\uc774\ud130\uc640 \uc5f0\uacb0\ud55c\ub2e4.<\/p>\n<p>\ud15c\ud50c\ub9bf\uc740 \uc704\uc640 \uac19\uc740 \ubc29\ubc95\uc744 \ub9cc\ub4e4\uc5c8\ub2e4. html\uc5d0\uc11c form\uc744 \uc124\uc815\ud558\uc5ec \ud574\ub2f9 \ub0b4\uc6a9\uc744 $_POST\ub85c \ub370\uc774\ud130 \ubca0\uc774\uc2a4\uc5d0 \ubcc0\uc218\ub85c \ub4e4\uc5b4\uac00\ub3c4\ub85d \ud588\ub2e4.<br \/>\n1. \ub85c\uadf8\uc778 \ud655\uc778 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0<br \/>\n2. \uac00\uc7a5 \ub9c8\uc9c0\ub9c9\uc758 grpId\ub97c \ud655\uc778<br \/>\n3. +1\uc744 \ud558\uc5ec \uc0ac\uc6a9\ud560 grpId\ub85c \uc124\uc815<br \/>\n4. \uc624\ub298 \ub0a0\uc790, \uc624\ub298 \ub0a0\uc790+14\uc77c\uc744 \ud655\uc778\ud558\uc5ec \uc5c5\ub370\uc774\ud2b8\uc77c, \ubaa9\ud45c\uc77c\ub85c \uc790\ub3d9 \uc124\uc815<br \/>\n5. form\uc73c\ub85c \ud574\ub2f9\ud558\ub294 \ub0b4\uc6a9\uc744 \ud45c\uc2dc<br \/>\n6. \uc774\ubbf8\uc9c0\ub97c \uc785\ub825\ud560 \uacbd\uc6b0, \ud30c\uc77c \uc774\ub984\uacfc \uacbd\ub85c\ub97c \uc124\uc815<br \/>\n7. \uc0ac\uc6a9\uc790\uac00 submit \ubc84\ud2bc\uc744 \ub204\ub974\uba74 \ub0b4\uc6a9\uacfc \uc774\ubbf8\uc9c0\uc758 \uacbd\ub85c\ub97c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc785\ub825\ud558\uace0, \uc774\ubbf8\uc9c0\ub97c \uc124\uc815\ud55c \uacbd\ub85c\uc5d0 \uc5c5\ub85c\ub4dc<\/p>\n<h3>\uc791\uc5c5\uc744 \uc218\uc815\ud558\ub294 php<\/h3>\n<p>\uc870\ud68c\ub41c \uc791\uc5c5 \uc911, \uc218\uc815\uc744 \uc6d0\ud558\ub294 \ubd80\ubd84\uc774 \uc788\uc73c\uba74 grpId\ub97c \ud655\uc778\ud574\uc57c \ud55c\ub2e4. \uc791\uc5c5\uc744 \uc218\uc815\ud55c\ub294 \ud398\uc774\uc9c0\uc5d0\uc11c Id\ub97c \uc785\ub825\ud558\uc5ec \ub0b4\uc6a9\uc744 \ud45c\uc2dc\ud55c \ub2e4\uc74c, \ub0b4\uac00 \uc6d0\ud558\ub294 \ub0b4\uc6a9\uc73c\ub85c \uc5c5\ub370\uc774\ud2b8\ud55c\ub2e4. \uc870\ud68c \ubc84\ud2bc\uc744 \ub20c\ub800\uc744 \uacbd\uc6b0, \uac00\uc7a5 \ub098\uc911\uc5d0 \uc791\uc5c5\ub41c \ub0b4\uc6a9\uc774 \ud45c\uc2dc\ub41c\ub2e4.<\/p>\n<p>https:\/\/youtu.be\/oVLF5c8Hl3s<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uc6cc\ub4dc \ud504\ub808\uc2a4 \ud15c\ud50c\ub9bf\uc73c\ub85c \uc5d0\ubc84\ub178\ud2b8 \ub300\uc2e0\ud558\uae30 \uc5d0\ubc84\ub178\ud2b8\ub97c \ud55c 5\ub144\uc815\ub3c4 \uc798 \uc0ac\uc6a9\ud588\uc5c8\ub2e4. \uc791\ub144\uc5d0 \uc5d0\ubc84\ub178\ud2b8\uc758 \ub0b4\uc6a9\uc744 \ubc31\uc5c5\ud558\uae30 \uc704\ud574 database\uc5d0 \uc811\uadfc\ud588\uc73c\ub098, \uc5d0\ubc84\ub178\ud2b8 \uc81c\uc791\uc0ac\uc5d0\uc11c \uc811\uadfc\uc744 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1383,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"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":""},"categories":[12],"tags":[13,152,151],"class_list":["post-1379","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-12","tag-mysql","tag-php","tag-wordpress"],"jetpack_featured_media_url":"https:\/\/now0930.pe.kr\/wordpress\/wp-content\/uploads\/2017\/03\/\ud2b9\uc131\uc774\ubbf8\uc9c0.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/1379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/comments?post=1379"}],"version-history":[{"count":2,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/1379\/revisions"}],"predecessor-version":[{"id":1384,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/posts\/1379\/revisions\/1384"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/media\/1383"}],"wp:attachment":[{"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/media?parent=1379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/categories?post=1379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/now0930.pe.kr\/wordpress\/wp-json\/wp\/v2\/tags?post=1379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}