Action = "insert"; $InsertQuery->Table = "wheretrfstep"; $InsertQuery->bindColumn("idtrf", "i", "$idtrf", "WA_DEFAULT"); $InsertQuery->bindColumn("code", "i", "$code", "WA_DEFAULT"); $InsertQuery->saveInSession(""); $InsertQuery->execute(); $InsertGoTo = ""; $InsertQuery->redirect($InsertGoTo); } ?> setQuery("SELECT * FROM `trf-details` WHERE `trf-details`.idtrfdetails='$idtrf'"); $trfnumberfinal->execute(); $idcertn = $trfnumberfinal->getColumnVal("idcertification"); $idarticletype = $trfnumberfinal->getColumnVal("idarticletype"); $otherclient = $trfnumberfinal->getColumnVal("otherclient"); ?> getColumnVal("idcertification") ?> setQuery("SELECT * FROM certificationtype WHERE certificationtype.idcertificationtype='$idcert'"); $certname->execute(); ?> setQuery("SELECT * FROM chemicalagent ORDER BY chemicalagent.name_chemicalagent"); $chemicalagentlist->execute(); ?> prepare($query)) { // Legare i parametri per i marcatori $stmt->bind_param("i", $idtrf); // Esecuzione dello statement $stmt->execute(); // Ottenere i risultati $result = $stmt->get_result(); if ($row = $result->fetch_assoc()) { if ($row['cnt'] > 0) { $dpicattwo = 'Y'; } } // Chiudere lo statement $stmt->close(); } else { echo "Errore nella preparazione della query: " . $conn->error; } ?> connect_error) { die("Connessione fallita: " . $conn->connect_error); } if ($_SERVER['REQUEST_METHOD'] === 'POST') { // Recupera i dati dal form $idtrf = $_POST['idtrf']; $otherclient = $_POST['customRadio']; // Prepara e esegui la query di aggiornamento $sql = "UPDATE `trf-details` SET otherclient = ? WHERE idtrfdetails = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("si", $otherclient, $idtrf); if ($stmt->execute()) { } else { echo "Errore nell'aggiornamento del record: " . $conn->error; } // Chiudi lo statement $stmt->close(); } // Chiudi la connessione $conn->close(); ?> <?php echo $titlepage; ?>
  2. Starter

95%

>
>

setQuery("SELECT * FROM contacts LEFT JOIN countries ON contacts.country=countries.idcountries WHERE contacts.idtrf='$idtrf' AND contacts.kindofcontacts='$kindcont'"); $audticontactdata->execute(); ?>
getColumnVal("companyname")); ?> getColumnVal("address")); ?> getColumnVal("city")); ?>

', '_blank', 'location=yes,height=500,width=850,scrollbars=yes,status=yes');">

setQuery("SELECT * FROM contacts LEFT JOIN countries ON contacts.country=countries.idcountries WHERE contacts.idtrf='$idtrf' AND contacts.kindofcontacts='$kindcont'"); $audticontactdata->execute(); ?> getColumnVal("ce"); ?>
CE
getColumnVal("companyname")); ?> getColumnVal("address")); ?> getColumnVal("city")); ?> getColumnVal("ce")); ?>

', '_blank', 'location=yes,height=500,width=850,scrollbars=yes,status=yes');">

setQuery("SELECT * FROM contacts WHERE contacts.idtrf='$idtrf' AND contacts.kindofcontacts='$kindcont'"); $audticontactdata->execute(); ?>
getColumnVal("companyname")); ?> getColumnVal("address")); ?> getColumnVal("city")); ?>

', '_blank', 'location=yes,height=500,width=850,scrollbars=yes,status=yes');">

setQuery("SELECT * FROM contacts LEFT JOIN countries ON contacts.country=countries.idcountries WHERE contacts.idtrf='$idtrf' AND contacts.kindofcontacts='$kindcont'"); $audticontactdata->execute(); ?>
getColumnVal("companyname")); ?> getColumnVal("address")); ?> getColumnVal("city")); ?>

', '_blank', 'location=yes,height=500,width=850,scrollbars=yes,status=yes');">


@



">