[1] \ub300\uac1c\uc758 \uacbd\uc6b0, \ud68c\uc6d0 \ub85c\uadf8\uc778\uc5d0 \uc138\uc158\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc989 \ud68c\uc6d0\uc73c\ub85c \ub85c\uadf8\uc778\ud558\uc9c0 \uc54a\uc73c\uba74 \uc138\uc158\uc744 \uc0ac\uc6a9\ud560 \uc77c\uc774 \uc5c6\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc11c\ub294 \ud68c\uc6d0 \uc804\uc6a9 \uc138\uc158\ub9cc \uad00\ub9ac\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
[2] \uc138\uc158 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc11c, \uc5ec\uae30\uc5d0 \ub9e4\ubc88 insert, delete\ub97c \ud558\ub294 \uac83\uc740 \ube44\ub85d \ud14c\uc774\ube14 \ud06c\uae30\uac00 \uc791\ub2e4\uace0 \ud558\ub354\ub77c\ub3c4 \uc81c\ubc95 \ubd80\ud558\ub97c \uc90d\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc11c\ub294 delete\ub97c \uc4f0\uc9c0 \uc54a\uace0 update\ub9cc \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ud68c\uc6d0\uc774 \uba87\ub9cc\uba85\uc774\ub77c\uace0 \ud560\uc9c0\ub77c\ub3c4 \uc774\uac8c \ub354 \ub098\uc740 \uac83 \uac19\ub354\uad70\uc694.<\/p>\n
\uc138\uc158 \ud14c\uc774\ube14\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \ub9cc\ub4ed\ub2c8\ub2e4. \ud68c\uc6d0\ubaa9\ub85d \ud14c\uc774\ube14\uacfc \ub611\uac19\uc740 rows\ub97c \uac16\uac8c \ub418\uaca0\uc8e0.
\nCREATE TABLE `user_sessions` (
\n `uid` int(10) unsigned NOT NULL default ‘0’, \/* \ud68c\uc6d0ID *\/
\n `sess_key` varchar(32) NOT NULL default ”, \/* \uc138\uc158\ud0a4 *\/
\n `last_log` int(11) unsigned NOT NULL default ‘0’, \/* \uc138\uc158\uc744 \uae30\ub85d\ud558\ub294 \uc2dc\uac04 *\/
\n `last_ip` varchar(15) NOT NULL default ”, \/* \uaf2d \ud544\uc694\ud558\uc9c0\ub294 \uc54a\uc9c0\ub9cc, \ucd94\ud6c4 \ud544\uc694\uc131\uc744 \ub290\ub07c\uac8c \ub420 \uac83\uc784 \ud83d\ude09 *\/
\n `sess_value` text NOT NULL, \/* \uc138\uc158\uac12 *\/
\n PRIMARY KEY (`uid`),
\n KEY `sess_key` (`sess_key`)
\n) TYPE=MyISAM;<\/p>\n
\uc138\uc158\uc744 \ucc98\ub9ac\ud558\ub294 \uc2a4\ud06c\ub9bd\ud2b8\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.
\n(\ud3b8\uc758\uc0c1 DB \ud074\ub798\uc2a4\ub97c \uc0ac\uc6a9\ud588\uc2b5\ub2c8\ub2e4\ub9cc, \ubb50\ud558\ub294\uac74\uc9c0\ub294 \ub2e4 \uc544\uc2dc\uaca0\uc8e0? –;;)<\/p>\n
session_set_save_handler(“sess_open”, “sess_close”, “sess_read”, “sess_write”, “sess_destroy”, “sess_gc”);
\nsession_start();<\/p>\n
function sess_open($save_path, $session_name) {
\n return 1;
\n}<\/p>\n
function sess_read($key) {
\n $DB =& DB::getInstance();
\n $DB->query(“SELECT sess_value FROM user_sessions WHERE sess_key = ‘$key’ AND last_log > ‘”.(time()-get_cfg_var(“session.gc_maxlifetime”)).”‘ “);
\n $row=$DB->get();
\n return $row[0];
\n}<\/p>\n
function sess_write($key, $value) {
\n $DB =& DB::getInstance();
\n $DB->query(“UPDATE user_sessions SET last_log='”.time().”‘, last_ip='”.$_SERVER[“REMOTE_ADDR”].”‘, sess_value=’$value’ WHERE sess_key=’$key’ “);
\n return ”;
\n}<\/p>\n
function sess_close() {
\n return 1;
\n}<\/p>\n
function sess_destroy($key) {
\n $DB =& DB::getInstance();
\n $DB->query(“UPDATE user_sessions SET sess_key=”, last_log='”.time().”‘, last_ip='”.$_SERVER[“REMOTE_ADDR”].”‘ WHERE sess_key=’$key’ “);
\n}<\/p>\n
function sess_gc($lifetime) {
\n return 1;
\n}<\/p>\n
[3] \ud68c\uc6d0 \ub85c\uadf8\uc778\ud558\ub294 \ubd80\ubd84\uc5d0\uc11c sess_key \uac12\uc744 \ud560\ub2f9\ud569\ub2c8\ub2e4. \uadf8 \ub2e4\uc74c\ubd80\ud130 \uadf8 \ud68c\uc6d0\uc740 \uc138\uc158 \ud14c\uc774\ube14\uc5d0\uc11c \ub370\uc774\ud0c0\ub97c \uc77d\uace0 \uc4f8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
\n\ube44\ud68c\uc6d0\uc778 \uacbd\uc6b0\ub294 session_start()\ub97c \ud558\ub354\ub77c\ub3c4 \uc138\uc158\ud0a4\uac12\ub9cc \uc8fc\uc5b4\uc9c8 \ubfd0, \uc5ec\ub7ec\uac00\uc9c0 $_SESSION\uac12\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. (\ubb3c\ub860 \ucfe0\ud0a4\uac12\uc744 \uc774\uc6a9\ud574 \ube44\ud68c\uc6d0\uc758 \uacbd\uc6b0\ub294 \uc544\uc608 session_start()\ub97c \uc2e4\ud589\ud558\uc9c0 \uc54a\ub294 \ubc29\ubc95\ub3c4 \uc788\uc8e0. ^^;;) <\/p>\n
[4] \uc774\ub807\uac8c \ud568\uc73c\ub85c\uc368 \uad73\uc774 \uac00\ube44\uc9c0 \ucf5c\ub809\uc158(update \ud639\uc740 delete)\uc744 \ud558\uc9c0 \uc54a\uc544\ub3c4 \ub429\ub2c8\ub2e4. \ub610 \ud68c\uc6d0\uc758 \ub9c8\uc9c0\ub9c9 \uc811\uc18d\uc2dc\uac04\uc774 \ucd5c\uc2e0\uc73c\ub85c \uc720\uc9c0\ub429\ub2c8\ub2e4.<\/p>\n
[5] \ud68c\uc6d0\uc758 \uc911\ubcf5 \ub85c\uadf8\uc778\uc774 \ubc29\uc9c0\ub429\ub2c8\ub2e4. \ub2e4\ub9cc, \uac19\uc740 \uc704\uce58\uc5d0\uc11c \ub2e4\ub978 \uc138\uc158\uc744 \ub2e4\uc2dc \uc2dc\uc791\ud558\ub294 \uacbd\uc6b0\uc778\uc9c0, \uc774\ubbf8 \ub85c\uadf8\uc778\ub41c \uc0c1\ud0dc\uc778\uc9c0 \ub4f1\uc758 \uc608\uc678\uc801 \uc0c1\ud669\uc744 \ucc98\ub9ac\ud558\uae30 \uc704\ud574 \ub85c\uadf8\uc778\uc744 \ucc98\ub9ac\ud558\ub294 \ubd80\ubd84\uc744 \ubcf4\uac15\ud574\uc57c\uaca0\uc8e0. \ud83d\ude09<\/p>\n
——————————
\n\uc790, \uc774\ucbe4\uc5d0\uc11c \ud55c\uac00\uc9c0 \uc695\uc2ec\uc744 \ub0b4\uc5b4\ubcfc\uae4c\uc694? \uc774\ub978\ubc14, \ucabd\uc9c0 \uae30\ub2a5\uc744 \ucd94\uac00\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. (\uc2e4\uc2dc\uac04 \ucabd\uc9c0 \uae30\ub2a5 \uc544\ub2d9\ub2c8\ub2e4. –;;)
\n\uc81c\ub85c\ubcf4\ub4dc\uc778\uac00? \ucabd\uc9c0\ub97c \ubc1b\uc73c\uba74 “\ub529\ub3d9, \uc0c8\ub85c\uc6b4 \uba54\uc2dc\uc9c0\uac00 \ub3c4\ucc29\ud588\uc2b5\ub2c8\ub2e4” \ud558\ub294 \uc18c\ub9ac\uac00 \ub098\uc7ce\uc544\uc694.
\n\ubc1b\uc740 \ucabd\uc9c0 \ud14c\uc774\ube14\uc744 \ub530\ub85c \ub9cc\ub4e4\uba74, \ub9e4\ubc88 \ud574\ub2f9 \ud14c\uc774\ube14\uc744 \uc77d\uc5b4\uc57c \ud558\uc9c0 \uc54a\uc2b5\ub2c8\uae4c. \ubb50 \uad73\uc774 2\ubc88 \uc791\uc5c5\uc744 \ud558\ub0d0, \uc138\uc158\uc744 \uc2dc\uc791\ud558\uba74\uc11c \uc790\ub3d9\uc801\uc73c\ub85c \uadf8 \ub370\uc774\ud0c0\ub97c \uc77d\uc5b4\uc624\uc790 \ud558\ub294\uac70\uc9c0\uc694.<\/p>\n
`user_sessions` \ud14c\uc774\ube14\uc5d0 chk_msg \ub77c\ub294 \ud544\ub4dc\ub97c \ud558\ub098 \ucd94\uac00\ud569\ub2c8\ub2e4.
\nALTER TABLE `user_sessions` ADD `chk_msg` TINYINT(2) UNSIGNED NOT NULL AFTER `last_ip` ;
\n\ub2e4\ub978 \ud68c\uc6d0\uc774 \ucabd\uc9c0\ub97c \ubcf4\ub0bc\ub54c, chk_msg \uac12\uc744 \ud558\ub098\uc529 \uc99d\uac00\uc2dc\ud0a4\uace0, \ucabd\uc9c0\ub97c \ud655\uc778\ud558\uba74 chk_msg \uac12\uc744 0\ub85c update\ud558\ub824\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n
sess_read \ud568\uc218\ub97c \ubcc0\ud615\uc2dc\ucf1c\uc11c, chk_msg \ud544\ub4dc\uac12\uc744 \uc77d\uc5b4\uc624\ub3c4\ub85d \ud569\ub2c8\ub2e4.
\nfunction sess_read($key) {
\n $DB =& DB::getInstance();
\n $DB->query(“SELECT uid, chk_msg, sess_value FROM user_sessions WHERE sess_key = ‘$key’ AND last_log > ‘”.(time()-get_cfg_var(“session.gc_maxlifetime”)).”‘ “);
\n $row=$DB->get();
\n $GLOBALS[“USER”][“id”]=$row[0];
\n $GLOBALS[“USER”][“chk_msg”]=$row[1];
\n return $row[2];
\n}<\/p>\n
\uc5ec\uae30\uc11c\ub294 $USER\ub77c\ub294 \ubcc0\uc218\uc5d0 \ud68c\uc6d0ID, \ubc1b\uc740\ucabd\uc9c0 \uac2f\uc218\ub97c \uc800\uc7a5\ud558\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4. \uc989 \ud68c\uc6d0ID\ub97c \uc54c\uae30 \uc704\ud574 $_SESSION[“id”]\ub97c \uc4f0\uc9c0 \uc54a\uace0 $USER[“id”]\ub97c \uc4f8 \uc218 \uc788\ub2e4\ub294 \uac70\uc9c0\uc694. \ubc1b\uc740 \ucabd\uc9c0 \uac2f\uc218\ub294 $USER[“chk_msg”]\uc5d0 \ub4e4\uc5b4\uac00\ub2c8\uae4c \ub9e4\ubc88 \uc774 \uac12\uc744 \uac80\uc0ac\ud574\uc11c “\ub529\ub3d9~ \uba54\uc2dc\uc9c0\uac00 \ub3c4\ucc29\ud588\uc2b5\ub2c8\ub2e4” \ub77c\uace0 \uc54c\ub824\uc8fc\uba74 \ub429\ub2c8\ub2e4.<\/p>\n
“\ubb50\uc57c, \ub09c\ub370\uc5c6\uc774 $USER \ub77c\ub294 \uae00\ub85c\ubc8c \uc624\ube0c\uc81d\ud2b8\ub77c\ub2c8…. \ub09c \uc774\ub7f0\uac70 \uc2eb\uc5b4” \ud558\uc2dc\ub294 \ubd84.
\n\uc5ec\uae30\uc11c $USER\uc640 \uac19\uc740 \ubcc0\uc218\ub97c \ud560\ub2f9\ud558\uc9c0 \uc54a\uace0, $_SESSION\uc744 \uc0ac\uc6a9\ud574\ub3c4 \ub429\ub2c8\ub2e4. $USER[“chk_msg”]=”1″ \ub300\uc2e0\uc5d0 $_SESSION[“chk_msg”] = “1” \uc774\ub77c\uace0 \uc368\ub3c4 \ub41c\ub2e4\ub294 \uac81\ub2c8\ub2e4. \uc138\uc158\ud568\uc218 \uc548\uc5d0\uc11c $_SESSION\uc744 \uc0ac\uc6a9\ud55c\ub2e4\ub2c8, \ud669\ub2f9\ud55c \ud2b8\ub9ad\uc774\uc8e0? \ubc88\uac70\ub86d\uac8c \uc138\uc158\uac12($row[2])\uc744 \uc9c1\uc811 \ud30c\uc2f1\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.
\n\ub2e4\ub9cc, \uc774\uac83\uc740 \ub9e8\ucc98\uc74c 1\ubc88\ub9cc \uc801\uc6a9\ub429\ub2c8\ub2e4. \ub2e4\uc74c\ubc88\uc5d0 $_SESSION[“chk_msg”] = “2” \ub77c\uace0 \ud558\ub354\ub77c\ub3c4, \uc774\ubbf8 \uc138\uc158 \ub370\uc774\ud0c0 \uc548\uc5d0 “chk_msg”\uac12\uc774 1\ub85c \ub4e4\uc5b4\uc788\uae30 \ub54c\ubb38\uc5d0, \uacb0\uacfc\ub294 “1”\ub85c \ub098\uc635\ub2c8\ub2e4. \ub530\ub77c\uc11c $_SESSON[“chk_msg”] \uac12\uc744 \ud655\uc778\ud574\uc11c “\ub529\ub3d9~” \ud558\ub294 \uba54\uc2dc\uc9c0\ub97c \ubcf4\uc5ec\uc8fc\uac70\ub098 \ub9d0\uac70\ub098 \ud55c \ud6c4\uc5d0, \ub9e4\ubc88 unset($_SESSION[“chk_msg”])\ub97c \ud574\uc918\uc57c\ud558\uaca0\uc8e0?<\/p>\n
\n——————————<\/p>\n
\uc7ac\ubbf8\uc788\uc73c\uc168\ub098\uc694?
\n“\ud55c\ubc88 \ub354 \uc0dd\uac01\ud558\uace0 DB\ub97c \ub9cc\ub4e4\uc790”\ub294 \ucde8\uc9c0\uc5d0\uc11c \ud55c\ubc88 \uc368\ubd24\uace0, \ub098\ub984\ub300\ub85c \ud6a8\uc728\uc801\uc774\ub77c\uace0 \uc0dd\uac01\ud558\ub294\ub370… \uc7a5\ub2f4\uc740 \ubabb\ud558\uaca0\ub124\uc694. \uc624\ub958\ub098 \uc815\uc815\uc0ac\ud56d\uc740 \ub9ac\ud50c \ubd80\ud0c1\ub4dc\ub9bd\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
[1] \ub300\uac1c\uc758 \uacbd\uc6b0, \ud68c\uc6d0 \ub85c\uadf8\uc778\uc5d0 \uc138\uc158\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc989 \ud68c\uc6d0\uc73c\ub85c \ub85c\uadf8\uc778\ud558\uc9c0 \uc54a\uc73c\uba74 \uc138\uc158\uc744 \uc0ac\uc6a9\ud560 \uc77c\uc774 \uc5c6\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc11c\ub294 \ud68c\uc6d0 \uc804\uc6a9 \uc138\uc158\ub9cc \uad00\ub9ac\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. [2] \uc138\uc158 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4\uc11c, \uc5ec\uae30\uc5d0 \ub9e4\ubc88 insert, delete\ub97c \ud558\ub294 \uac83\uc740 \ube44\ub85d \ud14c\uc774\ube14 \ud06c\uae30\uac00 \uc791\ub2e4\uace0 \ud558\ub354\ub77c\ub3c4 \uc81c\ubc95 \ubd80\ud558\ub97c \uc90d\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc5ec\uae30\uc11c\ub294 delete\ub97c \uc4f0\uc9c0 \uc54a\uace0 update\ub9cc \uc0ac\uc6a9\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. \ud68c\uc6d0\uc774 \uba87\ub9cc\uba85\uc774\ub77c\uace0 \ud560\uc9c0\ub77c\ub3c4 \uc774\uac8c \ub354 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[51],"tags":[],"class_list":["post-881","post","type-post","status-publish","format-standard","hentry","category-papa-php"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/881","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=881"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/881\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=881"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=881"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=881"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}