IntroductionNow a day, many PHP applications have been developed keeping Oracle as database instead of MySQL and it’s a very common problem for those, using Oracle 11g in Windows 7 (64-bit) with PHP applications that the connection of Oracle database has been refused to connect. Here I have used Instant Client to connect Oracle database with my PHP application. Instead of using separate installation of PHP and Apache, I have used here WAMP server. Just follow the step-by-step to connect Oracle database with PHP applications on the platform of Windows 7 (64-bit). Step-by-StepSTEP 1. Install WAMP server and Oracle 11g at first. STEP 2. For Windows 7 (64-bit), extract instantclient-basic-windows.x64-11.2.0.3.0.zip, downloaded fromhttp://www.oracle.com/technetwork/topics/winx64soft-089540.html toC:WindowsSysWOW64instantclient_11_2 and set it on PATH variable for Environment variable.
STEP 3. Reboot the system now. STEP 4. Allow PHP extension from php.ini as extension=php_oci8_11g.dll (just remove the ";" from the start of the line) STEP 5. Restart WAMP server. STEP 6. Open the file to see the database name asD:appFarhanproduct11.2.0dbhome_1NETWORKADMINtnsnames.ora
Hide Copy Code
LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.168.1.2) ) ) Here, the service name is found as "orcl.168.1.2" . STEP 7. Make the connection in PHP script as oci_connect(your_username, your_password, "localhost/orcl.168.1.2"); |
2006-2014 IT0355.com 山西中聯(lián)科創(chuàng)科技有限公司. All Rights Reserved.
電話:0355-3728808 傳真:0355-3728808
ICP備案號:晉ICP備06003721號本站已通過國際W3C認證
關(guān)鍵字:中聯(lián)科創(chuàng),長治網(wǎng)站建設(shè),長治網(wǎng)站推廣,長治網(wǎng)絡(luò)工程,長治軟件開發(fā),山西網(wǎng)站建設(shè),山西軟件開發(fā) 長治五金網(wǎng)