note 7139 deleted from ref.oracle by danbrown
| From: | danbrown@php.net | Date: | Fri, 28 Nov 2008 22:25:15 +0000 |
| Subject: | note 7139 deleted from ref.oracle by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147338@lists.php.net to get a copy of this message | ||
Note Submitter: elf at messer dot de
----
I contribute the following code example.
function GetNameFromUserId ($ID, &$User, &$Msg)
{
print('<BR>GetNameFromUserId Start');
if ($Session = ora_plogon('Hello', 'World'))
{
print('<P>Session: ' . $Session . '<P>');
if ($Cursor = ora_open($Session))
{
print('<P>Cursor: ' . $Cursor . '<P>');
$SQL = 'SELECT NAME FROM PERSONS WHERE USERID = \''
. $ID . '\'';
print('<P>SQL: ' . $SQL . '<P>');
// Prepare SQL statement
if (ora_parse($Cursor, $SQL))
{
if (ora_exec($Cursor))
{
$Row[] = '';
// Retrieve a complete row from the result set
if (ora_fetch_into($Cursor, &$Row))
{
$User = 'count = ' . count($Row) . ': ';
while (list($Key, $Value) = each($Row))
{
$User .= '<BR>Row[' . $Key . '] = ' . $Value;
}
$Result = 0;
}
else
{
$Msg = ora_error($Cursor);
$Result = ora_errorcode($Cursor);
} // end of if expression
}
else
{
$Msg = ora_error($Cursor);
$Result = ora_errorcode($Cursor);
} // end of if expression
}
else
{
$Msg = ora_error($Cursor);
$Result = ora_errorcode($Cursor);
} // end of if expression
ora_close($Cursor);
}
else
{
$Msg = ora_error($Session);
$Result = ora_errorcode($Session);
} // end of if expression
ora_logoff($Session);
}
else
{
$Msg = ora_error($Session);
$Result = ora_errorcode($Session);
} // end of if expression
print('<BR>GetNameFromUserId End');
return $Result;
}