Configure your own WAMP environment, extend the oracle function library (oci), wampoci_PHP tutorial

WAMP environment configured by myself, extended oracle function library (oci), wampoci

A colleague received a task yesterday to use php to process the content of the oracle database, but php opened oracle The extension cannot be used directly like mysql. It requires something to open

The first step is to download an install client package from Oracle official, and find your zip corresponding to the system version under win (note here is the system version)

As of 2015-06-25, the download address is as follows http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

For example, choose Instant Client for Microsoft Windows (x64). Because PHP extends OCI, you must choose the most complete corresponding version. Others do not have OCI. You may need an account to download here. You can download after verification. , it is not easy to download directly through the link. If not, just register it

In the second part, you need to download the expansion package in the win system, which is the .dll file. Download address http://pecl.php.net/package/oci8 The following nonsense will tell you how to find it

http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html Click on this address

official Instant Client site. Scroll to the end and click "PHP - OCI8 extension" in Related Developer Centers

Then tab downloads Click OCI8 to http://pecl.php.net/package/oci8

Then I won’t say much about how to download it

Go here to download the two zip packages, and then configure PHP

Third, decompress the first downloaded file to any directory on your computer. After decompression, you will get the file directory instantclient_12 _1. It is recommended to remove the "_12_1" at the end, so that you don't need to change the environment variables when changing the version in the future

Enter this directory and double-click to open adrci.exe

Get the following command line window to prove that this client is available locally

Copy the directory, mine is F:devinstantclient and configure it to the system’s path environment variable,

Fourth, unzip the downloaded dll compressed package and copy the php_oci8.dll php_oci8_11g.dll php_oci8_12c.dll. I currently have these three, to the php expansion package file, usually.../php /ext/ directory

In fact, you don’t need to replace it, but it is recommended to replace it,

Then open php.ini and open the extension. The last one was added later. PHP does not have it originally. Anyway, all the dll files in the package above have been written in. At most, a few more libraries can be loaded when running PHP.

extension=php_pdo_oci.dll

extension=php_oci8.dll ; Use with Oracle 10gR2 Instant Client
extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client
extension=php_oci8_12c.dll ; Use with Oracle 12c Instant Client

Then restart the httpd service and open phpinfo(); you should be able to see

This means that the extension is opened successfully

The last step is to connect to the oracle database

Here is an example link. Original link http://www.orczhou.com/index.php/2010/09/php-oci8-oracle/

<span> 1</span> <?<span>php  
</span><span> 2</span> <span>//</span><span>配置信息</span>
<span> 3</span> <span>$ora_host</span> = "172.16.1.150"<span>;
</span><span> 4</span> <span>$ora_port</span>="1521"<span>;
</span><span> 5</span> <span>$ora_sid</span> = "cop"<span>;
</span><span> 6</span> <span>$ora_username</span> = "webdev"<span>;
</span><span> 7</span> <span>$ora_password</span> = "webdev"<span>;
</span><span> 8</span> <span>$charset</span> = "UTF8"; <span>#</span><span>## zhs16gbk ###
</span><span> 9</span> 
<span>10</span> <span>//构建Easy Connect string
</span><span>11</span> <span>//（如果tnsnames.ora中已经有了，可以直接使用Connect Name）</span>
<span>12</span> <span>$ora_connstr</span> = "<span>(description=(address=(protocol=tcp)
</span><span>13</span> (host=".<span>$ora_host</span>.")(port=".<span>$ora_port</span>."<span>))
</span><span>14</span> (connect_data=(service_name=".<span>$ora_sid</span>.")))"<span>;
</span><span>15</span> <span>//</span><span>连接数据库</span>
<span>16</span> <span>$conn</span> = oci_connect(<span>$ora_username</span>, <span>$ora_password</span>,<span>$ora_connstr</span><span>);
</span><span>17</span> <span>//</span><span>执行Query,这里$res接收的是一个boolean值</span>
<span>18</span> <span>$stid</span> = oci_parse(<span>$conn</span>, 'select * FROM dq_try_app'<span>);
</span><span>19</span> <span>$res</span> = oci_execute(<span>$stid</span><span>);
</span><span>20</span> 
<span>21</span> <span>//</span><span>在while循环中使用oci_fetch_array遍历结果。</span>
<span>22</span> <span>while</span> (<span>$row</span> = oci_fetch_array(<span>$stid</span>, OCI_ASSOC+<span>OCI_RETURN_NULLS)) {
</span><span>23</span>     
<span>24</span>     <span>foreach</span> (<span>$row</span> <span>as</span> <span>$item</span><span>) {
</span><span>25</span>         <span>echo</span> <span>$item</span>."***"<span>;
</span><span>26</span> <span>    }
</span><span>27</span>     <span>echo</span> "<br>"<span>;
</span><span>28</span>     
<span>29</span> <span>}
</span><span>30</span> <span>//</span><span>var_dump($stid);   </span>
<span>31</span> ?>

At this point, the entire extension and connection is completed