PHP Database Configuration

Installation and connection
1. Install Instantclient_12_1 2. Open the Extension=php_oci8 extension in php.ini. Extension=php_oci8 becomes extension=php_oci8 3. php/ The Php_oci8.dll file in the Ext directory is copied to the System32 directory.
4. Set environment variables (such as Web page hint error, delete nls_lang environment variable attempt)
5. Restart the service
6.php Connection Code
$dbconn = Oci_connect (' jlz2014 ', ' jlz2014 ', "(Description= (address= (protocol=tcp) (host= 192.168.xx.xx) (port=1521)) ( Connect_data= (sid=ora100)));
if ($dbconn) {
echo ' success ';
}else {
echo ' ERROR ';
}

Database configuration file

Add primary Key

CREATE SEQUENCE uicbl_sequence

INCREMENT by 1

START with 1

Nomaxvalue

Nocycle

CACHE 10;

CREATE TRIGGER Uicbl_trigger before

Insert on Userid_conf_block_log for each ROW

Begin

Select Uicbl_sequence.nextval Into:New.ID from dual;

End

PHP Database Configuration