ciao a tutti,
l'inserimento e la cancellazione dei dati nel db mi funziona correttamente ma la modifica no, dove ho sbagliato?
Codice PHP:<?
if ($pagina==1){
$sql = "INSERT INTO a_corsi_materie (id_corsi, id_materia1, id_materia2, id_materia3, id_materia4, id_materia5, id_materia6, id_materia7, id_materia8, id_materia9, id_materia10, id_materia11)
VALUES ('$id_corsi', '$id_materia1', '$id_materia2', '$id_materia3', '$id_materia4', '$id_materia5', '$id_materia6', '$id_materia7', '$id_materia8', '$id_materia9', '$id_materia10', '$id_materia11')";
mysql_query($sql,$conn) or die (mysql_error() );
$msg = "corso inserito nel database";
}
elseif ($pagina==2){
$sql = "SELECT * FROM a_corsi WHERE id_corsi=$corso";
$result = mysql_query($sql,$conn);
$row = mysql_fetch_array($result);
}
elseif ($pagina==3){
$sql = "UPDATE a_corsi_materie SET id_corsi='$id_corsi', id_materia1='$id_materia1', id_materia2='$id_materia2', id_materia3='$id_materia3', id_materia4='$id_materia4', id_materia5='$id_materia5', id_materia6='$id_materia6', id_materia7='$id_materia7', id_materia8='$id_materia8', id_materia9='$id_materia9', id_materia10='$id_materia10', id_materia11='$id_materia11' WHERE id_corsi=$id";
mysql_query($sql,$conn) or die (mysql_error() );
$msg = "modifiche effettuate";
}
?>
<?
if ($delete){
$sql2 = "DELETE FROM a_corsi_materie WHERE id_corsi=$delete";
mysql_query($sql2,$conn) or die (mysql_error() );
$msg = "corso eliminato";
}
?>Codice PHP:<form enctype="multipart/form-data" name="form" action="<?=$PHP_SELF?>" method="get">
<?php
$query3 = "SELECT * FROM a_corsi_materie
WHERE id_corsi = $corso";
$result3 = mysql_query($query3, $conn) or die (mysql_error() );
$row3 = mysql_fetch_array($result3);?>
<select name="id_materia1">
<option value="" selected="selected">materia non selezionata</option>
<?php
$query4 = "SELECT * FROM a_materie ORDER BY nome_materia";
$result4 = mysql_query($query4, $conn) or die (mysql_error() );
while($row4 = mysql_fetch_array($result4)) { ?>
<option value="<?=$row4["id_materie"]?>" <?if ($row3[id_materia1]==$row4["id_materie"]){echo "selected";}?>><?=$row4["nome_materia"]?></option><?
}
?>
</select>
<select name="id_materia2">
<option value="" selected="selected">materia non selezionata</option>
<?php
$result4 = mysql_query($query4, $conn) or die (mysql_error() );
while($row4 = mysql_fetch_array($result4)) { ?>
<option value="<?=$row4["id_materie"]?>" <?if ($row3[id_materia2]==$row4["id_materie"]){echo "selected";}?>><?=$row4["nome_materia"]?></option><?
}
?>
</select>
ecc...
<input type="hidden" name="id" value="<?=$corso?>">
<input type="hidden" name="pagina" value="3">
<input name="submit2" type="submit" class="pulsante" value="modifica">
</form>
Rispondi quotando
