Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2008
    Posts
    21

    Red face Unanswered: need help -- connecting oracle with php

    i am tried of trying to connect the oracle dbms to php.
    at first the php wasn't able to locate the oci.dll file.

    so, i downloaded the latest Oracle client driver and copied it to 'oracle\bin'.

    now php can find the oci.dll file. but when i tried to execute the following codes the httpd crashes.

    $conn = OCILogon("system","123", $tnsName);

    $stmt = OCIParse($conn,"select * from emp where empno > :emp order by empno");
    $emp = 7900;
    OCIBindByName($stmt, ':emp', $emp);
    $ok = OCIExecute($stmt);
    while (OCIFetchInto($stmt,$arr)) {
    print_r($arr);
    echo "<hr>";
    }

    does any one know what is the problem.

    sorry for my english.
    again sorry if the question is posted in wrong section . because i cant understand what is the problem .

    have a nice week.bye.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Hmmmm......
    PHP is crashing Apache, so you post to an Oracle forum for answers.
    Good Luck with solving your problem.
    Just out of idle curiosity, has anyone ever successfully connected to Oracle using PHP on this system?
    If so, you might want to look at the working code.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2008
    Posts
    21

    Lightbulb

    thanks for the reply.
    this is the first time that anyone is trying to connect to oracle from php
    thanks again for the suggestion. i will post a thread on oracle forums.

    take care n bye.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •