Access Oracle815 with PHP4

Access Oracle (large website database platform) 815 & nbsp; system environment: & nbsp; 1. Operating system: Windows2000Server2, database: Oracle (large website database platform) 8iR2 (8.1.6) for using php on ipvsws 2000 Server (as the mainstream development language) 4. access Oracle (large website database platform) 815

System environment:
1. Operating system: Windows 2000 Server
2. Database: Oracle (large website database platform) 8i R2 (8.1.6) for NT Enterprise Edition
3. Installation Path: D: Oracle (large website database platform)

Install and configure php (as the mainstream development language) 4:
Step 1: Open the php (the current development language plug-in -4.0.3-win32.zip) and place it under C: php (as the current mainstream development language.

Step 2: Use the php below C: php (as the current mainstream development language) as the current mainstream development language ). copy the ini-optimized file to the C: WINNT directory and change it to php (as the mainstream development language ). ini.

Modify php (as the mainstream development language). ini file:
Extension_dir = c: php (as the mainstream development language)

Extension = php (as the mainstream development language) _ oci8.dll remove the previous ";"

Extension = php (as the mainstream development language) _ Oracle (large website database platform). dll remove the previous ";"

[Browscap] browscap = c: php (as the current mainstream development language) browscapbrowscap. ini remove the ";" sign before the browscap item

Step 3: Copy C: php (as the mainstream development language) 4ts. dll to the C: WINNTsystem32 directory.

Step 4: Start the iis (Microsoft WEB server platform) management program.

Choose "start"> "settings"> "control panel"> "administrative tools"> "Internet service manager", right-click "default Web site", and select Properties,
The "default Web site properties" window is displayed:

Enter c: PHP for the application name (for the current development language development PHP) (for the current development language development .exe % s) and click configure:
Click Add:

Step 5: Click "ISAPI filter" in the "default Web site properties" window and click "add,

In the pop-up "filter properties" window, enter "php (as the mainstream development language)" in "filter name )",

Enter "C: php (as the current mainstream development language) sapiphp (as the current mainstream development language) 4isapi. dll" in the "executable file" to confirm.



Step 6, REGEDIT, start registry editor to find:

HKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesW3SVCParametersScript Map.

Create a new string: Enter the name. php (as the current mainstream development language)



Step 7: return to the command line window and enter the "net stop iis (Microsoft WEB server platform) admin" command to terminate the iis (Microsoft WEB server platform) service.

The system will ask you if you want to stop the related services. A: Yes.

Step 8: Enter the "net start w3svc" command to restart the iis (Microsoft WEB server platform) service.

Step 9: use c: php (as the current mainstream development language) in the extensions php (as the current mainstream development language) _ oci8.dll, php (as the current mainstream development language) _ Oracle (large website database platform ). dll files are copied to c: php (as the mainstream development language ).

1. write the first code to connect to Oracle (a large-scale website database platform), test. php (as the mainstream development language)

$ Handle = ora_plogon ("test @ ora815", "gdj") or die;/* create a handle connecting to Oracle (large website database platform */
$ Cursor = ora_open ($ handle);/* open it and assign it to a cursor */
Ora_commitoff ($ handle );

$ Query = "SELECT * FROM rate";/* define a query */
Ora_parse ($ cursor, $ query) or die;/* assign this query to the cursor */