自己配置的WAMP环境,扩展oracle函数库(oci)，wampoci_PHP教程

<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> ?>