ordine_farmacisti/turni/admin/sheet/farmacie/elimina.php

<br>

<?php
if($_POST['go']){

$q1=mysqli_query($dbConn, "DELETE FROM farmacie WHERE id='".$_POST['id']."'");
$q2=mysqli_query($dbConn, "DELETE FROM giorni WHERE farmacia='".$_POST['id']."'");
$q3=mysqli_query($dbConn, "DELETE FROM turni WHERE farmacia='".$_POST['id']."'");
$q4=mysqli_query($dbConn, "DELETE FROM turni_tmp WHERE farmacia='".$_POST['id']."'");


if($q1 && $q2 && $q3 && $q4){
@include 'res_ok.php';
}else{
@include 'res_ko.php';
}


}else{
?>

<form method="post">
<table border="0" cellspacing="2" cellpadding="0" width="750">
<tr><td align="left" valign="middle" class="title">&nbsp; <b>Ambito territoriale</b></td></tr>
<tr><td width="750"><select name="ida" style="width: 750px" onChange="this.form.submit()">
<option value=""> - Seleziona l'ambito territoriale - </option>
<?php
$qa=mysqli_query($dbConn, "SELECT * FROM ambiti ORDER BY descrizione");
while($ra=mysqli_fetch_array($qa)){
echo "<option value=\"".$ra['id']."\" ";
if($ra['id']==@$_POST['ida']){echo "selected";}
echo ">".$ra['descrizione']."</option>\n";
}
?>
</select></td></tr>

<?php
if(@$_POST['ida']){
$qac=mysqli_query($dbConn, "SELECT comuni FROM ambiti WHERE id='".@$_POST['ida']."'");
$rac=mysqli_fetch_array($qac);
?>
<tr><td align="center" valign="top">&nbsp;</td></tr>
<tr><td align="left" valign="middle" class="title">&nbsp; <b>Farmacia</b></td></tr>
<tr><td width="750"><select name="id" style="width: 750px" onChange="this.form.submit()">
<option value=""> - Seleziona la farmacia - </option>
<?php
$q=mysqli_query($dbConn, "SELECT * FROM farmacie WHERE comune IN(".str_replace("#",",",$rac['comuni']).") ORDER BY nome");
while($r=mysqli_fetch_array($q)){
echo "<option value=\"".$r['id']."\" ";
if($r['id']==@$_POST['id']){echo "selected";}
echo ">".$r['nome']."</option>\n";
}
?>
</select></td></tr>

<?php
}
?>

<tr><td align="center" valign="top">&nbsp;</td></tr>
</table></form>

<?php
if(@$_POST['id']){
$q=mysqli_query($dbConn, "SELECT * FROM farmacie WHERE id='".@$_POST['id']."'");
$r=mysqli_fetch_array($q);
?>

<form method="post">
<input type="hidden" name="id" value="<?php echo $r['id'];?>">
<table border="0" cellspacing="2" cellpadding="2" width="750">
<tr><td align="left" valign="middle" class="title" colspan="4">&nbsp; <b>Elimina farmacia</b></td></tr>
<tr><td width="150" valign="top" align="right" class="txt_lit_grey">Farmacia: </td><td width="275"><?php echo $r['nome'];?></td>
<td width="150" valign="top" align="right" class="txt_lit_grey" rowspan="2">Descrizione: </td><td width="275" rowspan="2"><?php echo $r['descrizione'];?></td>
</tr>

<tr><td width="150" valign="top" align="right" class="txt_lit_grey">Indirizzo: </td><td width="275"><?php echo $r['indirizzo'];?></td></tr>
<tr><td width="150" valign="top" align="right" class="txt_lit_grey">Comune: </td><td width="275">

<?php
$qc=mysqli_query($dbConn, "SELECT * FROM comuni  WHERE id='".$r['comune']."'");
$rc=mysqli_fetch_array($qc);
echo $rc['comune'];
?>

</td><td width="150" valign="top" align="right" class="txt_lit_grey">CAP: </td><td width="275" align="left"><?php echo $r['cap'];?></td>
</tr>

<tr><td width="150" valign="top" align="right" class="txt_lit_grey">ASL: </td><td width="275">
<?php echo $r['asl'];?>
</td><td width="150" valign="top" align="right" class="txt_lit_grey">Ambito: </td><td width="275">

<?php
$qd=mysqli_query($dbConn, "SELECT * FROM ambiti WHERE id='".$r['ambito']."'");
$rd=mysqli_fetch_array($qd);
echo $rd['descrizione'];
?>
</td>
</tr>

<tr><td width="150" valign="top" align="right" class="txt_lit_grey">Telefono: </td><td width="275"><?php echo $r['telefono'];?></td>
<td width="150" valign="top" align="right" class="txt_lit_grey">E-Mail: </td><td width="275"><?php echo $r['email'];?></td>
</tr>


<tr><td align="center" valign="top" colspan="4">&nbsp;</td></tr>
<tr><td width="750" align="right" colspan="4"><input type="submit" name="go" value="  Elimina farmacia  " class="button"></td></tr>
<tr><td align="center" valign="top" colspan="4">&nbsp;</td></tr>

</table>
</form>



<?php
}}
?>