{"id":1356,"date":"2003-08-11T16:41:49","date_gmt":"2003-08-11T16:41:49","guid":{"rendered":"http:\/\/bluesoul.pe.kr\/wp\/?p=1356"},"modified":"2003-08-11T16:41:49","modified_gmt":"2003-08-11T16:41:49","slug":"php%ed%81%b4%eb%9e%98%ec%8a%a4-%eb%a7%8c%eb%93%a4%ec%96%b4-%ec%93%b0%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/bluesoul.pe.kr\/wp\/?p=1356","title":{"rendered":"[PHP]\ud074\ub798\uc2a4 \ub9cc\ub4e4\uc5b4 \uc4f0\uae30"},"content":{"rendered":"

php\ub3c4 \ud074\ub798\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 \uc4f8\uc218 \uc788\ub2e4. \ub2e4\ub4e4 \uc54c\uaca0\uc9c0\ub9cc
\n\ubcf4\ud1b5 \ub9c8\ub2c8 \uc4f0\uc774\ub294 \ud568\uc218\ub4e4\uc744 \ud074\ub798\uc2a4\ub85c \ub9cc\ub4e4\uc5b4 \ud544\uc694\ud560\ub54c \ub9c8\ub2e4 \ubd88\ub7ec\uc4f0\uba74 \ud3b8\ub9ac\ud558\ub2e4.
\n\ub514\ube44\uad00\ub828\ub41c\uac70\ub098 \ud398\uc774\uc9d5 \uad00\ub828 \ud568\uc218\ub4e4\uc744 \ub9c8\ub2c8\ub4e4 \ud074\ub798\uc2a4\ub85c \ub9cc\ub4e4\uc5b4 \uc4f4\ub2e4.<\/p>\n

\ub514\ube44 \uad00\ub828 \ud074\ub798\uc2a4\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uc790.
\nphp\uc2a4\ucfe8\uc5d0 \ub098\uc640 \uc788\ub294\uac83\ub4e4\uc744 \ucc38\uc870\ud588\ub294\ub370..
\n\ud5c8\uc811\ud568\uc744 \ubbf8\ub9ac \uace0\ubc31\ud55c\ub2e4. \ub098\uc5d0\uac8c \ud544\uc694\ud55c \uae30\ub2a5\ub9cc\uc744 \ub9cc\ub4e4\uc5c8\uae30 \ub54c\ubb38\uc774\uace0..
\n\uc544\uc9c1 \uac80\uc99d\uc774 \uc548\ub42c\uae30 \ub54c\ubb38\uc774\ub2e4..
\n\ubd80\ub514 \ucc38\uc870\ub9cc \ud558\uae30 \ubc14\ub780\ub2e4.<\/p>\n

dbclass.inc
\nHost = $Host;
\n $this->UserName = $UserName;
\n $this->Password = $Password;
\n $this->DatabaseName = $DatabaseName;
\n }<\/p>\n

\/\/\ub514\ube44 \uc5f0\uacb0
\n function Connect(){
\n $this->Conn = mysql_connect($this->Host,$this->UserName,$this->Password);<\/p>\n

if(!$this->Conn){
\n $this->halt(“Host\ub97c \uc5f0\uacb0\ud560 \uc218\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.”);
\n }else{<\/p>\n

if( !mysql_select_db($this->DatabaseName,$this->Conn) ){<\/p>\n

$this->halt(“DB\ub97c \uc5f0\uacb0\ud560 \uc218\uac00 \uc5c6\uc2b5\ub2c8\ub2e4.”);
\n }
\n }
\n }<\/p>\n

\/\/\ucffc\ub9ac\ubb38\uc744 \uc774\uc6a9\ud558\uc5ec resultset \uac12\uc744 \ub9cc\ub4e0\ub2e4.
\n function Query($qry){<\/p>\n

$this->Res = mysql_query($qry,$this->Conn);
\n if(!$this->Res){
\n $this->halt(“\ucffc\ub9ac\ubb38\uc81c => $qry”);
\n }<\/p>\n

return $this->Res;<\/p>\n

}<\/p>\n

\/\/resultset \uac12\uc744 \uc774\uc6a9\ud558\uc5ec \uc2e4\uc81c \ub370\uc774\ud130 \uac12\uc744 \ubc30\uc5f4\ub85c \ub9ac\ud134\ud55c\ub2e4.
\n function Row($res){<\/p>\n

$this->Row = mysql_fetch_row($res);
\n return $this->Row;
\n }<\/p>\n

\/\/resultset\uc744 \ub9cc\ub4e4\uba74\uc11c \uc0dd\uc131\ub41c \uba54\ubaa8\ub9ac\ub97c \ud574\uc81c\ud55c\ub2e4.
\n \/\/@\ub294 \uc5d0\ub7ec\uac00 \ub098\ub3c4 \ub118\uae34\ub2e4.
\n function FreeResult(){
\n @mysql_free_result($this->Res);<\/p>\n

}<\/p>\n

\/\/\ub514\ube44\uc5f0\uacb0\uc744 \ud574\uc81c\ud55c\ub2e4.
\n function Disconnect(){<\/p>\n

@mysql_close($this->Conn);<\/p>\n

\/\/\uba54\ubaa8\ub9ac\uc5d0\uc11c \ubcc0\uc218\ub4e4\uc744 \ud574\uc81c\ud55c\ub2e4.
\n unset($this->Conn);
\n unset($this->Host);
\n unset($this->UserName);
\n unset($this->Password);
\n unset($this->DatabaseName);
\n unset($this->Res);
\n unset($this->Row); <\/p>\n

}<\/p>\n

\/\/ \uc5d0\ub7ec\uba54\uc2dc\uc9c0 \ucd9c\ub825\ud568\uc218
\n function halt($massage){<\/p>\n

$this -> Errno = mysql_errno();
\n $this -> Error = mysql_error();<\/p>\n

echo “Oops~!! Database Error<\/font> : $massage <\/p>\n

” ;
\n echo “$this->Errno ($this->Error) <\/p>\n

“;
\n die (‘process halted’);
\n }<\/p>\n

\/\/filed\uc5d0 \ub530\ub978 \ucd5c\ub300\uac12\uc744 \uad6c\ud55c\ub2e4.
\n function MaxNum($fld,$tbn){<\/p>\n

$qry = “select max($fld) from $tbn”;
\n $res=$this->Query($qry);
\n $this->Row($res);<\/p>\n

if($this->Row[0]){
\n $maxnum = $this->Row[0]+1;
\n }else{
\n $maxnum = 1;
\n }<\/p>\n

$this->FreeResult();<\/p>\n

return $maxnum;
\n }<\/p>\n

\/\/\uc870\uac74\uc5d0 \ub530\ub978 \uce74\uc6b4\ud2b8\ub97c \ud55c\ub2e4.
\n function Count($fld,$tbn,$where){
\n $qry = “select count($fld) from $tbn $where “;
\n $res=$this->Query($qry);
\n $this->Row($res);<\/p>\n

$this->FreeResult();<\/p>\n

return $this->Row[0];<\/p>\n

}<\/p>\n

}
\n?><\/p>\n

\ub2e4\uc74c\uc740 \uc4f0\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud55c\ub2e4.<\/p>\n

Connect();<\/p>\n

\/\/Count\ud568\uc218\ub97c \uc368\uc11c row\uc218\ub97c \uad6c\ud55c\ub2e4.
\n$rows=$mysql->Count(“num”,$tbn,”where num = $num”);<\/p>\n

if($rows>0){
\n $query = “select num,targetdate,enddate,writer,subject,content,texthtml,filename,regdate,hits,ipAddr from $tbn where num=$num”;<\/p>\n

\/\/\ucffc\ub9ac\ubb38\uc73c\ub85c resultset \uc744 \ub9cc\ub4e4\uace0
\n $res = $mysql->Query($query);
\n \/\/\ubc30\uc5f4\uac12\uc744 \ub9ac\ud134\ud55c\ub2e4.
\n $row = $mysql->Row($res);<\/p>\n

\/\/\uac01\uac01\uc758\uacb0\uacfc\uac12\ub4e4\uc744 \uac00\uc838\uc628\ub2e4.
\n $num = $row[0];
\n $targetdate = $row[1];
\n $enddate = $row[2];
\n $writer = $row[3];
\n $subject = $row[4];
\n $content = $row[5];
\n $texthtml = $row[6];
\n $filename = $row[7];
\n $regdate = $row[8];
\n $hits = $row[9];
\n $ipAddr = $row[10];<\/p>\n

\/\/\uba54\ubaa8\ub9ac\uc5d0\uc11c \ud574\uc81c\ud55c\ub2e4.
\n $mysql->FreeResult();<\/p>\n

}<\/p>\n

\/\/\ub514\ube44\uc5f0\uacb0\uc744 \ud574\uc81c\ud55c\ub2e4.
\n$mysql->Disconnect();
\n?> <\/p>\n","protected":false},"excerpt":{"rendered":"

php\ub3c4 \ud074\ub798\uc2a4\ub97c \ub9cc\ub4e4\uc5b4 \uc4f8\uc218 \uc788\ub2e4. \ub2e4\ub4e4 \uc54c\uaca0\uc9c0\ub9cc \ubcf4\ud1b5 \ub9c8\ub2c8 \uc4f0\uc774\ub294 \ud568\uc218\ub4e4\uc744 \ud074\ub798\uc2a4\ub85c \ub9cc\ub4e4\uc5b4 \ud544\uc694\ud560\ub54c \ub9c8\ub2e4 \ubd88\ub7ec\uc4f0\uba74 \ud3b8\ub9ac\ud558\ub2e4. \ub514\ube44\uad00\ub828\ub41c\uac70\ub098 \ud398\uc774\uc9d5 \uad00\ub828 \ud568\uc218\ub4e4\uc744 \ub9c8\ub2c8\ub4e4 \ud074\ub798\uc2a4\ub85c \ub9cc\ub4e4\uc5b4 \uc4f4\ub2e4. \ub514\ube44 \uad00\ub828 \ud074\ub798\uc2a4\ub97c \ub9cc\ub4e4\uc5b4\ubcf4\uc790. php\uc2a4\ucfe8\uc5d0 \ub098\uc640 \uc788\ub294\uac83\ub4e4\uc744 \ucc38\uc870\ud588\ub294\ub370.. \ud5c8\uc811\ud568\uc744 \ubbf8\ub9ac \uace0\ubc31\ud55c\ub2e4. \ub098\uc5d0\uac8c \ud544\uc694\ud55c \uae30\ub2a5\ub9cc\uc744 \ub9cc\ub4e4\uc5c8\uae30 \ub54c\ubb38\uc774\uace0.. \uc544\uc9c1 \uac80\uc99d\uc774 \uc548\ub42c\uae30 \ub54c\ubb38\uc774\ub2e4.. \ubd80\ub514 \ucc38\uc870\ub9cc \ud558\uae30 \ubc14\ub780\ub2e4. dbclass.inc \ub2e4\uc74c\uc740 \uc4f0\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud55c\ub2e4.<\/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-1356","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\/1356","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=1356"}],"version-history":[{"count":0,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=\/wp\/v2\/posts\/1356\/revisions"}],"wp:attachment":[{"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bluesoul.pe.kr\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}