PHP odbc_fetch_object() function usage and example

PHP ODBC Reference Manual

　The odbc_fetch_object() function retrieves the result row as an object.

Syntax

object odbc_fetch_object ( resource $result [, int $rownumber ] )

Definition and usage

It is used to get the result as an object.

Return value

It returns an object or sends a message because there are no more rows.

Parameter

Example

Try the following example

<?php
　　　$input_ID = odbc_connect($db_name, $username, $password) or die(odbc_error_msg());
　　　$sql = "SELECT　*　FROM TABLE";
　　　$result = odbc_exec($input_ID, $sql);
　　　
　　　while ($rows = odbc_fetch_object($result)) {
　　　　　　print $rows->COLUMNNAME;
　　　}
　　　
　　　odbc_close($input_ID);　
?>

PHP ODBC Reference Manual