how to fetch data from oracle database using PHP

Question

I am trying to create a class for executing oracle sql statements on PHP.

here is my index.php where I am trying to call my function

 <?php  
    include "dbaseconn/dbcontrol.php";
    $DbControl = new DbControl;
    $DbControl->execute(" SELECT * FROM SAMPLE_TABLE");
        foreach($DbControl->data as $items)
        {
         echo $items['SAMPLE_COLUMN_NAME'];
        }
?>

and my dbcontrol.php for my function

<?php
class DbControl{
    public $dbstr ='(DESCRIPTION = 
                (ADDRESS_LIST = 
                            (ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(HOST = XX.XXX.XXX.XX)(PORT = XXXX))
                    )
                    (CONNECT_DATA = 
                      (SID = XXXXX)
                    )
                  )';

        public $user = "XXXXX";
        public $password = "XXXXX";

        function connect(){
            $this->connection = oci_connect($this->user,$this->password,$this->dbstr) or die(oci_error());
        }

    function execute($query){
        $this -> connect(); //Database Connect
        $this -> statement = oci_parse($this->connection,$query); //prepare the statement
        $this -> execute = oci_execute($this -> statement); //execute the statement
        $this -> totalRows = oci_num_rows($this -> statement); //get total number of rows
        $this -> data = array();
        if($this -> totalRows > 0){
                            //fetch data
                while($result = oci_fetch_array($this->statement)){
                    $this -> data[] = $result;
                }
        }
    }   
}   

?>

I'm not sure what seems to be wrong. But everytime I run this. Nothing is shown on page. No result, No data. But I am sure that database has data.

I found this link useful st-curriculum.oracle.com/obe/db/11g/r2/prod/appdev/opensrclang/… — Rajeev Bera
– Rajeev Bera, Commented Jul 22, 2013 at 7:34
Why not to use PDO? it can handle any kind of database, including oracle afaik — STT LCU
– STT LCU, Commented Jul 22, 2013 at 8:58

Nick Krasnov · Accepted Answer · 2013-07-22 08:53:32Z

1

The reasons why you are keep getting a blank page are:

1. $this -> totalRows = oci_num_rows($this -> statement);

oci_num_rows() function does not return the number of selected rows as you might think. It returns number of rows affected by some DML statement(except SELECT statement). So in your case it will always return 0 and as a result of it the condition

2. if($this -> totalRows > 0)

evaluates to false and while loop will never be executed.

Besides, oci_fetch_array() fetches one row at a time or FALSE if there is no more rows to return, so if($this -> totalRows > 0) in your case seems redundant.

edited Jul 22, 2013 at 8:53

answered Jul 22, 2013 at 8:28

Nick Krasnov

27.3k6 gold badges66 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ravi · Accepted Answer · 2013-07-22 08:38:08Z

0

I would say, first check with your database connectivity, then check, whether it is connected with right database or not ? Check for how many rows is being selected.

I will recommend you to use show_error() function to validate your database connection.

answered Jul 22, 2013 at 8:38

Ravi

31.6k44 gold badges124 silver badges180 bronze badges

Collectives™ on Stack Overflow

how to fetch data from oracle database using PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related