On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,629 Users
  • 2,269,769 Discussions
  • 7,916,800 Comments

Discussions

[HELP] problem with oci8 in php

959674
959674 Member Posts: 11
edited Oct 14, 2012 8:36PM in PHP
Hello expert,i have a problem when install oci8.so on ubuntu 12,i'm trying with tutuariol
https://help.ubuntu.com/community/PHPOracle

but when i finished,i was creating a file with content
*<?php*
*$db = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=192.168.1.17)*
*(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=apporcl)*
*(SERVER=DEDICATED)))';*
*$username = 'system';*
*$password = '123456';*
oci_connect($username, $password, $db );

echo 'a';
*?>*
but i don't know why ? althought true or false syntax,it still not show error message,in general,it can't echo result alter i call oci_connect function

OS : Oracle Linux
DB : 11g
Thank

Answers

  • Christopher Jones-Oracle
    Christopher Jones-Oracle Member Posts: 1,657 Employee
    Add some error checking after the connection call. During development, you might consider editing your php.ini file and setting display_errors to on. Also set error_reporting = E_ALL | E_STRICT (in PHP 5.3 or earlier) or the equivalent error_reporting = E_ALL (in PHP 5.4). Also check your Apache error log for any library issues.

    There is some useful information in the free book http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-098250.html
    In particular, check "Handling OCI8 Errors" at the bottom of page 138.

    Off topic, your $db string is equivalent to the much simpler: $db = "192.168.1.17/apporcl";
This discussion has been closed.