odbc returning events

jaskillo

I've the following code, and I can get the field names, but I can't get the result data, what can I do

<HEAD>
<BODY>
<?php
$user="admin";
$host="jask.dns2go.com";
$password="";
$ro = "WV";
$query = "select * from embarque";
$conn=odbc_connect($host,$user,$password);
$result=odbc_do($conn, $query);
?>
<?php
if ($result == 0):
echo ("No se Pudo Conectar");
elseif (odbc_num_rows($result) == 0):
echo("<B>Query executed successfully!</B>");
else:
?>

<TABLE BORDER=1>
<THEAD>
<TR>
<?php
for ($i = 1; $i < odbc_num_fields($result); $i++) {
echo("<TH>" . odbc_field_name($result,$i) . "</TH>");
}
?>
</TR>
</THEAD>
<TBODY>
<?php
for ($i = 1; $i < odbc_num_rows($result); $i++) {
echo("<TR>");
$row_array = odbc_fetch_row($result, $i);
for ($j = 1; $j < odbc_num_fields($result); $j++) {
echo("<TD>" . $row_array[$j] . "</TD>");
}
echo("</TR>");
}
?>
</TBODY>
</TABLE>

<?php
endif
?>

thanks

ccgorman

is your :

$result=odbc_do($conn, $query);

something like:

function odbc_do($conn,$query) {
$i=0;
$stmt=OCIParse($conn,$query);
if ($stmt) {
$i = OCIExecute($stmt);
}
return $i;
}

if so you could create a fetch row function as follows:

function fetchRow($stmt,$assoc=""){
if ($assoc=="assoc") {
OCIFetchInto($stmt,$fetchResult,OCI_ASSOC+OCI_RETURN_NULLS+OCI_RETURN_LOBS);
}
else{
OCIFetchInto($stmt,$fetchResult,OCI_NUM+OCI_RETURN_NULLS+OCI_RETURN_LOBS);

}
return($fetchResult);

}

You could then fetch the rows out as associative or indexed.

Hope this helps,
Chris

neuromancer

The problem is here "odbc_num_rows($result) == 0"

Most ODBC drivers return 0 rows because the driver doesn't know how many rows are waiting. Instead make a while loop around odbc_fetch_row()

neuromancer

thx crack, did you even notice he was using the odbc functions?

Second you should use | instead of + for bitwise stuff.

OCI_ASSOC|OCI_RETURN_NULLS|OCI_RETURN_LOBS