Ciao, volevo chiedervi se capite questi 2 problemi
1) la pagina db_update6 passa giustamente delle variabili alla update8, il titolo
della update8 ha le variabili corrette pero' quando le testo o le stampo non c'e' nessun
valore.
2) non funziona la insert into, ammetto che non so se e' giusta la sintassi.
POSTO LE 2 PAGINE
update6 (chiamante)
<html>
<?php
define("PAGE_TITLE", "Customer Update");
define("PHP_FILE_NAME", "db2_update6.php")
?>
<title><?= PAGE_TITLE . " - " . PHP_FILE_NAME; ?></title>
<body>
<?php
/* Reperimento variabile passata dalla lista server clienti db2_update7*/
$customerSERCLI = $_GET["customerSERCLI"];
$customerSERNUM = $_GET["customerSERNUM"];
$customerSERSRN = $_GET["customerSERSRN"];
$customerSERMOD = $_GET["customerSERMOD"];
$customerSERNSP = $_GET["customerSERNSP"];
$customerSERPRO = $_GET["customerSERPRO"];
$customerSERVRS = $_GET["customerSERVRS"];
/* Il controllo viene passato ad un altro script PHP per l'aggiornamento dati cliente */
print '<h1>Edit an Employee record:</h1>';
Print 'Server cliente. . . . . . . . . . .'.$customerSERCLI.' '.$customerSERNUM.'
';
Print 'S/N server/Mod./Sist-Part. '.$customerSERSRN.' '.$customerSERNSP.' '.$customerSERMOD.'
';
Print 'Prodotto/Versione. . . . . . . '.$customerSERPRO.' '.$customerSERVRS.'
';
print 'Richiesta effettuata il. . . . . . <input type="text" name="customerSRVDAT">
';
print 'Ora richiesta. . . . . . . . . . . .<input type="text" name="customerSRVORA">
';
print 'Richiesta effettuata da. . . . .<input type="text" name="customerSRVPER">
';
print 'Motivo della chiamata. . . . .<input type="text" name="customerSRVMOT">
';
print '
';
print '<form action="db2_update7.php" method="GET">';
print '<input type="submit" name="action" value="Server clienti" /></form>';
print '<form action="db2_update1.php" method="POST">';
print '<input type="submit" name="action" value="Back " /></form>';
print '<form action="db2_update4.php" method="POST">';
print '<input type="submit" name="close" value="Close " /></form>';
print '<form action="db2_update8.php?customerSRVCLI=' . $customerSERCLI .'
&customerSRVNUM=' . $customerSERNUM . '&customerSRVSRN=' . $customerSERSRN . '
&customerSRVMOD=' . $customerSERNSP . '&customerSRVNSP=' . $customerSERMOD . '
&customerSRVPRO=' . $customerSERPRO . '&customerSRVVER=' . $customerSERVRS . '
" method="POST">';
print '<input type="submit" name="action" value="Insert " /></form>';
print '</form>';
?>
</body>
</html>
PAGINA 2 update8 (chiamato)
<html>
<?php
define("PAGE_TITLE", "Customer Update");
define("PHP_FILE_NAME", "db2_update3.php")
?>
<title><?= PAGE_TITLE . " - " . PHP_FILE_NAME; ?></title>
<body>
<?php
/* Apertura connessione al database*/
include("connection.inc");
/* Reperimento variabile passata dal chiamante con il metodo GET */
$customerSRVCLI = $_GET["customerSRVCLI"];
$customerSRVNUM = $_GET["customerSRVNUM"];
/* Reperimento variabili passate dal chiamante con il metodo POST */
$customerSRVCLI = $_POST["customerSRVCLI"];
$customerSRVNUM = $_POST["customerSRVNUM"];
$customerSRVNSP = $_POST["customerSRVNSP"];
$customerSRVMOD = $_POST["customerSRVMOD"];
$customerSRVSRN = $_POST["customerSRVSRN"];
$customerSRVPRO = $_POST["customerSRVPRO"];
$customerSRVVER = $_POST["customerSRVVER"];
$customerSRVDAT = $_POST["customerSRVDAT"];
$customerSRVORA = $_POST["customerSRVORA"];
$customerSRVPER = $_POST["customerSRVPER"];
$customerSRVMOT = $_POST["customerSRVMOT"];
/* Costruzione dello statement SQL da eseguire */
$sql = "
insert into ACSSI_DAT.SRVRQ00F
(SRVATV,SRVNRA,SRVMAN,SRVDUM,SRVDIM,SRVUTM,SRVUTG, SRVCLI,SRVNUM,SRVPRO,SRVVER,SRVSRN,SRVMOD,
SRVNSP,SRVVOD,SRVVOM,SRVVIS,SRVPER,SRVDAT,SRVORA,S RVMOT,SRVCAS,SRVSOL,SRVUSR,SRVPRR,SRVVRR,
SRVODR,SRVOMR,SRVDAR,SRVF01,SRVF02,SRVF03,SRVF04,S RVF05,SRVDAI,SRVORI,SRVDAF,SRVORF,SRVDUR,
SRVWEK,SRVREL,SRVASP,SRVBLD,SRVPAT)
values
(' ','0',' ','2006-12-30','2006-12-30','web','web',
'$customerSRVCLI','$customerSRVNUM','$customerSRVP RO','$customerSRVVER','$customerSRVSRN',
'$customerSRVMOD','1.1','1.2','codvid','Guarnieri' ,'2006-12-30','00.00.00','Prova MOTIVO',
'S','SOLUZIONE','Guarnieri','RIC','1.1','1.2','1.3 ','2006-12-31','','','','','','2006-12-31',
'00.00.00','2006-12-31','00.00.00','10','20','01','02','03','PATCH') ";
/* Esecuzione diretta dello stament SQL */
$result = db2_exec($dbh, $sql);
/* Errore nell'aggiornamento dati cliente */
if (!$result) {
print '
There was a problem updating the user into the database.</p>';
print '
Echo of dynamically-built sql:
'.$sql.'</p>';
print '&customerSRVMOD';
} else {
/* Aggiornamento dati cliente eseguito con successo */
header("refresh:0 url=db2_update1.php");
}
?>
</body>
</html>
Grazie, ciao
Rispondi quotando
