{"id":1367,"date":"2003-10-16T17:39:42","date_gmt":"2003-10-16T17:39:42","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1367"},"modified":"2003-10-16T17:39:42","modified_gmt":"2003-10-16T17:39:42","slug":"phpmysql%eb%b0%b1%eb%a7%8c%ea%b1%b4-%ea%b2%8c%ec%8b%9c%ed%8c%90-%eb%a7%8c%eb%93%a4%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1367","title":{"rendered":"[php+mysql]\ubc31\ub9cc\uac74 \uac8c\uc2dc\ud310 \ub9cc\ub4e4\uae30"},"content":{"rendered":"<p> php  \uc2a4\ucfe8\uc5d0  \uc62c\ub77c\uc654\ub358  \ub0b4\uc6a9\uc785\ub2c8\ub2e4.<br \/>\n\uc544\ub798\uc758  \uc54c\uace0\ub9ac\uc998\uc5d0  \ub530\ub77c  \uc81c\uac00  \ub9cc\ub4e4\uc5b4\ubcf8  \ud14c\uc2a4\ud2b8  \uc0ac\uc774\ud2b8\uc785\ub2c8\ub2e4.<br \/>\nhttp:\/\/222.112.187.32:9090:8080\/blueboard\/list.php?tbn=test<\/p>\n<p>\ud14c\uc2a4\ud2b8  \ub370\uc774\ud130\ub97c  \ub123\ub294\ub370  10\ub9cc\uac74  \ud55c\ubc88\uc5d0  \ub123\uc73c\ub2c8\uae4c  \ub0b4  \ucef4\ud4e8\ud130\uac00  \ub2e4\uc6b4  \ub418\ub294\uad70\uc5ec..<br \/>\n5\ub9cc\uac74\uc529  \ub123\ub2e4\ubcf4\ub2c8\uae4c  \uc2dc\uac04\uc774  \ub9c8\ub2c8  \uac78\ub824\uc11c..  \uc544\uc9c1  \ub370\uc774\ud130\uac00  \ubc31\ub9cc\uac74  \uc548\ub429\ub2c8\ub2e4\ub9cc  \uc2dc\uac04\ub098\ub294\ub300\ub85c  \ubc31\ub9cc\uac74  \ub123\uace0  \ud14c\uc2a4\ud2b8\ud574\ubcf4\uc838.<\/p>\n<p>UID  :  \uc790\ub3d9\uc99d\uac00\ud544\ub4dc<br \/>\nPID  :  \uc815\ub82c\ud544\ub4dc(\uc778\ub371\uc2a4)<br \/>\nTHREAD  :  \uc751\ub2f5\uae00\uc758  \uae4a\uc774<\/p>\n<p>\ucd5c\ucd08  \ub4f1\ub85d\uae00\uc740<br \/>\nUID  :  1<br \/>\nPID  :  9999999.0000<br \/>\nTHREAD  :  0<br \/>\n\uc774  \ub429\ub2c8\ub2e4.<\/p>\n<p>\ub450\ubc88\uc9f8  \ub4f1\ub85d\uae00\uc740<br \/>\nUID  :  2<br \/>\nPID  :  9999998.0000<br \/>\nTHREAD  :  0<\/p>\n<p>\uccab\ubc88\uc9f8  \ub4f1\ub85d\uae00\uc5d0  \ub2f5\ubcc0\uae00\uc744  \ub2ec\uba74<br \/>\nUID  :  3<br \/>\nPID  :  9999999.0001<br \/>\nTHREAD  :  1<br \/>\n\uc774  \ub429\ub2c8\ub2e4.<\/p>\n<p>\uccab\ubc88\uc9f8  \ub4f1\ub85d\uae00\uc758  \ub2f5\ubcc0\uae00\uc5d0  \ub2f5\ubcc0\uc744  \ub2ec\uba74<br \/>\nUID  :  4<br \/>\nPID  :  9999999.0002<br \/>\nTHREAD  :  2<br \/>\n\uac00  \ub429\ub2c8\ub2e4..<br \/>\n\uc6d0\ubcf8\uae00\uc758  PID  \uc5d0    0.0001  \uc744  \ub354\ud574\uc8fc\uace0<br \/>\n\uc6d0\ubcf8\uae00\uc758  THREAD  \uc5d0  1  \uc744  \ub354\ud574\uc90d\ub2c8\ub2e4.<\/p>\n<p>\uccab\ubc88\uc9f8  \ub4f1\ub85d\uae00\uc758  \uccab\ubc88\uc9f8\ub2f5\ubcc0\uae00\uc5d0  \ub2f5\ubcc0\uc744  \ub2ec\uba74<br \/>\nUID  :  5<br \/>\nPID  :  9999999.0002<br \/>\nTHREAD  :  2<br \/>\n\uac00  \ub418\uace0  \uc774\ub54c,  \ub2f5\ubcc0\uae00\uc758  PID  \ub97c  \uc5c5\ub370\uc774\ud2b8  \ud569\ub2c8\ub2e4..<br \/>\n          PID<br \/>\n&#8212;&#8212;&#8212;&#8211;<br \/>\n9999999.0000<br \/>\n9999999.0001<br \/>\n9999999.0002<\/p>\n<p>\uc5d0\uc11c  9999999.0001  \uc5d0  \ub2f5\ubcc0\uc744  \ub2ec\uba74<br \/>\n\uadf8  \ub2f5\ubcc0\uae00\uc758  PID  \ub294  +  0.0001  \uc744  \ud1b5\ud574  9999999.0002  \ub85c  \ub4f1\ub85d\ud574  \uc8fc\uace0<br \/>\n\uc774\ubbf8  \uc788\uc5c8\ub358  9999999.0002  \ub294  +  0.0001  \uc744  \ud1b5\ud574  9999999.0003  \uc73c\ub85c  \uc5c5\ub370\uc774\ud2b8\ud574  \uc90d\ub2c8\ub2e4..<\/p>\n<p>\uc77c\ubc18\uc801\uc778  \uc5c5\ub370\uc774\ud2b8  \uac8c\uc2dc\ud310\uc5d0\uc11c  10\ub9cc\uac1c\uc758  \uac8c\uc2dc\ubb3c\uc774  \uc788\uc744\ub54c  1\ubc88\uae00\uc5d0  \ub2f5\ubcc0\uc744  \ub2ec\uba74  99999\uac1c\uc758  \uac8c\uc2dc\ubb3c\uc744  \uc5c5\ub370\uc774\ud2b8\ud574\uc57c  \ud558\ubbc0\ub85c  \uae00\ub4f1\ub85d\uc18d\ub3c4\uac00  \uc0c1\ub2f9\ud788  \ub290\ub824\uc9c0\ub294\ub370\uc694..<\/p>\n<p>\uc704\uc640  \uac19\uc740  \uacbd\uc6b0  10\ub9cc\uac1c\ub294  \ubb3c\ub860  100\ub9cc\uac1c\uc77c\ucc0c\ub77c\ub3c4  \uc804\uccb4\ub97c  \uc5c5\ub370\uc774\ud2b8\ud558\uc9c0  \uc54a\uace0<br \/>\nPID  \uc911  \uc18c\uc218\uc810\uc774\uc0c1\uc774  \uac19\uc740  \uac8c\uc2dc\ubb3c\uc5d0  \ub300\ud574\uc11c\ub9cc  \uc5c5\ub370\uc774\ud2b8\ub97c  \ud558\ubbc0\ub85c  \uae00\ub4f1\ub85d\uc5d0  \ub530\ub978  \uc18d\ub3c4\uc800\ud558\uac00  \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc77c\ubc18\uae00  \ub4f1\ub85d\uc2dc\ub294  <\/p>\n<p>$PID_NUM  =  mysql_fetch_array(mysql_query(&#8220;SELECT  min(PID)  FROM  $table&#8221;,  $DB_CONNECT));<br \/>\nif($PID_NUM[0])  {$PID  =  $PID_NUM[0]  &#8211;  1;}  else  {$PID  =  9999999.0000;}<\/p>\n<p>\ub2f5\ubcc0\uae00  \ub4f1\ub85d\uc2dc\ub294<\/p>\n<p>$REPLY_DATA  =  mysql_fetch_array(mysql_query(&#8220;SELECT  *  FROM  $table  WHERE  UID=&#8217;$\uc6d0\ubcf8\uae00\uc758UID\uac12'&#8221;,$DB_CONNECT));<br \/>\nif($REPLY_DATA[PID])  {<br \/>\n$PID  =  $REPLY_DATA[PID]  +  0.0001;<br \/>\n$DPID  =  $REPLY_DATA[PID];<br \/>\n$UPID  =  intval($PID)+1;<br \/>\n$THREAD  =  $REPLY_DATA[THREAD]  +  1;<\/p>\n<p>mysql_query(&#8220;UPDATE  myplus_$table  SET  PID=PID+0.0001  WHERE  PID  >  $DPID  AND  PID  <  $UPID\",$DB_CONNECT)  or  die(mysql_error());\n\n\ubcf8\uc54c\uace0\ub9ac\uc998\uc740  \uc18c\uc218\uc810\uc744  \uc774\uc6a9\ud558\uba74\uc11c  \ub2f5\ubcc0\uae00\ub9cc  \uc5c5\ub370\uc774\ud2b8\ud558\ub294  \ubc29\uc2dd\uc774\uad6c\uc694..\n\uae30\ubcf8\uc774  ASC  \uc815\ub82c\uc774\ubbc0\ub85c  \uc18d\ub3c4\uc5d0  \uc788\uc5b4\uc11c\ub3c4  \uac1c\uc120\uc774  \uc788\uc2b5\ub2c8\ub2e4..\n\n\ubb38\uc81c\uac00  \uc788\ub2e4\uba74  9999999\uac1c\ub97c  \ub118\uc5b4\uc11c\ub294  \uc6d0\ubcf8\uae00\uc774  \ub4f1\ub85d\ub418\ub294  \uacbd\uc6b0\uc640  \n\ud558\ub098\uc758  \uc6d0\ubcf8\uae00\uc5d0  \ub2f5\ubcc0\uae00\uc774  9999\uac1c  \uc774\uc0c1\uc774  \ub2ec\ub9ac\ub294  \uacbd\uc6b0\uc785\ub2c8\ub2e4..\n\uc774  \ub450\ubb38\uc81c\ub294  \uac70\uc758  \ud76c\ubc15\ud558\uaca0\uc9c0\uc694..\n\n\n\ud558\uc9c0\ub9cc  \uc704\uc758  \uc54c\uace0\ub9ac\uc998\uc73c\ub85c\ub9cc  \ud558\ub2e4\ubcf4\uba74  \ubb38\uc81c\uc810\uc774  \uc788\uc2b5\ub2c8\ub2e4.\n\ucca8  \ud398\uc774\uc9c0\ub4e4\uc740  \ubb34\uc7c8\uac8c  \uc18d\ub3c4\uac00  \ub098\uc624\uc9c0\ub9cc  \ub4a4\ub85c  \uac08\uc218\ub85d  \uc18d\ub3c4  \uc800\ud558\uac00  \uc0c1\ub2f9\ud558\uc838..\n10\ub9cc\uac74\uae4c\uc9c0\ub294  \ub9c8\uc9c0\ub9c9\ud398\uc774\uc9c0\uac00  1\ucd08\uc815\ub3c4  \ub098\uc624\uc9c0\ub9cc..\n15\ub9cc\uac74  \uc815\ub3c4  \ub418\ub2c8\uae4c..  60\ucd08\uae4c\uc9c0  \ub098\uc624\ub294  \uad70\uc5ec..\n\uc774\uc0c1\uc758  \ubc29\ubc95\uc774  \uccab\ub9ac\uc2a4\ud2b8\ub97c  \ubf51\uc544\uc624\ub294\ub370\ub294  \ucd5c\uc0c1\uc758  \uc18d\ub3c4\ub97c  \ub0bc  \uc218  \uc788\uc9c0\ub9cc  \n\n\ubc18\uc5c5\ub370\uc774\ud2b8\ud615  \uc54c\uace0\ub9ac\uc998\uc758  \ucde8\uc57d\uc810\uc778  \ub4a4\ucabd\uc73c\ub85c  \uac08  \uc218\ub85d  \ud398\uc774\uc9d5\uc774  \uae09\uaca9\ud788  \ub290\ub824\uc9c0\ub294  \ud604\uc0c1  \uc989  \uc808\ub300\ub85c  LIMIT  100000,20  \uacfc  \uac19\uc740  LIMIT  \uc73c\ub85c\ub294  \ub4b7\ud398\uc774\uc9c0\uc5d0\uc11c  \uc18d\ub3c4\ub97c  \ub0bc  \uc218  \uc5c6\uc2b5\ub2c8\ub2e4.\n\n\uadf8\ub798\uc11c  where\uc808\uc5d0  PID\uc758  \uc2dc\uc791\ud3ec\uc778\ud2b8\ub85c  \uac78\ub7ec\uc8fc\ub294\uac8c  \ud544\uc694\ud569\ub2c8\ub2e4.\n\n$RECNUM  =  15;  \/\/\ud55c\ud398\uc774\uc9c0\ub2f9  \ucd9c\ub825\uc218\n$START_NUM  =  ($p-1)*$RECNUM;  \/\/  \ud398\uc774\uc9c0\ubd84\ud560\uc2dc\uc791\uc810\n$TEMP_DATA  =  mysql_fetch_array(mysql_query(\"SELECT  PID  \nFROM  $table  ORDER  BY  PID  LIMIT  $START_NUM,1\",  $DB_CONNECT));\n\/\/  INDEX\uac00  \uac78\ub9b0  PID\ub97c  \uc815\ub82c\uc2dc\ucf1c  \ub808\ucf54\ub4dc  \ud558\ub098\ub9cc  \ubd88\ub7ec\uc635\ub2c8\ub2e4.\n$S_PID  =  $TEMP_DATA[PID]-0.0001;  \/\/\uc2dc\uc791\ud3ec\uc778\ud2b8\uc5d0\uc11c  0.0001\uc744  \ube7c\uc90d\ub2c8\ub2e4.\nif(!$START_NUM)  $S_PID  =  intval($S_PID)-1;  \/\/\uccab\ubc88\uc9f8\ud398\uc774\uc9c0\ub77c\uba74  1\uc744  \ube7c\uc90d\ub2c8\ub2e4.\n\/\/  \uc774\uc0c1\uc744  \ud1b5\ud574  $S_PID,  \uc989  PID  \uc758  \uc2dc\uc791\ud3ec\uc778\ud2b8\ub97c  \uc54c\uc544\ub0c8\uc2b5\ub2c8\ub2e4.\n\n$TABLE_DATA  =  mysql_query(\"SELECT  *  FROM  $table  WHERE  PID  >  $S_PID  ORDER  BY  $sort  $orderby  LIMIT  0,$RECNUM&#8221;,  $DB_CONNECT);<br \/>\n\/\/  PID  \uc2dc\uc791\ud3ec\uc778\ud2b8\ubcf4\ub2e4  PID  \uac00  \ud070\uae00\uc744  LIMIT  0,$RECNUM  \uc744  \ud1b5\ud574  $RECNUM\ub9cc\ud07c\ub9cc  \ubf51\uc544\uc635\ub2c8\ub2e4..<br \/>\n\/\/  \uc774\ub54c,  \ud56d\uc0c1  LIMIT  0,$RECNUM  \uc744  \uc774\uc6a9\ud558\ubbc0\ub85c  \uc18d\ub3c4\uac00  \uc800\ud558\ub418\uc9c0  \uc54a\uc2b5\ub2c8\ub2e4.<br \/>\n\/\/  \ubb38\uc81c\ub294  $S_PID  \ub97c  \uad6c\ud560\ub54c  \uc778\ub371\uc2a4\uac00  \uac78\ub824\uc788\ub2e4\uace0  \ud574\ub3c4  LIMIT  1000000,1  \uc744<br \/>\n\/\/  \uc0ac\uc6a9\ud558\ubbc0\ub85c  \uc18d\ub3c4\uac00  \ub5a8\uc5b4\uc9c0\ub294\ub370..  \uc774  \uc218\uce58\ub294  \uac8c\uc2dc\ubb3c  100\ub9cc\uac74\uc77c\ub54c  \ub9c8\uc9c0\ub9c9\ud398\uc774\uc9c0\ub97c<br \/>\n\/\/  \ubd88\ub7ec\uc624\ub294  \uc18d\ub3c4\uac00  \ub300\ub7b5  0.7~1  \ucd08  \uc815\ub3c4\ub418\ub294\uad70\uc694..<br \/>\n\/\/  100\ub9cc\uac74\uc5d0\uc11c  \ub9c8\uc9c0\ub9c9  \ud398\uc774\uc9c0\uac00  1\ucd08\uc774\ub0b4\uc774\uba74  \uadf8\ub7f0\ub300\ub85c  \ub9cc\uc871\ud560\ub9cc\ud55c  \uc218\uce58\uc785\ub2c8\ub2e4.<br \/>\n\/\/  \ubb3c\ub860  \uc190\uc744  \ub354  \ubcf4\uc544\uc57c  \ud560  \uac83  \uac19\uc2b5\ub2c8\ub2e4&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>php \uc2a4\ucfe8\uc5d0 \uc62c\ub77c\uc654\ub358 \ub0b4\uc6a9\uc785\ub2c8\ub2e4. \uc544\ub798\uc758 \uc54c\uace0\ub9ac\uc998\uc5d0 \ub530\ub77c \uc81c\uac00 \ub9cc\ub4e4\uc5b4\ubcf8 \ud14c\uc2a4\ud2b8 \uc0ac\uc774\ud2b8\uc785\ub2c8\ub2e4. http:\/\/222.112.187.32:9090:8080\/blueboard\/list.php?tbn=test \ud14c\uc2a4\ud2b8 \ub370\uc774\ud130\ub97c \ub123\ub294\ub370 10\ub9cc\uac74 \ud55c\ubc88\uc5d0 \ub123\uc73c\ub2c8\uae4c \ub0b4 \ucef4\ud4e8\ud130\uac00 \ub2e4\uc6b4 \ub418\ub294\uad70\uc5ec.. 5\ub9cc\uac74\uc529 \ub123\ub2e4\ubcf4\ub2c8\uae4c \uc2dc\uac04\uc774 \ub9c8\ub2c8 \uac78\ub824\uc11c.. \uc544\uc9c1 \ub370\uc774\ud130\uac00 \ubc31\ub9cc\uac74 \uc548\ub429\ub2c8\ub2e4\ub9cc \uc2dc\uac04\ub098\ub294\ub300\ub85c \ubc31\ub9cc\uac74 \ub123\uace0 \ud14c\uc2a4\ud2b8\ud574\ubcf4\uc838. UID : \uc790\ub3d9\uc99d\uac00\ud544\ub4dc PID : \uc815\ub82c\ud544\ub4dc(\uc778\ub371\uc2a4) THREAD : \uc751\ub2f5\uae00\uc758 \uae4a\uc774 \ucd5c\ucd08 \ub4f1\ub85d\uae00\uc740 UID : 1 PID : 9999999.0000 THREAD : &hellip; <a href=\"https:\/\/bluesoul.pe.kr\/wp\/?p=1367\" class=\"more-link\">\uacc4\uc18d \uc77d\uae30<span class=\"screen-reader-text\"> &#8220;[php+mysql]\ubc31\ub9cc\uac74 \uac8c\uc2dc\ud310 \ub9cc\ub4e4\uae30&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1367","post","type-post","status-publish","format-standard","hentry","category-tip"],"_links":{"self":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1367","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1367"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1367\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1367"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1367"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1367"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}