// $__oradb->setOption('portability', DB_PORTABILITY_LOWERCASE);
require_once "config.php";
require_once "sqlrelay.php";
unset($__config['sqlrelay_dsn']);
$__config['sqlrelay_dsn'][]="sqlrelay://xx_id:[email protected]:9000";
$sql="select aaa,bbb from xxxx t where g_close_date is null";
$__now=get_microtime();
$__oradb=_fn_connect_sqlrelay();
$__oradb->setOption('portability', DB_PORTABILITY_LOWERCASE);
$result = $__oradb->query($sql);
if (DB::isError($result)) {
echo "db error\n";
printf("Execution time : %s\n",get_microtime()-$__now);
exit;
}
while ( $row=$result->fetchRow(DB_FETCHMODE_ASSOC) ) {
// -----
echo $row['aaa'] . ' : ' . $row['bbb'];
}
$result->free();
$__oradb->disconnect();
// 取時間 function
function get_microtime() {
list($usec, $sec) = explode(' ',microtime() );
return ((double)$usec + (double)$sec);
}