Question

0

My PL/SQL procedure returns a cursor. It always returns data. I fetch (oci_fetch_assoc) it and save it in an array. If results were found the keys of the array will be strings. If the cursor didn't find data, it will return value 0, thus the key of the array will be numeric.

while($data = oci_fetch_assoc($cursor)){
    if(!isset($data[0])){
       ...
    }
...
...
}

What's the best way to check that the array is not just 0, but contains data?

Thanks

flag	asked Apr 8 at 14:37 Kel 25●6

i'm not sure if i'm reading the question right, isset() checks for if your array[0] has a value attached to it :S – Rob Apr 8 at 14:41

sorry... my procedure always returns a cursor. When I open my first cursor I collect data. After this I check if any rows were found. If there aren't any, I'll open the cursor with a different Select statement, which always returns 0. So, in PHP I will always get an array with value in it. The goal of my condition is to find out if the array has not just 0 as a value $array[0] = 0). – Kel Apr 8 at 14:55

Kel · Answer 1 · 2010-04-08 15:02:36Z

1

Here is my solution:

if($data != array(0 => "0")){

and it works

answered Apr 8 at 15:02

Kel
25●6

hsz · Answer 2 · 2010-04-08 14:39:47Z

0

if(!empty($data[0])) { ... }

answered Apr 8 at 14:39

hsz
1,812●2●13

sorry... my procedure always returns a cursor. When I open my first cursor I collect data. After this I check if any rows were found. If there aren't any, I'll open the cursor with a different Select statement, which always returns 0. So, in PHP I will always get an array with value in it. The goal of my condition is to find out if the array has not just 0 as a value $array[0] = 0). – Kel Apr 8 at 14:55

OIS · Answer 3 · 2010-04-08 15:07:47Z

oci_fetch_assoc returns an associated array, that is the column names are indexes in the array.

try one of these:

($data['firstColumn'] === 0)
(reset($data) === 0)

where 'firstColumn' is the actual name of the first column

zaf · Answer 4 · 2010-04-08 15:09:11Z

0

You can use the '===' to see if $data[0] equals 0. Like:

if($data[0]===0) {
   // It really is the number 0
}

edited Apr 8 at 15:09

answered Apr 8 at 14:40

zaf
1,965●1●10

sorry... my procedure always returns a cursor. When I open my first cursor I collect data. After this I check if any rows were found. If there aren't any, I'll open the cursor with a different Select statement, which always returns 0. So, in PHP I will always get an array with value in it. The goal of my condition is to find out if the array has not just 0 as a value $array[0] = 0). – Kel Apr 8 at 14:54

OK. Updated my answer. – zaf Apr 8 at 15:09

[PHP] Condition for array with string as keys

4 Answers

Your Answer

Not the answer you're looking for? Browse other questions tagged php array ref-cursor condition or ask your own question.

Hello World!

Related