1
2
3
4
5
6
7
8
9
10
11
12
13
| <?php
set_time_limit(0);
$conn = odbc_connect($database,'login','pwd',SQL_CUR_USE_DRIVER);
$query = "select * from table(gem.floorstatus()) as status where testcell is not null order by testcell";
$result = odbc_exec($conn, $query);
global $array_testcell, $array_machtype, $array_machmod, $array_machser, $array_opnum, $array_title, $array_opmode, $array_opstatus, $array_ordernum, $array_processlevel, $array_opnumfails, $array_lastgoodop, $array_lastgoodtime, $array_statustime, $array_starttime, $array_process_time, $array_process_rem;
while(odbc_fetch_row($result)){
if (odbc_result($result,1)!=''){array_push($array_testcell,odbc_result($result,1));}else{array_push($array_testcell,'null');}
if (odbc_result($result,2)!=''){array_push($array_machtype,odbc_result($result,2));}else{array_push($array_machtype,'null');}
if (odbc_result($result,3)!=''){array_push($array_machmod,odbc_result($result,3));}else{array_push($array_machmod,'null');}
}
odbc_close($conn); |
