You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 

108 lines
3.1 KiB

<?php
session_start();
@include 'cgi-bin/conn.conn';
@include 'cgi-bin/functions';
$dbConn=mysqli_connect($DATAhst,$DATAusr,$DATApwd,$DATAdtb);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html><head><title>FarmaTurni</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="description" content="FarmaTurni">
<meta name="author" content="Token di Carmine De Rosa">
<meta name="generator" content="Kate">
<meta name="keywords" content="FarmaTurni">
<base href="http://<?php echo $_SERVER["HTTP_HOST"];?>/turni/">
<link rel="stylesheet" href="css/style.css">
<link rel="stylesheet" href="css/text.css">
<link rel="stylesheet" href="css/forms.css">
</head><body>
<center>
<br><br>
<table border="0" cellspacing="4" cellpadding="2" width="500" align="center" bgcolor="#ffffff" class="radius">
<?php
$qf=mysqli_query($dbConn,"SELECT farmacie.*,comuni.comune AS C_comune FROM farmacie,comuni WHERE farmacie.comune=comuni.id AND farmacie.id=".$_GET['idf']."");
$rf=mysqli_fetch_array($qf);
$qg=mysqli_query($dbConn,"SELECT * FROM giorni WHERE id=".$_GET['idg']."");
$rg=mysqli_fetch_array($qg);
// if($_GET['tipo']=="Aperto"){
?>
<tr><td align="left" valign="middle" class="title">&nbsp; <b>Farmacia <?php echo $rf['nome'];?></b></td></tr>
<tr><td>
<table border="0" cellspacing="0" cellpadding="4" width="100%">
<tr><td align="left" class="txt_lit_black"><?php echo $rf['indirizzo']." - ".$rf['cap']." - ".$rf['C_comune']."";?></td></tr>
<tr><td align="left" class="txt_lit_black"><?php echo $rf['descrizione'];?></td></tr>
<tr><td align="left" class="txt_lit_black"><?php echo "Tel: ".$rf['telefono']." - Email: ".$rf['email'];?></td></tr>
</table>
<br><br>
</td></tr>
<tr><td align="left" valign="middle" class="title">&nbsp; <b>Orari </b></td></tr>
<tr><td>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
<tr><td align="left"><b>Notte</b></td>
<td align="left"><b>Mattina</b></td>
<td align="left"><b>Pranzo</b></td>
<td align="left"><b>Pomeriggio</b>
</td><td align="left"><b>Sera</b></td>
</tr>
<?php
echo "<tr><td align=\"left\">".$rg['notte']."</td>".
"<td align=\"left\">".$rg['mattina_stato']." dalle ".substr($rg['mattina_from'],0,5)." alle ".substr($rg['mattina_to'],0,5)."</td><td align=\"left\">".$rg['pranzo']."</td>".
"<td align=\"left\">".$rg['pomeriggio_stato']." dalle ".substr($rg['pomeriggio_from'],0,5)." alle ".substr($rg['pomeriggio_to'],0,5)."</td><td align=\"left\">".$rg['sera']."</td></tr>\n";
?>
</table>
<br><br>
</td></tr>
<tr><td align="left" valign="middle" class="title">&nbsp; <b>Reperibilit&agrave; </b></td></tr>
<tr><td>
<table border="0" cellspacing="1" cellpadding="4" width="100%">
<tr><td align="left" class="txt_lit_black"><?php echo $rf['r_indirizzo']." - ".$rf['R_comune']."";?></td></tr>
<tr><td align="left" class="txt_lit_black"><?php echo $rf['r_messaggio'];?></td></tr>
<tr><td align="left" class="txt_lit_black"><?php echo "Tel: ".$rf['r_telefono']."";?></td></tr>
</table>
<?php
// }
?>
</td></tr>
</table>
</center></body></html>
<?php
mysqli_close($dbConn);
?>