sqlrelay sample code / prepare statement / bind value 寫法
include dirname(__FILE__) . '/local_config.php';
$__oradb=_fn_connect_sqlrelay();
$__oradb->setOption('portability', DB_PORTABILITY_LOWERCASE);
$sql = '
select g_no,ctrl_rowid,g_storage,g_img
from goods_file
where g_no=?
';
foreach ( $items as $g_no => $v ) {
$prepare = $__oradb->prepare($sql);
$result = $__oradb->execute($prepare,$g_no);
if ( $result ) {
$row = $result->fetchRow(DB_FETCHMODE_ASSOC);
$items[ $g_no ]['ctrl_rowid'] = $row['ctrl_rowid'];
$items[ $g_no ]['g_storage'] = $row['g_storage'];
$items[ $g_no ]['g_img'] = $row['g_img'];
$result->free();
} else continue;
}
$__oradb->disconnect();
