Shulou(Shulou.com)06/02 Report--

This article introduces the knowledge of "how to install and deploy IIS, PHP and Oracle environments". Many people will encounter this dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Catalogue

Installation of 0x01 Oracle

0x02 configure IIS and PHP

0x03 configure PHP extension

There is already a SQL server+PHP-based deployment method in front, so this time we will deploy the Oracle+PHP environment as well.

Installation of 0x01 Oracle

Let's go directly to the official website to download. Here, take Oracle 11g as an example.

Https://www.oracle.com/database/technologies/112010-win64soft.html

Here, download both files and merge the contents of the two compressed packages

If you don't have to enter the mailbox here, we will also remove the received security updates, and then select "Yes" for the specified mailbox.

Then we choose, create and configure the database

Here I choose the server mode, if there are other needs, you can choose the desktop mode, and then directly typical installation

Then set the location, account password and other information by yourself.

Then after a short period of testing, the installation can be completed.

After that, go to the service to check whether the Oracle service already exists, and if so, it proves that the installation has been successful.

There is one more step to be done after the installation is completed. Since your current address is monitored by default after Oracle installation, we will change the address to 127.0.0.1 or localhost for convenience later.

0x02 configure IIS and PHP

I'm not going to expand here. If you don't know, you can check out the previous article, "deploying an IIS+PHP+SQL server Environment."

0x03 configure PHP extension

In the ext directory, we can find that PHP7 does not have an extension of Oracle11g, that is, php_oci_11g, but it has an extension of pdo_oci.

So we need to manually add Oracle11g's PHP extension

First of all, we download Oracle instant Client on the official website according to the system version.

Https://www.oracle.com/database/technologies/instant-client/downloads.html

I chose version 12.2.0.1.0 here.

Then add this directory to the system environment variable

Next we install the php_oci8_11g extension

Http://pecl.php.net/package/oci8

Because PHP7.2 is used, I choose the latest updated dll here and choose 7.2non-thread-safe

Then put php_oci8_11g.dll in the ext directory of PHP and add it to php.ini

Then check in phpinfo to see if the addition is successful.

Finally, let's use a simple example to verify the success.

PS: since I changed the instance name to oracle during installation, oracle is used here, and you can set it according to your own configuration

Successful connection

That's all for "how to install and deploy IIS, PHP, and Oracle environments". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.