How to solve the garbled problem of php connection to oracle

Solution to garbled php connection to oracle: 1. Set environment variables; 2. Get the character set of oracle; 3. Pass "iconv('GBK','utf-8',$vo["USERNAME" ]);" method to convert the encoding.

The operating environment of this article: Windows 7 system, PHP version 7.1, DELL G3 computer

How to solve the php connection oracle garbled problem?

Notes on PHP connection to Oracle and garbled characters

1. PHP connection to Oracle

Step 1. Extract Oracle Instant Client Core DLL

Download the Instant Client Basic (11g) package for Windows from OTN's Instant Client page. The size of this compressed file is approximately 48MB. Create a subdirectory (for example, c:\instantclient11_2) and copy the following libraries from the compressed file to the apache\bin directory:

oraociei11.dll 
orannzsbb11.dll 
oci.dll

The total size of these three files is approximately 126MB.
To use the "oracle" extension for older versions of PHP (enabled using "extension=php_oracle.dll" in php.ini), copy ociw32.dll instead of oci.dll.

Step 2: Edit the environment variables and add c:\instantclient11_2 to PATH (the system environment variables are located before other Oracle directories).

For example, on Win7, click "Computer"->right-click "Properties"->"Advanced System Settings"->"Advanced"->"Environment Variables" to edit system variables PATH in the list.
If the tnsnames.ora file is used to define the Oracle Net service name, copy tnsnames.ora to c:\instantclient11_2 and set the user environment variable TNS_ADMIN to c:\instantclient11_2.

Step 3: Open the oci8 extension of php. Edit php.ini and open the OCI8 extension, that is, remove the comment symbol ‘;’: extension=php_oci8.dll

Restart Apache. Restart the server (the server must be restarted, otherwise the environment variables will not take effect)

After restarting, if you see the following content through phpinfo(), the configuration is successful:

oci8

putenv("NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1");
$conn=oci_new_connect($config['username'], $config['password'],$config['database']);

 $conn=oci_new_connect($config['username'], $config['password'],$config['database'],'we8iso8859p1');

 echo iconv('GBK','utf-8',$vo["USERNAME"]);