|
if($GroupLine != "Random"){
?> |
Detail :
$dsn = 'DRIVER={iSeries Access ODBC Driver};SYSTEM=192.168.100.3;';
$username = 'pclink';
$password = 'pclink';
$odbc_conn = odbc_connect($dsn, $username, $password, SQL_CUR_USE_ODBC) or die(odbc_error());
// sql query ???????????
if($Kind!="1"){
$sql = "select * from cdcfile.pfpdlne where LNEGRP = '$GroupLine' and LNEKND = '$Kind' and LNEFAC = '$Factory' order by LNENAM asc";
}elseif($Kind=="1"){
$sql = "select * from cdcfile.pfpdlne where LNEGRP = '$GroupLine' and LNEFAC = '$Factory' order by LNENAM asc";
}
// ????????? query
$query = odbc_exec($odbc_conn,$sql);
for($i=1;$row=odbc_fetch_array($query);$i++){
?>
Notice: Undefined variable: row in C:\xampp\www\coilno\index.php on line 129
/
}
// sql query ???????????
$sql1 = "select * from cdcfile.pfchart";
// ????????? query
$query1 = odbc_exec($odbc_conn,$sql1);
for($i=1;$row1=odbc_fetch_array($query1);$i++){
$lstDAY = $row1['DATE'];
$lstTIME = $row1['OPTIMSM'];
}
}
?> |
|