{"id":193,"date":"2016-02-20T10:25:02","date_gmt":"2016-02-20T01:25:02","guid":{"rendered":"http:\/\/curry.azen.co.kr\/?p=193"},"modified":"2016-02-20T10:33:46","modified_gmt":"2016-02-20T01:33:46","slug":"%ec%9c%88%eb%8f%84%ec%9a%b0%ec%97%90%ec%84%9c-apache-php-oracle-%ec%97%b0%eb%8f%99%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/curry.azen.co.kr\/?p=193","title":{"rendered":"\uc708\ub3c4\uc6b0\uc5d0\uc11c Apache + PHP + Oracle \uc5f0\ub3d9\ud558\uae30"},"content":{"rendered":"

1. HTTP \uc124\uce58<\/p>\n

http:\/\/www.apachelounge.com\/download\/<\/a><\/p>\n

32\/64\ube44\ud2b8\uc5d0 \ub9de\ucdb0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0<\/p>\n

\uc704 \ud398\uc774\uc9c0 \uc911\uac04 \ucbe4\uc5d0 \uc788\ub294 Visual Studio \uad00\ub828 \ub9c1\ud06c \ud654\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc0f \uc124\uce58 \ud569\ub2c8\ub2e4.<\/p>\n

https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=49984<\/a><\/p>\n

Visual Studio \uad00\ub828\ud654\uc77c\uc740 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544\uc11c \uc2e4\ud589\ud558\uba74 \uadf8\ub300\ub85c \uc708\ub3c4\uc6b0\uc5d0 \uc124\uce58\uac00 \ub418\uba70,<\/p>\n

\uc544\ud30c\uce58 \ud654\uc77c\uc740 \ub2e4\uc6b4\ub85c\ub4dc \ud6c4 \uc555\ucd95\uc744 \ud480\uc5b4 \uc801\ub2f9\ud55c \uc704\uce58\uc5d0 \uc62e\uaca8\ub461\ub2c8\ub2e4.<\/p>\n

\uc800\ub294 C:\\Apache24 \ub85c \uc9c0\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4.<\/p>\n

\uace0\uae09\uc124\uc815 \ud658\uacbd\ubcc0\uc218\uc5d0\uc11c \uc2dc\uc2a4\ud15c \ud658\uacbd\ubcc0\uc218 \uc911 PATH \uc5d0 C:\\Apache24\\bin \uc744 \ucd94\uac00\ud574\uc8fc\uace0,<\/p>\n

\ucee4\ub9e8\ub4dc \ucc3d\uc5d0\uc11c<\/p>\n

– \uc11c\ube44\uc2a4 \ub4f1\ub85d<\/p>\n

> httpd -k install<\/p>\n

– \uc11c\ube44\uc2a4 \uc2e4\ud589<\/p>\n

> httpd -k start<\/p>\n

\ud55c \ud6c4 \ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c localhost \ub77c\uace0 \uce58\uba74 \ud648\ud398\uc774\uc9c0\uac00 \ub098\uc624\ub294 \uac83\uc744 \ud655\uc778\ud558\uc2e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\ucc38\uace0\ub85c<\/p>\n

– \uc11c\ube44\uc2a4 \uc885\ub8cc<\/p>\n

> httpd -k stop<\/p>\n

– \uc11c\ube44\uc2a4 \uc81c\uac70<\/p>\n

> httpd -k uninstall<\/p>\n

\n

\n

2. PHP \uc124\uce58<\/p>\n

http:\/\/windows.php.net\/download\/<\/a><\/p>\n

Thread \ubc84\uc804 \ub2e4\uc6b4\ubc1b\uae30<\/p>\n

\ub9c8\ucc2c\uac00\uc9c0\ub85c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \ud654\uc77c \uc555\ucd95\uc744 \ud480\uc5b4\uc900 \ud6c4 \uc801\ub2f9\ud55c \uacf3\uc5d0 \uc62e\uaca8\ub461\ub2c8\ub2e4.<\/p>\n

\uc800\ub294 \uc5ec\ub7ec \ud3f4\ub354 \ub9cc\ub4e4\uae30\uac00 \uadc0\ucc2e\uc544\uc11c<\/p>\n

C:\\Apache24\\php56<\/p>\n

\uc774\ub77c\uace0 \ub9cc\ub4e4\uc5b4 \uc62e\uaca8 \ub450\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

php \ud3f4\ub354 \ub0b4\uc5d0 \uc788\ub294 php.ini-production \ud654\uc77c\uc744 php.ini\ub85c \ubc14\uafd4\uc11c Windows \ud3f4\ub354\uc5d0 \uc62e\uaca8 \uc90d\ub2c8\ub2e4.<\/p>\n

\uc774 \ud6c4 \uc544\ub798 \ubd80\ubd84\ub4e4\uc744 \uc218\uc815\ud574 \uc90d\ub2c8\ub2e4.<\/p>\n

display_errors = On<\/p>\n

extension_dir = “C:\\Apache24\\php56\\ext”<\/p>\n

date.timezone = Asia\/Seoul<\/p>\n

extension=php_oci8_12c.dll\u00a0 <\/span>; Use with Oracle Database 12c Instant Client<\/p>\n

\ub610\ud55c httpd.conf \ub3c4 \uc218\uc815\ud569\ub2c8\ub2e4.<\/p>\n

LoadModule php5_module \u201cc:\/Apache24\/php56\/php5apache2_4.dll\u201d
\nAddHandler application\/x-httpd-php .php<\/p>\n

# configure the path to php.ini
\nPHPIniDir \u201cC:\/Windows\u201d<\/p>\n

<FilesMatch \\.php$>
\nSetHandler application\/x-httpd-php
\n<\/FilesMatch><\/p>\n

\uc774 \ud6c4 \uc544\ud30c\uce58 \uc7ac\uc2dc\uc791\ud574\uc11c php\uac00 \uc81c\ub300\ub85c \uc791\ub3d9\ud558\ub294\uc9c0 \ud655\uc778 \ubc14\ub78d\ub2c8\ub2e4.<\/p>\n

\n

\n

3. Oracle InstantClient<\/p>\n

http:\/\/www.oracle.com\/technetwork\/database\/features\/instant-client\/index-097480.html<\/a><\/p>\n

\uc624\ub77c\ud074 instant Client basic \uacfc SQL*Plus \ud654\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544\uc11c \uc555\ucd95\uc744 \ud47c \ud6c4<\/p>\n

\uac19\uc740 \ud3f4\ub354\uc5d0 \ubab0\uc544 \ub461\ub2c8\ub2e4.<\/p>\n

\uc5ed\uc2dc \uadc0\ucc2e\uc740 \uad00\uacc4\ub85c C:\\Apache24\\instantclient_12_1 \uc774\ub77c\ub294 \uacf3\uc5d0 \ubab0\uc544 \ub123\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

\uadf8 \ub2e4\uc74c\uc73c\ub85c \uc5ec\uae30 \ud3f4\ub354\uc5d0 \uc788\ub294 \ud654\uc77c \uc911 \u201co\u201d\ub85c \uc2dc\uc791\ud558\ub294 dll \ud654\uc77c\ub4e4\uc744 \uc800\ub294 \uadc0\ucc2e\uc544\uc11c \ubaa8\ub450\ub97c<\/p>\n

C:\\Apache24\\bin \ud3f4\ub354\uc5d0 \ubab0\uc544 \ub123\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774 \ud6c4 \uace0\uae09\uc124\uc815 \ud658\uacbd\ubcc0\uc218\uc5d0\uc11c \uc2dc\uc2a4\ud15c \ud658\uacbd\ubcc0\uc218 \uc911<\/p>\n

PATH \uc5d0 C:\\Apache24\\instantclient_12_1<\/p>\n

ORACLE_HOME \uc5d0 C:\\Apache24\\instantclient_12_1<\/p>\n

TNS_ADMIN \uc5d0 C:\\Apache24\\instantclient_12_1<\/p>\n

\uc744 \ucd94\uac00\ud574\uc8fc\uace0,<\/p>\n

\ucee4\ub9e8\ub4dc \ucc3d\uc5d0\uc11c<\/p>\n

> sqlplus user\/pass@192.168.1.2<\/span><\/a>\/orcl <\/span><\/p>\n

\ub85c \uc811\uc18d\uc774 \ub418\ub294\uc9c0 \ud655\uc778\ud569\ub2c8\ub2e4.<\/p>\n

\ubb3c\ub860 \uc704\uc640 \uac19\uc740 \uc624\ub77c\ud074 \uc11c\ubc84\uac00 \uc798 \ub3cc\uc544\uac00\uace0 \uc788\ub2e4\ub294 \uc804\uc81c\ud558\uc5d0\uc11c \uc785\ub2c8\ub2e4.<\/p>\n

\uc811\uc18d\uc774 \ub41c\ub2e4\uba74\u2026..<\/p>\n

\n

\n

4. \uc124\uc815 \uc7a1\uae30<\/p>\n

\uc544\ud30c\uce58\ub97c \uc7ac\uc2dc\uc791\ud574\ubcf4\uace0<\/p>\n

phpinfo(); \ub97c \ud574\uc11c OCI8 \uc774 \ub098\uc624\ub294\uc9c0 \ud655\uc778 \ud574\ubcf4\uace0<\/p>\n

\uc5ec\uae30\uc11c \uc548 \ub098\uc624\uba74 \ub300\ub7b5 \ub09c\uac10.. (\uc800\ub3c4 \uc774 \ubd80\ubd84\uc5d0\uc11c \ub9cc \ud558\ub8e8\ub97c \ud5e4\ub9f8\uc2b5\ub2c8\ub2e4.)<\/p>\n

\n

\n

5. \ud14c\uc2a4\ud2b8\ud574\ubcf4\uae30<\/p>\n

<?php\r\n\r\n$conn = oci_connect(\u201cUSER\u201d, \u201cPASS\u201d, \"192.168.1.2:1521\/orcl\");\r\n\r\nif (!$conn) {\r\n\r\n$m = oci_error();\r\n\r\necho $m['message'], \"\\n\";\r\n\r\nexit;\r\n\r\n}\r\n\r\nelse {\r\n\r\necho \"Connected to Oracle!\";\r\n\r\n}\r\n\r\n\/* multi rows *\/\r\n\r\n$query = \"SELECT COLUMN1,COLUMN2 FROM TABLENAME\u201d;\r\n\r\n$stid = oci_parse($conn, $query);\r\n\r\noci_execute($stid);\r\n\r\nwhile (($row = oci_fetch_array($stid, OCI_BOTH))) {\r\n\r\necho $row[0] . \" : \" . $row[1] . \"<br>\";\r\n\r\n}\r\n\r\necho \"Total Count : \" . oci_num_rows($stid);\r\n\r\noci_free_statement($stid);\r\n\r\noci_close($conn);\r\n\r\n?>\r\n<\/pre>\n
\uc798 \ub098\uc628\ub2e4\uba74 \uc131\uacf5\ud55c \uac81\ub2c8\ub2e4. \ucd95\ud558\ud569\ub2c8\ub2e4. \u3160\u3160<\/p>\n","protected":false},"excerpt":{"rendered":"
1. HTTP \uc124\uce58 http:\/\/www.apachelounge.com\/download\/ 32\/64\ube44\ud2b8\uc5d0 \ub9de\ucdb0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uace0 \uc704 \ud398\uc774\uc9c0 \uc911\uac04 \ucbe4\uc5d0 \uc788\ub294 Visual Studio \uad00\ub828 \ub9c1\ud06c \ud654\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ubc0f \uc124\uce58 \ud569\ub2c8\ub2e4. https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=49984 Visual Studio \uad00\ub828\ud654\uc77c\uc740 \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc544\uc11c \uc2e4\ud589\ud558\uba74 \uadf8\ub300\ub85c \uc708\ub3c4\uc6b0\uc5d0 \uc124\uce58\uac00 \ub418\uba70, \uc544\ud30c\uce58 \ud654\uc77c\uc740 \ub2e4\uc6b4\ub85c\ub4dc \ud6c4 \uc555\ucd95\uc744 \ud480\uc5b4 \uc801\ub2f9\ud55c \uc704\uce58\uc5d0 \uc62e\uaca8\ub461\ub2c8\ub2e4. \uc800\ub294 C:\\Apache24 \ub85c \uc9c0\uc815\ud558\uc600\uc2b5\ub2c8\ub2e4. \uace0\uae09\uc124\uc815 \ud658\uacbd\ubcc0\uc218\uc5d0\uc11c \uc2dc\uc2a4\ud15c \ud658\uacbd\ubcc0\uc218 \uc911 PATH \uc5d0 C:\\Apache24\\bin \uc744 \ucd94\uac00\ud574\uc8fc\uace0, … <\/p>\n
Continue reading “\uc708\ub3c4\uc6b0\uc5d0\uc11c Apache + PHP + Oracle \uc5f0\ub3d9\ud558\uae30”<\/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":[],"tags":[],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=193"}],"version-history":[{"count":5,"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/193\/revisions"}],"predecessor-version":[{"id":198,"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/193\/revisions\/198"}],"wp:attachment":[{"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=193"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/curry.azen.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}