{"id":1723,"date":"2008-06-23T04:26:30","date_gmt":"2008-06-23T04:26:30","guid":{"rendered":"http:\/\/dev.jblove.net\/?p=1723"},"modified":"2008-06-23T04:26:30","modified_gmt":"2008-06-23T04:26:30","slug":"%ec%a7%9c%ec%a7%91%ea%b8%b0%ed%95%9c-mysql-%ed%81%b4%eb%9e%98%ec%8a%a4","status":"publish","type":"post","link":"https:\/\/jblove.net\/?p=1723","title":{"rendered":"\uc9dc\uc9d1\uae30\ud55c MYSQL \ud074\ub798\uc2a4"},"content":{"rendered":"<p><P>20\uc5ec\uac1c\uc758 mysql \uad00\ub828 \ud074\ub798\uc2a4\uc911\uc5d0\uc11c \ud544\uc694\ud55c \uac83\ub9cc \ubaa8\uc544\uc11c \uc9dc\uc9d1\uae30\ud55c \ud074\ub798\uc2a4&#8230;<BR>\uc77c\ubc18\uc801\uc778 mysql \ud074\ub798\uc2a4\uc5d0 \ub9ac\uc2a4\ud2b8\uc640 \ud398\uc774\uc9d5\uae4c\uc9c0 \ud55c\ubc88\uc5d0 \ucc98\ub9ac\ud558\ub294 \ud568\uc218\uc640 xml\ub85c \uacb0\uacfc\ub97c \ucd9c\ub825\ud558\ub294<BR>\ud568\uc218 \ucd94\uac00.<\/P><br \/>\n<P>\ud074\ub798\uc2a4\ub0b4\uc6a9 &gt;&gt;<\/P><br \/>\n<P>[code]<BR>\/\/DB\ud074\ub798\uc2a4<BR>class dbH {<BR>&nbsp; &nbsp; \/\/ PRIVATE \ubcc0\uc218<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $CONN; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \/\/ DB \ucee4\ub125\ud2b8<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $ERR_QUERY; &nbsp;&nbsp; \/\/ \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c \ucffc\ub9ac<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $ERR_MSG; &nbsp; &nbsp; &nbsp;&nbsp; \/\/ \uc5d0\ub7ec \uba54\uc138\uc9c0<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $RESULT; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \/\/ \ucffc\ub9ac \uacb0\uacfc<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $REC_COUNT; &nbsp;&nbsp; \/\/ \ub808\ucf54\ub4dc \ud569\uacc4<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $ROW; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \/\/ \ub808\ucf54\ub4dc \uacb0\uacfc FETCH<BR>&nbsp; &nbsp; private &nbsp;&nbsp; $ROWNUM; &nbsp; &nbsp; &nbsp;&nbsp; \/\/ \ud604\uc7ac \ub808\ucf54\ub4dc \ubc88\ud638<\/P><br \/>\n<P><BR>&nbsp; &nbsp; \/\/ \ud074\ub798\uc2a4 \ucd08\uae30\ud654<BR>&nbsp; &nbsp; function dbH() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $DB_HOST = &#8220;localhost&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $DB_USER = &#8220;new_chong&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $DB_PW = &#8220;new3432&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $DB_NAME = &#8220;new_chong&#8221;;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;CONN = mysql_connect($DB_HOST, $DB_USER, $DB_PW) or die(&#8220;\ub370\uc774\ud130\ubca0\uc774\ud2b8 \uc5f0\uacb0 \uc2e4\ud328! \ud658\uacbd\uc124\uc815\uc744 \ud655\uc778\ud574\uc8fc\uc138\uc694.&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp; mysql_select_db($DB_NAME, $this-&gt;CONN) or die(&#8220;\ub370\uc774\ud130\ubca0\uc774\ud2b8 \uc811\uadfc \uc2e4\ud328! \ud658\uacbd\uc124\uc815\uc744 \ud655\uc778\ud574\uc8fc\uc138\uc694.&#8221;);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; function getMessage()<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;message;<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/GET NUM ROWS<BR>&nbsp; &nbsp; function getNumRows()<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; return mysql_num_rows($this-&gt;result);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/GET AFFECTED ROWS<BR>&nbsp; &nbsp; function getAffectedRows()<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; return mysql_affected_rows($this-&gt;result);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P><BR>&nbsp; &nbsp; \/\/ INSERT, UPDATE, DELETE \ub4f1\uc758 \ucffc\ub9ac\ubb38 \uc2e4\ud589. (\uacb0\uacfc \uc5c6\uc74c)<BR>&nbsp; &nbsp; function Open($query) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ERR_MSG = &#8220;&#8221;;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; if (!mysql_query($query)) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ERR_QUERY = $query;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ERR_MSG = mysql_error();<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ SELECT \ucffc\ub9ac\ubb38 \uc2e4\ud589. (\uacb0\uacfc \uc788\uc74c)<BR>&nbsp; &nbsp; function Execute($query) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ERR_MSG = &#8220;&#8221;;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; if (!$this-&gt;RESULT = mysql_query($query)) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ERR_QUERY = $query;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ERR_MSG = mysql_error();<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; else {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;REC_COUNT = mysql_num_rows($this-&gt;RESULT);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROW = mysql_fetch_assoc($this-&gt;RESULT);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROWNUM = 0;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ RecordCount<BR>&nbsp; &nbsp; function RecordCount() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;REC_COUNT;<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/\/insert_ID<BR>&nbsp; &nbsp; &nbsp; &nbsp; function InsertID() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;result=mysql_insert_id($this-&gt;CONN)){<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return($this-&gt;result);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; } else {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;errorMessage(&#8220;Cannot retrieve auto_increment value: $this-&gt;CONN&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<\/P><br \/>\n<P><BR>&nbsp; &nbsp; \/\/ \ub808\ucf54\ub4dc \ucc98\uc74c<BR>&nbsp; &nbsp; function MoveFirst() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; mysql_data_seek($this-&gt;RESULT, 0);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROW = mysql_fetch_assoc($this-&gt;RESULT);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ \ub808\ucf54\ub4dc \ub9c8\uc9c0\ub9c9<BR>&nbsp; &nbsp; function MoveLast() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; mysql_data_seek($this-&gt;RESULT, $this-&gt;REC_COUNT &#8211; 1);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROW = mysql_fetch_assoc($this-&gt;RESULT);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ \ub2e4\uc74c \ub808\ucf54\ub4dc<BR>&nbsp; &nbsp; function MoveNext() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROWNUM = $this-&gt;ROWNUM + 1;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; if ($this-&gt;ROWNUM &lt; $this-&gt;REC_COUNT) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_data_seek($this-&gt;RESULT, $this-&gt;ROWNUM);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROW = mysql_fetch_assoc($this-&gt;RESULT);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; else { return false; }<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ \uc774\uc804 \ub808\ucf54\ub4dc<BR>&nbsp; &nbsp; function MovePrev() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROWNUM = $this-&gt;ROWNUM &#8211; 1;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; if ($this-&gt;ROWNUM &gt;= 0) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mysql_data_seek($this-&gt;RESULT, $this-&gt;ROWNUM);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;ROW = mysql_fetch_assoc($this-&gt;RESULT);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; else { return false; }<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ \ud544\ub4dc\uac12 \uac00\uc838\uc624\uae30<BR>&nbsp; &nbsp; function Field($field_name) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;ROW[$field_name];<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d \uc885\ub8cc<BR>&nbsp; &nbsp; function Close() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; mysql_close($this-&gt;CONN);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/\/ \uac00\uc7a5 \ucd5c\uadfc \uc5d0\ub7ec\uba54\uc138\uc9c0 \ud45c\uc2dc<BR>&nbsp; &nbsp; function ShowError() {<BR>&nbsp; &nbsp; &nbsp; &nbsp; if (strlen($this-&gt;ERR_MSG) &gt; 0) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg = &#8220;&lt;big&gt;&lt;b&gt;\uc624\ub958 \ub0b4\uc5ed\uc785\ub2c8\ub2e4&lt;\/b&gt;&lt;\/big&gt;&lt;br&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;table width=&#8217;100%&#8217; border=&#8217;0&#8242; cellpadding=&#8217;4&#8242; cellspacing=&#8217;1&#8242; bgcolor=&#8217;#BCBCBC&#8217;&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;tr&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;td bgcolor=&#8217;#EFEFEF&#8217;&gt;&lt;span style=&#8217;font-size : 9pt;&#8217;&gt;&lt;b&gt;\uc2e4\ud589\ub41c \ucffc\ub9ac\ubb38&lt;\/b&gt;&lt;\/span&gt;&lt;\/td&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;td bgcolor=&#8217;#FFFFFF&#8217;&gt;&lt;span style=&#8217;font-size : 9pt; color : #666666;&#8217;&gt;&#8221;.$this-&gt;ERR_QUERY.&#8221;&lt;\/span&gt;&lt;\/td&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;\/tr&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;tr&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;td bgcolor=&#8217;#EFEFEF&#8217;&gt;&lt;span style=&#8217;font-size : 9pt;&#8217;&gt;&lt;b&gt;\uc5d0\ub7ec \uba54\uc138\uc9c0&lt;\/b&gt;&lt;\/span&gt;&lt;\/td&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;td bgcolor=&#8217;#FFFFFF&#8217;&gt;&lt;span style=&#8217;font-size : 9pt; color : #666666;&#8217;&gt;&#8221;.$this-&gt;ERR_MSG.&#8221;&lt;\/span&gt;&lt;\/td&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;\/tr&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;\/table&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;br&gt;&lt;br&gt;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $msg .= &#8220;&lt;div align=&#8217;center&#8217;&gt;&lt;input type=&#8217;button&#8217; value='&lt;&lt; MOVE BACK&#8217; onClick=&#8217;history.go(-1)&#8217; style=&#8217;border : solid 1 #000000; background-color : #5D5D5D; color : #FFFFFF;&#8217;&gt;&#8221;;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo $msg;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; DO QUERY METHOD:\uacb0\uacfc \uc544\uc774\ub514 \ubc1b\uc544\uc634<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; function doQuery($query)<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;query=$query;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;result=mysql_query($this-&gt;query,$this-&gt;CONN) or die(mysql_error() );<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;result;<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; DO LIST:\ub9ac\uc2a4\ud2b8 \ucd9c\ub825<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; function doList($recordPerPage,$currentPage)<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;i==0)<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $firstRecord=$recordPerPage*($currentPage-1);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;query=$this-&gt;query.&#8217; LIMIT &#8216;.$firstRecord.&#8217;,&#8217;.$recordPerPage;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;result=$this-&gt;doQuery($this-&gt;query);<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; if(!$row=mysql_fetch_array($this-&gt;result) )<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;query=explode(&#8216;LIMIT&#8217;,$this-&gt;query);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;query=$this-&gt;query[0];<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;result=$this-&gt;doQuery($this-&gt;query);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;i=0;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/\/RETURN ROWS<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;i++;<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $row;<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; GET PAGE INDEX:\ud398\uc774\uc9c0 \uc778\ud14d\uc2a4 HTML\ucf54\ub4dc \ubc18\ud658<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; function getPageIndex($recordPerPage,$currentPage)<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; \/\/SET ARRAY REFER TO PARAMETERS:\ud398\uc774\uc9c0 \uc778\ub371\uc2a4 \uc0dd\uc131\uc744 \uc704\ud55c \uae30\ubcf8\uac12 \uc815\ub82c<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[totalRecord] = $this-&gt;getNumRows();<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[recordPerPage] = $recordPerPage;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[pagePerBlock] = 10;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[currentPage] = $currentPage;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/\/CALCULATE PAGE IDNEX:<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[totalPage]=ceil($pageIndex[totalRecord]\/$pageIndex[recordPerPage]);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[currentBlock]=ceil($pageIndex[currentPage]\/$pageIndex[pagePerBlock]);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[totalBlock]=ceil($pageIndex[totalPage]\/$pageIndex[pagePerBlock]);<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/\/FIRST PAGE\/LAST PAGE<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[firstPage]=($pageIndex[currentBlock]*$pageIndex[pagePerBlock]) &#8211; ($pageIndex[pagePerBlock]-1);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[lastPage]=($pageIndex[currentBlock]*$pageIndex[pagePerBlock]);<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/****************************************<BR>&nbsp; &nbsp; &nbsp; &nbsp; \/\/DEFINE NEW QUERY_STRING<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \ud398\uc774\uc9c0 \ub9c1\ud06c \uc815\uc758\ub97c \uc704\ud55c URL\ud30c\uc2f1<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ***************************************\/<BR>&nbsp; &nbsp; &nbsp; &nbsp; parse_str($_SERVER[QUERY_STRING],$QUERY_STRING);<BR>&nbsp; &nbsp; &nbsp; &nbsp; unset($QUERY_STRING[page]);<BR>&nbsp; &nbsp; &nbsp; &nbsp; foreach($QUERY_STRING as $key=&gt;$value)<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$temp){<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $temp=&#8221;$key=$value&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $temp.=&#8221;&amp;$key=$value&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; $QUERY_STRING=$temp;<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/****************************************<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; CREATE PAGE INDEX HTML CODE<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; HTML\ucf54\ub4dc \uc0dd\uc131<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ***************************************\/<BR>&nbsp; &nbsp; &nbsp; &nbsp; ##PREVIOUS BLOCK<BR>&nbsp; &nbsp; &nbsp; &nbsp; if($pageIndex[currentPage] &gt; $pageIndex[pagePerBlock])<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[htmlCode]='&lt;a href=&#8221;.$_SERVER[PHP_SELF].&#8217;?&#8217;.$QUERY_STRING.&#8217;&amp;page=&#8217;.( ($pageIndex[currentBlock]-2)*$pageIndex[pagePerBlock]+1).&#8221; target=&#8217;_self&#8217; onfocus=&#8217;blur();&#8217; &gt; \uc774\uc804 &lt;\/a&gt;&#8217;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; ##PAGE INDEX<BR>&nbsp; &nbsp; &nbsp; &nbsp; for($i=$pageIndex[firstPage]; $i&lt;=$pageIndex[lastPage]; $i++)<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($i&lt;=$pageIndex[totalPage])<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($i==$pageIndex[currentPage])<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[htmlCode].=&#8217; &lt;b&gt;&#8217;.$i.'&lt;\/b&gt;&#8217;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[htmlCode].='&lt;a href=&#8221;.$_SERVER[PHP_SELF].&#8217;?&#8217;.$QUERY_STRING.&#8217;&amp;page=&#8217;.$i.&#8221; target=&#8217;_self&#8217; onfocus=&#8217;blur();&#8217; &gt; &#8216;.$i.&#8217; &lt;\/a&gt;&#8217;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; ##NEXT BLOCK<BR>&nbsp; &nbsp; &nbsp; &nbsp; if($pageIndex[currentBlock] &lt;= ($pageIndex[totalBlock]-1) )<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $pageIndex[htmlCode].='&lt;a href=&#8221;.$_SERVER[PHP_SELF].&#8217;?&#8217;.$QUERY_STRING.&#8217;&amp;page=&#8217;.($pageIndex[currentBlock]*$pageIndex[pagePerBlock]+1).&#8221; target=&#8217;_self&#8217; onfocus=&#8217;blur();&#8217; &gt; \ub2e4\uc74c &lt;\/a&gt;&#8217;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; ##RETURN PAGE INDEX ARRAY<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $pageIndex;<\/P><br \/>\n<P>&nbsp; &nbsp; }\/\/END METHOD<\/P><br \/>\n<P><BR>&nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; DO SELECT<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; function doSelect($query)<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;query=$query;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;result = $this-&gt;doQuery($this-&gt;query);<BR>&nbsp; &nbsp; &nbsp; &nbsp; return mysql_fetch_array($this-&gt;result);<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P><BR>&nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; DO INSERT METHOD<BR>&nbsp; &nbsp;&nbsp; \ubc30\uc5f4\uc744 \ucc38\uc870,\ub370\uc774\ud0c0\ubca0\uc774\uc2a4\uc5d0 \uc785\ub825<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; function doInsert($table,$array)<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; ##GET TABLE STRUCTURE<BR>&nbsp; &nbsp; &nbsp; &nbsp; $query=&#8221;SHOW COLUMNS FROM $table&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $result=mysql_query($query,$this-&gt;CONN);<BR>&nbsp; &nbsp; &nbsp; &nbsp; while($row=mysql_fetch_array($result) )<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $columns[$i]=$row[Field];<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $values[$i]=&#8221;&#8216;&#8221;.$array[$columns[$i]].&#8221;&#8216;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i++;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; $columns=implode(&#8220;,&#8221;,$columns);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $values=implode(&#8220;,&#8221;,$values);<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; ##SEND QUERY STATEMENT;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $query=&#8221;INSERT INTO $table ($columns) VALUES ($values)&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $result=mysql_query($query,$this-&gt;CONN);<BR>&nbsp; &nbsp; &nbsp; &nbsp; if(!$result)<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die(mysql_error() );<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }else{<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; DO UPDATE METHOD<BR>&nbsp; &nbsp;&nbsp; \uc5c5\ub370\uc774\ud2b8<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; function doUpdate($table,$array,$key_name,$key_value)<BR>&nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; ##GET TABLE STRUCTURE<BR>&nbsp; &nbsp; &nbsp; &nbsp; $query=&#8221;SHOW COLUMNS FROM $table&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $result=mysql_query($query,$this-&gt;CONN);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $i=0;<BR>&nbsp; &nbsp; &nbsp; &nbsp; while($row=mysql_fetch_array($result) )<BR>&nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(isset($array[$row[Field]]) )<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $set[$i]=$row[Field].&#8221;='&#8221;.$array[$row[Field]].&#8221;&#8216;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $i++;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; $set=implode(&#8220;,&#8221;,$set);<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; ##EXECUTE QUERY STATEMENT<BR>&nbsp; &nbsp; &nbsp; &nbsp; $query=&#8221;UPDATE $table SET $set WHERE $key_name=&#8217;$key_value'&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;doQuery($query);<BR>&nbsp; &nbsp; &nbsp; &nbsp; return true;<BR>&nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; \ud14c\uc774\ube14 \ub9ac\uc2a4\ud2b8 \ubc18\ud658<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; &nbsp; &nbsp; function GetTableList(){<BR>&nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;result=mysql_list_tables($DB_NAME,$this-&gt;CONN)){<BR>&nbsp; &nbsp; &nbsp; &nbsp; $i=0;<BR>&nbsp; &nbsp; &nbsp; &nbsp; while($i &lt; mysql_num_rows($this-&gt;result)){<BR>&nbsp; &nbsp; &nbsp; &nbsp; $tb_names[$i]=mysql_tablename($this-&gt;result,$i);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $i++;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; return($tb_names);<BR>&nbsp; &nbsp; &nbsp; &nbsp; }else<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;errorMessage(&#8220;Unable to find any tables in database: $DB_NAME&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp;&nbsp; \ud544\ub4dc\uba85 \ubc18\ud658<BR>&nbsp; &nbsp;&nbsp; *******************************************\/<BR>&nbsp; &nbsp; &nbsp; &nbsp; function GetFieldList($tbl_name){<BR>&nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;result=mysql_list_fields($DB_NAME,$tbl_name,$this-&gt;CONN)){<BR>&nbsp; &nbsp; &nbsp; &nbsp; $i=0;<BR>&nbsp; &nbsp; &nbsp; &nbsp; while($i &lt; mysql_num_fields($this-&gt;result)){<BR>&nbsp; &nbsp; &nbsp; &nbsp; $fd_names[$i]=mysql_field_name($this-&gt;result,$i);<BR>&nbsp; &nbsp; &nbsp; &nbsp; $i++;<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; return($fd_names);<BR>&nbsp; &nbsp; &nbsp; &nbsp; }else<BR>&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;errorMessage(&#8220;Unable to find any field list in table: $tbl_name&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<\/P><br \/>\n<P>&nbsp; &nbsp; &nbsp; &nbsp; \/********************************************<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; returns XML-formatted record rows from query results.<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; $this-&gt;data holds the XML only, and the function returns the XML header + the data<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; example:<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; header(&#8220;Content-type: text\/xml&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo $sql-&gt;XML_Output(&#8220;SELECT * FROM yourTable&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; ********************************************\/<BR>&nbsp; &nbsp; &nbsp; &nbsp; function XML_DataOutput($query, $tags = array(&#8216;dataset&#8217;,&#8217;record&#8217;)) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;result=mysql_query($query,$this-&gt;CONN)) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;fields=mysql_num_fields($this-&gt;result);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $xmlheader='&lt;?xml version=&#8221;1.0&#8243; ?&gt;&#8217;.&#8221;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;data.='&lt;&#8216;.$tags[0].&#8217;&gt;&#8217;.&#8221;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($this-&gt;rows = mysql_fetch_array($this-&gt;result)) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;data.= &#8220;<A href=\"file:\/\/\\\\t&quot;.'<'.$tags[1].'>&#8216;&#8221;>\\\\t&#8221;.'&lt;&#8216;.$tags[1].&#8217;&gt;&#8217;<\/A>.&#8221;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; for($i=0; $i&lt;$this-&gt;fields; $i++) {<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tag = mysql_field_name($this-&gt;result,$i);<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;data.=&#8221;<A href=\"file:\/\/\\\\t\\\\t&quot;.'<'.$tag.'>&#8216;&#8221;>\\\\t\\\\t&#8221;.'&lt;&#8216;.$tag.&#8217;&gt;&#8217;<\/A>. preg_replace(&#8220;\/([\\\\r])\/&#8221;, &#8221;, strip_tags($this-&gt;rows[$i])). &#8216;&lt;\/&#8217;.$tag.&#8217;&gt;&#8217;.&#8221;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;data.= &#8220;<A href=\"file:\/\/\\\\t&quot;.'<\/'.$tags[1].'>&#8216;&#8221;>\\\\t&#8221;.'&lt;\/&#8217;.$tags[1].&#8217;&gt;&#8217;<\/A>.&#8221;&#8221;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;data.= &#8216;&lt;\/&#8217;.$tags[0].&#8217;&gt;&#8217;;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $xmlheader.$this-&gt;data;<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else<BR>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;errorMessage(&#8220;Unable to perform query: $query; in XML output&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp; }<BR>[\/code]<\/P><br \/>\n<P>\uc0ac\uc6a9\ubc95&gt;&gt;<\/P><br \/>\n<P>$db = new dbH();<BR>[code]<BR>\/\/ \ucffc\ub9ac \uc2e4\ud589<BR>$query = &#8220;SELECT * FROM p_board ORDER BY i_seq DESC LIMIT 0, 10&#8221;;<BR>$db-&gt;Execute($query);<\/P><br \/>\n<P>\/\/ \uc624\ub958\uac00 \uc788\ub2e4\uba74 \ucd9c\ub825<BR>$db-&gt;ShowError();<\/P><br \/>\n<P>\/\/ \ub808\ucf54\ub4dc \ucd1d\ud569<BR>echo &#8220;\ub808\ucf54\ub4dc \ud569\uacc4 : &#8220;;<BR>echo $db-&gt;RecordCount();<BR>echo &#8220;&lt;br&gt;&lt;br&gt;&#8221;;<\/P><br \/>\n<P>\/\/ \ub808\ucf54\ub4dc\ub97c \uac00\uc838\uc640\uc11c \ucd9c\ub825<BR>do {<BR>&nbsp; &nbsp; echo $db-&gt;Field(&#8220;s_hp&#8221;);<BR>&nbsp; &nbsp; &nbsp; &nbsp; echo&#8221; &#8211; &#8220;;<BR>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo $db-&gt;Field(&#8220;s_title&#8221;);<BR>&nbsp; &nbsp; echo &#8220;&lt;br&gt;&#8221;;<BR>} while($db-&gt;MoveNext());<\/P><br \/>\n<P>echo&#8221;&lt;br&gt;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;&lt;br&gt;&#8221;;<BR>if(!$_GET[page] || $_GET[page]==&#8221;) &nbsp;&nbsp; $_GET[page]=1;<\/P><br \/>\n<P>$result=$db-&gt;doQuery(&#8220;SELECT * FROM p_board ORDER BY i_seq DESC&#8221;);<BR>while($row=$db-&gt;doList(10,$_GET[page]) )<BR>{<BR>&nbsp; &nbsp; echo&#8221;$row[i_seq] &#8211; $row[s_title]&lt;br&gt;&#8221;;<BR>&nbsp;}<\/P><br \/>\n<P>$pageIndex=$db-&gt;getPageIndex(10,$_GET[page]);<\/P><br \/>\n<P>echo $pageIndex[htmlCode];<BR>$db-&gt;Close();<BR>[\/code]<\/P><br \/>\n<P>\uacb0\uacfc&gt;&gt;<\/P><br \/>\n<P>\ub808\ucf54\ub4dc \ud569\uacc4 : 10<\/P><br \/>\n<P>jptokyo &#8211; \ud559\uc6d0\ub9e4\ub9e4\ud569\ub2c8\ub2e4.\uc57c\ucc21 12\ub9cc\uc5d4<BR>jptokyo &#8211; \uce74\ub098\uba54\ucd781R ,\uc57c\ucc21 6\ub9cc2\ucc9c\uc5d4<BR>jptokyo &#8211; \uc774\ud0c0\ubc14\uc2dc\uad6c \ub098\uce74\ub9c8\ub8e8\ucd781K<BR>jptokyo &#8211; \uc774\ucf00\ubd80\ud06c\ub85c 1R,\uc57c\ucc21 5\ub9cc8\ucc9c\uc5d4<BR>jptokyo &#8211; \uc624\uc624\uce20\uce741K,\uc57c\ucc21 8\ub9cc6\ucc9c\uc5d4<BR>jptokyo &#8211; \uc544\uc0ac\ud788\uac00\uc624\uce74<BR>jptokyo &#8211; \uc544\ub77c\uce74\uc640\ucfe0 \uc624\uad6c2DK<BR>cnhunchun &#8211; \ub3d9\ubd81\ubc94-\ub9c8\uc744 \uc18c \uc7a1\uc544\uba39\ub2e4.<BR>cnhunchun &#8211; \ud6c8\ucd98-\uc554\ud1d8\uc9c0 \ubcf4\ud5d8\uc5d0 \ub4e4\ub2e4<BR>jptokyo &#8211; \u65e5, 2007\ub144 \ud788\ud2b8\uc0c1\ud488 \uc18d\uc5d0 \uc228\uc740 \ud0a4\uc6cc\ub4dc<\/P><br \/>\n<P>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<BR>18673 &#8211; \ud559\uc6d0\ub9e4\ub9e4\ud569\ub2c8\ub2e4.\uc57c\ucc21 12\ub9cc\uc5d4<BR>18672 &#8211; \uce74\ub098\uba54\ucd781R ,\uc57c\ucc21 6\ub9cc2\ucc9c\uc5d4<BR>18671 &#8211; \uc774\ud0c0\ubc14\uc2dc\uad6c \ub098\uce74\ub9c8\ub8e8\ucd781K<BR>18670 &#8211; \uc774\ucf00\ubd80\ud06c\ub85c 1R,\uc57c\ucc21 5\ub9cc8\ucc9c\uc5d4<BR>18669 &#8211; \uc624\uc624\uce20\uce741K,\uc57c\ucc21 8\ub9cc6\ucc9c\uc5d4<BR>18668 &#8211; \uc544\uc0ac\ud788\uac00\uc624\uce74<BR>18667 &#8211; \uc544\ub77c\uce74\uc640\ucfe0 \uc624\uad6c2DK<BR>18666 &#8211; \ub3d9\ubd81\ubc94-\ub9c8\uc744 \uc18c \uc7a1\uc544\uba39\ub2e4.<BR>18665 &#8211; \ud6c8\ucd98-\uc554\ud1d8\uc9c0 \ubcf4\ud5d8\uc5d0 \ub4e4\ub2e4<BR>18664 &#8211; \u65e5, 2007\ub144 \ud788\ud2b8\uc0c1\ud488 \uc18d\uc5d0 \uc228\uc740 \ud0a4\uc6cc\ub4dc<BR>1 2 3 4 <BR><\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>20\uc5ec\uac1c\uc758 mysql \uad00\ub828 \ud074\ub798\uc2a4\uc911\uc5d0\uc11c \ud544\uc694\ud55c \uac83\ub9cc \ubaa8\uc544\uc11c \uc9dc\uc9d1\uae30\ud55c \ud074\ub798\uc2a4&#8230;\uc77c\ubc18\uc801\uc778 mysql \ud074\ub798\uc2a4\uc5d0 \ub9ac\uc2a4\ud2b8\uc640 \ud398\uc774\uc9d5\uae4c\uc9c0 \ud55c\ubc88\uc5d0 \ucc98\ub9ac\ud558\ub294 \ud568\uc218\uc640 xml\ub85c \uacb0\uacfc\ub97c \ucd9c\ub825\ud558\ub294\ud568\uc218 \ucd94\uac00. \ud074\ub798\uc2a4\ub0b4\uc6a9 &gt;&gt; [code]\/\/DB\ud074\ub798\uc2a4class dbH {&nbsp; &nbsp; \/\/ PRIVATE \ubcc0\uc218&nbsp; &nbsp; private &nbsp;&nbsp; $CONN; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; \/\/ DB \ucee4\ub125\ud2b8&nbsp; &nbsp; private &nbsp;&nbsp; $ERR_QUERY; &nbsp;&nbsp; \/\/ \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud55c \ucffc\ub9ac&nbsp; &nbsp; private &nbsp;&nbsp; [&hellip;]<\/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":[99,100,101,102],"class_list":["post-1723","post","type-post","status-publish","format-standard","hentry","category-papa-php","tag-db-connect","tag-mysql-class","tag-101","tag-102"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1723","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=1723"}],"version-history":[{"count":0,"href":"https:\/\/jblove.net\/index.php?rest_route=\/wp\/v2\/posts\/1723\/revisions"}],"wp:attachment":[{"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1723"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1723"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jblove.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1723"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}