query update e delete

[mioser]

Salve a tutti

avrei la necessita di registrare delle modifiche ad una tabella mysql con dati presi dal form, ma le funzioni di update e quelle di delete dei dati non vanno a buon fine.

<div class="row">
<div class="box col-md-12">
<div class="box-inner">
<div class="box-header well" data-original-title="">
<h2><i class="glyphicon glyphicon-edit"></i> Form Sale</h2>

<div class="box-icon">
<a href="#" class="btn btn-minimize btn-round btn-default"><i
class="glyphicon glyphicon-chevron-up"></i></a>
<a href="#" class="btn btn-close btn-round btn-default"><i
class="glyphicon glyphicon-remove"></i></a>
</div>
</div>

<div class="box-content">
<form name="FORM" id="FORM" onSubmit="return controllo();" action="" method="POST">
<div class="control-group">
<label class="control-label" for="ID">Id</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Id" class="form-control" name="ID" class="form-control" type="text" value="<?echo $ID?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="SALA">Sala</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Sala" class="form-control" name="SALA" class="form-control" type="text" value="<?echo $SALA?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="INDIRIZZO">Indirizzo</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Indirizzo" class="form-control" name="INDIRIZZO" class="form-control" type="text" value="<?echo $INDIRIZZO?>">
</div></div><p>

<div class="control-group">
<label class="control-label" for="CIVICO">Civico</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Civico" class="form-control" name="CIVICO" class="form-control" type="text" value="<?echo $CIVICO?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="CITTA">Citta</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Citta" class="form-control" name="CITTA" class="form-control" type="text" value="<?echo $CITTA?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="CAP">Cap</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Cap" class="form-control" name="CAP" class="form-control" type="text" value="<?echo $CAP?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="PROVINCIA">Provincia</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Provincia" class="form-control" name="PROVINCIA" class="form-control" type="text" value="<?echo $PROVINCIA?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="REGIONE">Regione</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Regione" class="form-control" name="REGIONE" class="form-control" type="text" value="<?echo $REGIONE?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="TELEFONO">Telefono</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Telefono" class="form-control" name="TELEFONO" class="form-control" type="text" value="<?echo $TELEFONO?>">
</div></div><p>
<div class="control-group">
<label class="control-label" for="EMAIL">Email</label>
<div class="input-group col-md-4">
<span class="input-group-addon"><i class="glyphicon glyphicon-user blue"></i></span>
<input placeholder="Email" class="form-control" name="EMAIL" class="form-control" type="text" value="<?echo $EMAIL?>">
</div></div><p>
<br>

<input class="btn btn-default" name="opt" type="hidden" value="editsala1">
<input class="btn btn-default" name="ids" type="hidden" value="<?=$ID?>">
<input class="btn btn-default" name="" type="submit">

</form></div></div></div></div>







<? }

// edit db Save

if("editsala1" == $_REQUEST['opt']) {
include_once ("config.php");


$ID = $_REQUEST['ids'];
$SALA = $_REQUEST['SALA'];
$INDIRIZZO = $_REQUEST['INDIRIZZO'];
$CIVICO = $_REQUEST['CIVICO'];
$CITTA = $_REQUEST['CITTA'];
$CAP = $_REQUEST['CAP'];
$PROVINCIA = $_REQUEST['PROVINCIA'];
$REGIONE = $_REQUEST['REGIONE'];
$TELEFONO = $_REQUEST['TELEFONO'];
$EMAIL = $_REQUEST['EMAIL'];



$query = "UPDATE sale SET SALA='".$SALA."', INDIRIZZO='".$INDIRIZZO."', CIVICO='".$CIVICO."', CITTA='".$CITTA."',
CAP='".$CAP."', PROVINCIA='".$PROVINCIA."', REGIONE='".$REGIONE."', TELEFONO='".$TELEFONO."', EMAIL='".$EMAIL."' WHERE ID ='$ID'";
$update = mysqli_query($conn, $query);

?><script language="javascript" type="text/javascript"> document.location="crea.php?opt=listsale"; </script><?
}

//db Del
if("delsala" == $_REQUEST['opt']) {
$ID = $_REQUEST['id'];
include_once ("config.php");


$query = "DELETE FROM sale WHERE ID = '".$ID."'";
$delete = mysqli_query ($conn,$query);

?>
<script language="javascript" type="text/javascript"> document.location="crea.php?opt=listsale"; </script>
<?

} ?>










<? } ?>