odbc_fetch_object
When I migrates from 4 to 5 took me a long day to find the solution.
The way to use it without problems
In php4:
<?php
while (odbc_fetch_row($stringsql)) {
// ...
}
?>
In php5:
<?php
odbc_fetch_row($stringsql, 0);
while (odbc_fetch_row($stringsql)) {
// ...
}
?>
Good luck
odbc_fetch_row
(PHP 4, PHP 5)
odbc_fetch_row — Fetch a row
Description
bool odbc_fetch_row
( resource
$result_id
[, int $row_number
] )Fetches a row of the data that was returned by odbc_do() or odbc_exec(). After odbc_fetch_row() is called, the fields of that row can be accessed with odbc_result().
Parameters
-
result_id -
The result identifier.
-
row_number -
If
row_numberis not specified, odbc_fetch_row() will try to fetch the next row in the result set. Calls to odbc_fetch_row() with and withoutrow_numbercan be mixed.To step through the result more than once, you can call odbc_fetch_row() with
row_number1, and then continue doing odbc_fetch_row() withoutrow_numberto review the result. If a driver doesn't support fetching rows by number, therow_numberparameter is ignored.
Return Values
Returns TRUE if there was a row, FALSE otherwise.
add a note
User Contributed Notes
odbc_fetch_row - [10 notes]
eolscr at gmail dot com ¶
8 years ago
furiousrcj ¶
3 years ago
Here is code snippet to do dynamically build a table so you do not have to hardcode the fields that you wish to display. You could use the the odbc_result_all but this allows special handling of rows/columns. This is similar to some ASP code I use.
<?php
$Fields = odbc_num_fields($cur);
print "<table border='1' width='100%'><tr>";
// Build Column Headers
for ($i=1; $i <= $Fields; $i++){
printf("<th bgcolor='silver'>%s</th>", odbc_field_name( $cur,$i));
}
// Table Body
$Outer=0;
while( odbc_fetch_row( $cur )){
$Outer++;
print "<tr>";
for($i=1; $i <= $Fields; $i++){
printf("<td>%s</td>", odbc_result( $cur, $i ));
}
print "</tr>";
}
print "</table>";
print "<b> Your request returned $Outer rows!</b>";
odbc_close( $cnx);
?>
GiladD ¶
5 years ago
Here's my silly companion to odbc_fetch_row, odbc_fetch_column!
It takes a SQL table and the Column's name to look for, and returns an array with all the items in that column. It can be easily changes to take the column's number instead of name, but I prefer it this way.
<?php
function odbc_fetch_column($my_rs,$col_name) {
$tmpArray = array();
while (odbc_fetch_row($my_rs)) {array_push($tmpArray,odbc_result($my_rs,$col_name));}
return $tmpArray;
}
?>
ben at imperialsoftwaresystems dot com ¶
5 years ago
I traced out a problem to odbc_fetch_row hanging while trying to retrieve the 'row after the last record'. Instead of simply returning false it would cause a timeout. This crept up after a site I maintain recently converted from MS Access DB to MS SQL Server DB.
To work around the issue I first do 'select count(*) from blah'. I check that value as I loop through the records, and once I reach the number of records specified by my count(*) I stop my loop.
romanziak at yahoo dot ca ¶
7 years ago
I see many here try to iterate to emulate tis missing functionality. I benchmarked the performance on my PentiumM 1.6G on Excel table with 1100 rows and 2 field records and got 82ms time to retrieve number of rows using iteration through all of them, but only 7ms to execute the SQL statement. In this case of thousadn(s) of rows, it is probably faster to have the database calculate rows.
Here is different algorithm for calculating the number of rows, which does not iterate through all of them, just uses interval splitting algorithm, and number of iterations is log2(n), where n is total number of rows in the result. The below algorithm in the case above (Excel table, 1100 rows 2 fields) took 10ms to calculate:
<?php
for($lo=0,$hi=1000000; $lo<$hi; )
{
$num = (int)(($hi+$lo) / 2);
if(odbc_fetch_row($this->Result, $num))
$lo = $num + 1;
else
$hi = $num - 1;
}
?>
ricmailinglists at yahoo dot com dot br ¶
7 years ago
To count all the row on a table
<?php
$connection= odbc_connect("SolidBase", "user", "");
$query = "SELECT Codigo FROM Produto";
$queryexe = odbc_do($connection, $query);
$i = 0;
while(odbc_fetch_row($queryexe)) $i++;
echo $i;
?>
RRRRyan ¶
8 years ago
It appears in PHP 5 that odbc_fetch_row($rs,0) no longer acts the same way. Now that I moved to PHP 5 moving to row 0 no longer resets the record set rather it fetches the first row. :-( This broke a lot of things for me. So watch out for a missing first row on record sets reset in this fashion.
alex at bartl dot net ¶
10 years ago
I found the combination of the following lines very useful, as the
fieldnames will be simply available as variables by their names.
<?php
$query="select fieldname from table";
// ...
$line=mysql_fetch_assoc($query_result);
extract($line);
echo $fieldname;
?>
However, I was missing the function odbc_fetch_assoc() so I created it myself to use in in the same way like mysql_fetch_assoc(). I am sure it could be coded in a better way, but at least it works. As a side effect $odbc_affected_rows should contain the amount of rows found, but have a look at odbc_num_rows() as well, as in my case it does not contain the expected information.
<?php array obdc_fetch_assoc(resource result); ?>
Code example:
<?php
function odbc_fetch_assoc($rs){
if (odbc_fetch_row($rs)){
$line=array("odbc_affected_rows"=>odbc_num_rows($rs));
for($f=1;$f<=odbc_num_fields($rs);$f++){
$fn=odbc_field_name($rs,$f);
$fct=odbc_result($rs,$fn);
$newline=array($fn => $fct);
$line=array_merge($line,$newline);
//echo $f.": ".$fn."=".$fct."<br>";
}
return $line;
}
else{
return false;
}
}
?>
scott at abcoa dot com ¶
10 years ago
The odbc_fetch_row() function worked fine when I used PHP version 4.0.6 but when I upgraded PHP to 4.2.2, the odbc_fetch_row() doesn't work when there is 1 row.
When I use the echo command to see the response to the odbc_fetch_row() before the while loop, it showed that it doesn't return True or anything when there is 1 row.
I made the workaround to the problem by including the "$bug_workaround" into the script, this is to be use as 'row number' as shown in the PHP manual at "http://www.php.net/manual/en/function.odbc-fetch-row.php".
I enclosed two clipping to point this out. The 1st clipping is the one that don't work and the 2nd clipping showed the work-around to it. In this script, you'll find the word, 'INQUIRIES', it is a table that contain number of companies and users. What the script does is to display each user whenever the company is selected. The cool thing about it is it won't display the data if there is no row for any user.
<?php
// --clip--
$cid = odbc_connect('blah blah blah');
$ask7 = "SELECT * FROM INQUIRIES WHERE USER_ID = '38SCK3'";
$R7 = odbc_exec($cid,$ask7);
$result = odbc_result($R7,1);
echo "Result or No Result??? --> ".odbc_fetch_row($R7);
while (odbc_fetch_row($R7))
{
odbc_fetch_into($R7,$inquiry,$inq_c);
echo $inquiry[0], $inquiry[1];
}
// --clip--
// --clip--
$cid = odbc_connect('blah blah blah');
$ask7 = "SELECT * FROM INQUIRIES WHERE USER_ID = '38SCK3'";
$R7 = odbc_exec($cid,$ask7);
$result = odbc_result($R7,1);
echo "Result or No Result??? --> ".odbc_fetch_row($R7);
$bug_workaround=0;
while (odbc_fetch_row($R7,++$bug_workaround))
{
odbc_fetch_into($R7,$inquiry,$inq_c);
echo $inquiry[0], $inquiry[1];
}
// --clip--
?>
I post this into bugs.php.net as well. See bug #19528
david dot zepp at alltel dot com ¶
13 years ago
Here is code snippet to do dynamically build a table so you do not have to hardcode the fields that you wish to display. You could use the the odbc_result_all but this allows special handling of rows/columns. This is similar to some ASP code I use.
<?php
$Fields = odbc_num_fields($cur);
print "<table border='1' width='100%'><tr>";
// Build Column Headers
for ($i=1; $i <= $Fields; $i++){
printf("<th bgcolor='silver'>%s</th>", odbc_field_name( $cur,$i));
}
// Table Body
$Outer=0;
while( odbc_fetch_row( $cur )){
$Outer++;
print "<tr>";
for($i=1; $i <= $Fields; $i++){
printf("<td>%s</td>", odbc_result( $cur, $i ));
}
print "</tr>";
}
print "</table>";
print "<b> Your request returned $Outer rows!</b>";
odbc_close( $cnx);
?>