php function oci_fetch_array is returning only one row

Question

$stid = oci_parse('SELECT FIRSTNAME, LASTNAME, DESIGNATION, DEPARTMENT, BRANCH FROM USERS');  
while (($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS
                        | OCI_RETURN_LOBS)) != false) {

            $result[] = $row;
            }

oci_fetch_array is returning only one row while there are many rows in the table.

$stid = oci_parse('SELECT FIRSTNAME, LASTNAME, DESIGNATION, DEPARTMENT, BRANCH FROM USERS'); — Bilal Qadri
– Bilal Qadri, Commented Nov 9, 2017 at 12:43

Barbaros Özhan · Accepted Answer · 2017-11-09 14:22:29Z

1

it seems, your problem is related to | before OCI_RETURN_LOBS part.

Make your statement as below :

($row = oci_fetch_array($stid, OCI_ASSOC + OCI_RETURN_NULLS + OCI_RETURN_LOBS)) != false.

edited Nov 9, 2017 at 14:22

answered Nov 9, 2017 at 13:52

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

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

1 Comment

Christopher Jones Over a year ago

It's not related to the mix of '+' and '|'. A quick test shows the mixed syntax working.

Collectives™ on Stack Overflow

php function oci_fetch_array is returning only one row

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related