\uc6cc\ub4dc\ud504\ub808\uc2a4\ub294 \uac15\ub825\ud55c \ucf58\ud150\uce20 \uad00\ub9ac \uc2dc\uc2a4\ud15c(CMS)\uc73c\ub85c, PHP \ubc0f MySQL\uc744 \uae30\ubc18\uc73c\ub85c \ud569\ub2c8\ub2e4. \uc774 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ub2e4\ub8e8\ub294 \ub2a5\ub825\uc740 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uac1c\ubc1c\uc790\uc5d0\uac8c \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uac15\uc88c\uc5d0\uc11c\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uad6c\uc870\ub97c \uc774\ud574\ud558\uace0, \ucee4\uc2a4\ud140 \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95, \uadf8\ub9ac\uace0 \uc9c1\uc811 SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uc5ec \uc6cc\ub4dc\ud504\ub808\uc2a4\uc640 \ud1b5\ud569\ud558\ub294 \ubc29\ubc95\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \uc5ec\ub7ec \uac1c\uc758 \ud14c\uc774\ube14\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uac00\uc7a5 \uc8fc\uc694\ud55c \ud14c\uc774\ube14\ub85c\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4\uc5d0\uc11c\ub294 \ucee4\uc2a4\ud140 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\ub294 \ubc29\ubc95\uc73c\ub85c \uae30\ubcf8\uc801\uc73c\ub85c \uc6cc\ub4dc\ud504\ub808\uc2a4\uc5d0\uc11c \ucee4\uc2a4\ud140 \ub370\uc774\ud130\ub97c \ucd94\uac00\ud558\uae30 \uc704\ud574\uc11c\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uc81c\uacf5\ud558\ub294 \ud568\uc218\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0c1\ud638\uc791\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\uc9c0\ub9cc, \ub54c\ub85c\ub294 \uc9c1\uc811 SQL \ucffc\ub9ac\ub97c \uc791\uc131\ud574\uc57c \ud560 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ub54c\ub294 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud560 \ub54c\ub294 \ub54c\ub85c\ub294 \ub2e8\uc21c\ud55c \uba54\ud0c0\ub370\uc774\ud130\uac00 \uc544\ub2cc \ubcf5\uc7a1\ud55c \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud574\uc57c \ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ub54c\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\uc5ec \ub370\uc774\ud130\ub97c \uc800\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc6cc\ub4dc\ud504\ub808\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \uc0ac\uc774\ud2b8\uc758 \ud65c\uc131\ud654 \uc2dc \uc0ac\uc6a9\uc790 \uc815\uc758 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \uc644\uc131\ub41c SQL \ucffc\ub9ac\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 \ub2e4\uc591\ud55c \uae30\ub2a5\uacfc \ud1b5\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \uce74\ud14c\uace0\ub9ac\uc758 \uac8c\uc2dc\ubb3c \ub9ac\uc2a4\ud2b8\ub97c \uac00\uc838\uc624\uace0 \uc774\ub97c \uc0ac\uc6a9\uc790 \uc815\uc758 \ud15c\ud50c\ub9bf\uc5d0 \ucd9c\ub825\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n \ucffc\ub9ac\uac00 \ubcf5\uc7a1\ud574\uc9c8 \uc218\ub85d \uc131\ub2a5\uc740 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\uae30 \uc704\ud55c \uba87 \uac00\uc9c0 \uae30\uc220\uc785\ub2c8\ub2e4.<\/p>\n \uc790\uc8fc \uac80\uc0c9\ub418\ub294 \ud544\ub4dc\uc5d0 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\uc5ec \uc870\ud68c \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\uac00 \uc815\uc758\ud55c \ud14c\uc774\ube14 \uc0dd\uc131 \uc2dc \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n \ucffc\ub9ac \uacb0\uacfc\ub97c \uce90\uc2dc\ud558\uc5ec \ubc18\ubcf5\uc801\uc778 \ud638\ucd9c \uc2dc \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubd80\ud558\ub97c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc6cc\ub4dc\ud504\ub808\uc2a4\ub294 \uac1d\uccb4 \uce90\uc2f1\uacfc Transients API\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n \uc774\ubc88 \uac15\uc88c\uc5d0\uc11c\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ucee4\uc2a4\ud140 \ub370\uc774\ud130 \ucc98\ub9ac, \uadf8\ub9ac\uace0 \ucee4\uc2a4\ud140 SQL \ucffc\ub9ac \uc791\uc131 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubcf4\uc558\uc2b5\ub2c8\ub2e4. \uc6cc\ub4dc\ud504\ub808\uc2a4 \uac1c\ubc1c\uc790\ub294 \uc774\ub7ec\ud55c \uae30\ub2a5\uc744 \uc801\uc808\ud788 \ud65c\uc6a9\ud558\uc5ec \uac15\ub825\ud558\uace0 \uc720\uc5f0\ud55c \uc6f9\uc0ac\uc774\ud2b8\ub97c \uad6c\ucd95\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc774\ud574\ud558\uace0 \ud6a8\uacfc\uc801\uc73c\ub85c \uc0ac\uc6a9\ud558\ub294 \uac83\uc740 \ubaa8\ub4e0 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uac1c\ubc1c\uc790\uc5d0\uac8c \ud544\uc218\uc801\uc778 \uae30\uc220\uc785\ub2c8\ub2e4.<\/p>\n <\/body><\/p>\n","protected":false},"excerpt":{"rendered":"wp_posts<\/code>, wp_users<\/code>, wp_comments<\/code> \ub4f1\uc774 \uc788\uc2b5\ub2c8\ub2e4. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uad6c\uc870\ub97c \uc774\ud574\ud558\ub294 \uac83\uc740 \ucee4\uc2a4\ud140 \ub370\uc774\ud130\ub97c \uc131\uacf5\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\uace0 \uad00\ub9ac\ud558\ub294 \uccab\uac78\uc74c\uc785\ub2c8\ub2e4.<\/p>\n1.1 \uc8fc\uc694 \ud14c\uc774\ube14 \uc124\uba85<\/h3>\n
\n
2. \ucee4\uc2a4\ud140 \ub370\uc774\ud130 \ucc98\ub9ac\ud558\uae30<\/h2>\n
postmeta<\/code>, user meta<\/code>, \uadf8\ub9ac\uace0 \uc9c1\uc811 \ud14c\uc774\ube14\uc744 \uc0dd\uc131\ud558\ub294 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uc911 postmeta<\/code>\ub97c \ud65c\uc6a9\ud558\ub294 \uac83\uc774 \uc77c\ubc18\uc801\uc785\ub2c8\ub2e4.<\/p>\n2.1 \ucee4\uc2a4\ud140 \ub370\uc774\ud130 \ucd94\uac00\ud558\uae30<\/h3>\n
add_post_meta()<\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\nadd_post_meta($post_id, $meta_key, $meta_value, $unique);<\/code><\/pre>\n\n$post_id = 1; \/\/ \uac8c\uc2dc\ubb3c ID\n$meta_key = 'custom_field';\n$meta_value = 'This is a custom value';\n\n\/\/ \ucee4\uc2a4\ud140 \ub370\uc774\ud130 \ucd94\uac00\nadd_post_meta($post_id, $meta_key, $meta_value);\n <\/code><\/pre>\n<\/div>\n3. \ucee4\uc2a4\ud140 SQL \ucffc\ub9ac \uc791\uc131\ud558\uae30<\/h2>\n
$wpdb<\/code> \uac1d\uccb4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n3.1 \uae30\ubcf8\uc801\uc778 \ucffc\ub9ac \uc791\uc131<\/h3>\n
$wpdb<\/code> \uac1d\uccb4\ub294 \uc6cc\ub4dc\ud504\ub808\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc27d\uac8c \ub2e4\ub8e8\uae30 \uc704\ud55c \ub2e4\uc591\ud55c \uba54\uc18c\ub4dc\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774 \uac1d\uccb4\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc548\uc804\ud558\uac8c \ucffc\ub9ac\ub97c \uc791\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\nglobal $wpdb;\n$sql = \"SELECT * FROM {$wpdb->posts} WHERE post_status = 'publish'\";\n$results = $wpdb->get_results($sql);\n<\/code><\/pre>\n\nglobal $wpdb;\n\n\/\/ \ubaa8\ub4e0 \uac8c\uc2dc\ubb3c \uac00\uc838\uc624\uae30\n$sql = \"SELECT * FROM {$wpdb->posts} WHERE post_status = 'publish'\";\n$results = $wpdb->get_results($sql);\n\n\/\/ \uacb0\uacfc \ucd9c\ub825\nforeach ($results as $post) {\n echo $post->post_title . '3.2 \ub370\uc774\ud130 \uc0bd\uc785\uacfc \uc5c5\ub370\uc774\ud2b8<\/h3>\n
insert()<\/code> \uba54\uc18c\ub4dc\ub97c \ud65c\uc6a9\ud558\uba70, \uc5c5\ub370\uc774\ud2b8 \uc2dc\uc5d0\ub294 update()<\/code> \uba54\uc18c\ub4dc\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n$wpdb->insert($table, $data, $format);<\/code><\/pre>\n\n$table = \"{$wpdb->prefix}custom_table\";\n$data = array(\n 'name' => 'Example Name',\n 'value' => 'Example Value'\n);\n\n\/\/ \ub370\uc774\ud130 \uc0bd\uc785\n$wpdb->insert($table, $data);\n <\/code><\/pre>\n<\/div>\n4. \uc0ac\uc6a9\uc790 \uc815\uc758 \ud14c\uc774\ube14 \uc0dd\uc131<\/h2>\n
4.1 \ud14c\uc774\ube14 \uc0dd\uc131 \ud568\uc218 \uc791\uc131<\/h3>\n
function create_custom_table() {\n global $wpdb;\n $table_name = \"{$wpdb->prefix}custom_table\";\n\n $charset_collate = $wpdb->get_charset_collate();\n $sql = \"CREATE TABLE IF NOT EXISTS $table_name (\n id mediumint(9) NOT NULL AUTO_INCREMENT,\n name tinytext NOT NULL,\n value text NOT NULL,\n PRIMARY KEY (id)\n ) $charset_collate;\";\n\n require_once(ABSPATH . 'wp-admin\/includes\/upgrade.php');\n dbDelta($sql);\n}<\/code><\/pre>\n\n\/\/ \ud65c\uc131\ud654 \ud6c4 \uc2e4\ud589\nregister_activation_hook(__FILE__, 'create_custom_table');\n <\/code><\/pre>\n<\/div>\n5. \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud1b5\ud569\ud558\uae30<\/h2>\n
function get_custom_posts($category_id) {\n global $wpdb;\n $sql = $wpdb->prepare(\"SELECT * FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_category = %d\", $category_id);\n return $wpdb->get_results($sql);\n}<\/code><\/pre>\n\n$posts = get_custom_posts(1);\nforeach ($posts as $post) {\n echo '' . $post->post_title . '<\/h2>';\n echo '
6. \uc131\ub2a5 \ucd5c\uc801\ud654<\/h2>\n
6.1 \uc778\ub371\uc2a4 \ucd94\uac00<\/h3>\n
CREATE TABLE IF NOT EXISTS $table_name (\n id mediumint(9) NOT NULL AUTO_INCREMENT,\n name tinytext NOT NULL,\n value text NOT NULL,\n PRIMARY KEY (id),\n KEY name_index (name)\n) $charset_collate;<\/code><\/pre>\n6.2 \uce90\uc2f1 \ud65c\uc6a9<\/h3>\n
$transient_key = 'custom_data_key';\n$data = get_transient($transient_key);\nif ($data === false) {\n \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac \uc2e4\ud589\n $data = get_custom_posts(1);\n set_transient($transient_key, $data, HOUR_IN_SECONDS);\n}\n<\/code><\/pre>\n\uacb0\ub860<\/h2>\n