can't get data from oracle table

[bookouri]

I have a page that pulls some data from a table:

while (($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) != false) {
    echo "<tr>\n";
    foreach ($row as $item) {
        echo "  <td>".($item !== null ? htmlentities($item, ENT_QUOTES) : "&nbsp;")."</td>\n";
    }
}

this works fine as is, but I need to be able to specify the individual columns so I can do some formatting on them. I have found dozens of examples similar to the following that should do what I need, but I can NOT get any data to return using this example.

This is from the manual.

<?php
$connection = oci_connect("apelsin", "kanistra");
$query = "SELECT id, name FROM fruits";
$statement = oci_parse ($connection, $query);
oci_execute ($statement);
while ($row = oci_fetch_array ($statement, OCI_BOTH)) {
    echo $row[0]." and ".$row['ID']." is the same<br>";
    echo $row[1]." and ".$row['NAME']." is the same<br>";
}
?>

This is almost verbatim from the php manual, but i just can not get it to return any data. Can ANYBODY tell me what I'm doing wrong?

while (($row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS)) != false) {
    echo "<tr>\n";
    echo "<td>" .$row['OJBECT_ID'] . "</td>";
    echo "<td>" .$row['OJBECT_NAME'] . "</td>";
    echo "</tr>\n";

 

[vacunita]

THe fiirst thing would be to find out how the data is being retuened in the $row array. so why not output the entire $row variable see what it looks like.

echo "<pre>" . print_r($row,1) . "</pre>";

Are you sure your column names are OBJECT_ID and OBJECT_NAME?







----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[bookouri]

the object_id and object_name are definitely correct.

while (($row = oci_fetch_array($stid, OCI_BOTH+OCI_ASSOC+OCI_RETURN_NULLS))) {
  
    echo "<pre>" . print_r($row,1) . "</pre>"; 
  
}

this code causes the browser to hang, and eventually crash...but never returns anything

 

[vacunita]

Odd, that should just print the row.

Try just printing one row instead of all the rows.

    $row = oci_fetch_array($stid, OCI_BOTH);
  
    echo "<pre>" . print_r($row,1) . "</pre>";

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[bookouri]

that returns my data just like it should.

Array
(
[0] => 4
[OBJECT_ID] => 4
[1] => jpeg
[OBJECT_TYPE] => jpeg
[2] => test1.jpg
[OBJECT_FILE_NAME] => test1.jpg
[3] => desc
[OBJECT_DESC] => desc
[4] => ins by
[OBJECT_INSERTED_BY] => ins by
[5] => OCI-Lob Object
(
[descriptor] => Resource id #3
)

[OBJECT_BLOB] => OCI-Lob Object
(
[descriptor] => Resource id #3
)

)

 

[vacunita]

So, so then what you have is a typo.

echo "<td>" .$row['OJBECT_ID'] . "</td>";
echo "<td>" .$row['OJBECT_NAME'] . "</td>";

OJBECT != OBJECT





----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[bookouri]

I'll try again with a clean page then. I must have re-typed this stuff a dozen times but as long as I know Im not missing anything major stupid.

thanks

 

[bookouri]

You were right. I typed everything in from scratch again. Now it works. I spent hours proof reading character by character my other pages, but somehow missed whatever typo must have been there.

thanks again..