DB_FETCHMODE_ORDERED and OCI8
| From: | mclinden at informed dot net | Date: | Thu, 12 Sep 2002 14:29:49 +0000 |
| Subject: | DB_FETCHMODE_ORDERED and OCI8 | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-2290@lists.php.net to get a copy of this message | ||
The following snippet of code seems to DIE when used with OCI8. Is the
DB_FETCHMODE_ORDERED not implemented for OCI8?
Thanks.
Sean McLinden
Outcome Technology Associates, Inc.
function sessionGc ($maxlifetime)
{
global $session, $HANDLER;
$mincnt = $maxlifetime/24/60;
$query = "SELECT TO_CHAR(SYSDATE, 'YYYYMMDDHHMISS'),
TO_CHAR(SYSDATE-$mincnt, 'YYYYMMDDHHMISS') FROM DUAL";
$result = $HANDLER->query($query);
if ( DB::isError($result)) {
die("sessionGC query died with error: " . $result->getMessage());
}
/*
* Not implemented for OCI8
*
* if ( $result->numRows() != 1 ) {
* die("SYSDATE functions returned abnormal result\n"); */
*
* }
*/
$row = $result->fetchRow(DB_FETCHMODE_ORDERED);
if ( DB::isError($row)) {
die("SessionGC fetch failed with error: " . $row->getMessage());
^^^^^^^^^----------DIES HERE
}
$cuirrentTime = $row[0];
$expirationTime = $row[1];
$delqry = "DELETE FROM websession WHERE sexp <
TO_DATE('$expirationTime', \'YYYYMMDDHHMISS\')";
$delres = $HANDLER->query($delqry);
if ( DB::isError($delres)) {
die("sessionGc delete failed with error: " . $delres->getMessage());
} else {
return true;
}
}