present()->signaturecode; if ($tokenid != $tokensignatureon) { header("Location: declaration.php?idtrf=$idtrf&tokenresult=ko"); } else { // update trf details` if (isset($_POST["formdeclaration"])) { if ($sndrpt == 'N') { $UpdateQuery = new WA_MySQLi_Query($cmctrfdb); $UpdateQuery->Action = "update"; $UpdateQuery->Table = "data_td"; $UpdateQuery->bindColumn("signnametd", "s", "$clientname", "WA_DEFAULT"); $UpdateQuery->bindColumn("signedontd", "s", "$datetrf", "WA_DEFAULT"); $UpdateQuery->bindColumn("statustd", "s", "Signed", "WA_DEFAULT"); $UpdateQuery->addFilter("iddata_td", "=", "i", "" . ($idtd) . ""); $UpdateQuery->execute(); $UpdateGoTo = ""; if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo ? rel2abs($UpdateGoTo, dirname(__FILE__)) : ""; $UpdateQuery->redirect($UpdateGoTo); } } ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrf'"); $trfnumberfinal->execute(); $idcertn = $trfnumberfinal->getColumnVal("idcertification"); $idarticletype = $trfnumberfinal->getColumnVal("idarticletype"); $appformn = $trfnumberfinal->getColumnVal("trfnumber"); $ntrfmail = $trfnumberfinal->getColumnVal("trfnumber");; $revnumb = $trfnumberfinal->getColumnVal("revtrf"); ?> getColumnVal("idcertification") ?> prepare($sql); $stmt->bind_param("i", $idtd); // "i" indica che l'id è un intero $stmt->execute(); $result = $stmt->get_result(); $row = $result->fetch_assoc(); $statustd = $row['statustd']; $idtrftd = $row['idtrf']; $tdnumber = $row['tdnumber']; $tdrev = $row['td_rev']; $trfmod = $row['trfmod']; $stmt->close(); $conn->close(); ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute(); ?> setQuery("SELECT * FROM chemicalagent ORDER BY chemicalagent.name_chemicalagent"); $chemicalagentlist->execute(); ?>