Action = "update";
$UpdateQuery->Table = "chemicalagent";
$UpdateQuery->bindColumn("name_chemicalagent", "s", "".((isset($_POST["name_chemicalagent"]))?$_POST["name_chemicalagent"]:"") ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("name_chemicalagent_en", "s", "".((isset($_POST["name_chemicalagent_en"]))?$_POST["name_chemicalagent_en"]:"") ."", "WA_DEFAULT");
$UpdateQuery->addFilter("idchemicalagent", "=", "i", "".($idchemicalagent) ."");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
if (isset($formnameadd)) {
$InsertQuery = new WA_MySQLi_Query($cmctrfdb);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "chemicalagent";
$InsertQuery->bindColumn("name_chemicalagent", "s", "".((isset($_POST["name_chemicalagent"]))?$_POST["name_chemicalagent"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("name_chemicalagent_en", "s", "".((isset($_POST["name_chemicalagent_en"]))?$_POST["name_chemicalagent_en"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("");
$InsertQuery->execute();
$InsertGoTo = "";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
setQuery("SELECT * FROM chemicalagent ORDER BY chemicalagent.name_chemicalagent");
$chemlist->execute();
?>
TRF CIMAC
| Nome Chemical Agent (ITA) |
Nome Chemical Agent (ENG) |
|
atEnd()) {
$wa_startindex = $chemlist->Index;
?>
| getColumnVal("name_chemicalagent")); ?> |
getColumnVal("name_chemicalagent_en")); ?> |
" class="mr-2">
|
moveNext();
}
$chemlist->moveFirst(); //return RS to first record
unset($wa_startindex);
unset($wa_repeatcount);
?>