codice:
<?
include ("top_foot.inc.php");
include ("config.inc.php");
top();
$tabella_fun = "funzioni";
$tabella_rub = "rubrica";
$start = $_REQUEST['start'];
$connessione = mysql_connect($db_host,$db_user,$db_password)
or die("Impossibile connettere il server");
$db = mysql_select_db($db_name, $connessione)
or die("Non connesso con il database");
$sql1 = "SELECT * FROM funzioni ORDER BY funzioni";
$sql2 = "SELECT * FROM rubrica";
$ris_fun = mysql_query($sql1,$connessione)
or die("Impossibile interrogare");
while ($riga = mysql_fetch_array($ris_fun)) {
$id = $riga['id'];
$funzioni = $riga['funzioni'];
$sql_temp = "$sql2 WHERE idfun = $id ORDER BY cognome";
$ris_rub = mysql_query($sql_temp,$connessione)
or die("Impossibile ottenere l'accesso alle funzioni");
while ($rrub = mysql_fetch_array($ris_rub)) {
$lid = $rrub['id'];
$lidfun = $rrub['idfun'];
$lnome = $rrub['nome'];
$lcognome = $rrub['cognome'];
$lind = $rrub['indirizzo'];
$lcap = $rrub['cap'];
$lloc = $rrub['localita'];
$ltelcasa = $rrub['telefonocasa'];
$lteluff = $rrub['telefonoufficio'];
$lcell = $rrub['cellulare'];
$lmail = $rrub['email'];
$ldata = $rrub['dataimmissione'];
if ($ltelcasa=="") {
$ltelcasa="*";
}
if ($lteluff=="") {
$lteluff="*";
}
if ($lcell=="") {
$lcell="*";
}
if ($lmail=="") {
$lmail="*";
}
$tbl .="<tr>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\" size=\"2\">$lcognome $lnome</td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\" size=\"2\">$lcap $lloc - $lind</td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\"size=\"2\"><center>$ltelcasa</center></td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\"size=\"2\"><center>$lteluff</center></td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\"size=\"2\"><center>$lcell</center></td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\" size=\"2\"><center><a href=\"mailto:$lmail\">$lmail</a></center></td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\"size=\"2\"><center>$ldata</center></td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\"size=\"2\"><center>$funzioni</center></td>
<td><font color=\"#0000FF\" face=\"Arial, Helvetica, sans-serif\"><a href=\"#\" onClick=\"window.open('modifica.php?id_rub=$lid', 'WindowB', 'width=600,height=300,scrollbars=no');\">
<p align=\"center\">M</center></a></td></tr>";
// $progr++;
}
}
?>
<html>
<head>
<title><? echo "$page_title"; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#CCCCCC">
<div align="center">
<table width="68%" border="1">
<tr>
<td width="44%" height="24" align="center">
<?
$step = 2;
//$start = $_REQUEST['start'];
$connessione = mysql_connect($db_host,$db_user,$db_password)
or die("Impossibile connettere il server");
$db = mysql_select_db($db_name, $connessione)
or die("Non connesso con il database");
if (!isset($start) OR $start<0) {
$start= 0;
}
//conta record per pagina e numero totale record
$sql = "SELECT * FROM rubrica ORDER BY cognome LIMIT $start,$step";
$query = "select count(*) as iscritti from rubrica";
//$query assume il valore di una query MySQL
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$test="<font face=\"Arial\">Numero totale soccorritori registrati: $row[iscritti]</font>";
$risultato = @mysql_query($sql,$connessione)
or die(mysql_error() . "Impossibile leggere i dati del database!");
if ($start>0)
{ $start_back = $start - $step;
echo "precedenti</font>";
}
$query = "SELECT count(*) AS tot FROM rubrica";
$result = mysql_query($query, $connessione);
$row = mysql_fetch_array($result);
$pages = intval(($row[tot]-1) / $step)+1;
for ($i=0; $i<$pages AND $i<20; $i++)
{ $start_page = $i * $step;
echo " <font face=\"Tahoma\"><a href=index.php?start=$start_page>" . ($i+1) . "</font></a> ";
}
if ($start + $step < $row[tot])
{ $start_next = $start + $step;
echo "successivi</font>";
}
?>
</td>
<td width="34%"><p align="center"><font size="2" face="Arial, Helvetica, sans-serif"><a href="admin.php">Torna
a inserisci soccorritore</a></font></p></td>
<td width="22%"><div align="center"><font size="2" face="Arial, Helvetica, sans-serif"><a href="http://www.trevallisoccorso.ch/user/members">Home
area utenti</a></font></div></td>
</tr>
</table>
</div>
<div align="center">
<table width="100%" border="4" bgcolor="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td width="14%"> <div align="center"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">Cognome
e Nome</font></div></td>
<td width="19%"> <div align="center"><font color="#FF0000" size="2"><font face="Arial, Helvetica, sans-serif">Indirizzo</font></font></div></td>
<td width="8%"> <div align="center"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">Abitazione</font></div></td>
<td width="8%"> <div align="center"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">Ufficio</font></div></td>
<td width="8%"> <div align="center"><font color="#FF0000" size="2" face="Arial, Helvetica, sans-serif">Cellulare</font></div></td>
<td width="13%"> <div align="center"><font color="#FF0000" size="2"><font face="Arial, Helvetica, sans-serif">E-Mail</font></font></div></td>
<td width="6%"> <div align="center"><font color="#FF0000" size="2"><font face="Arial, Helvetica, sans-serif">Regist.</font></font></div></td>
<td width="4%"><div align="center"><font color="#FF0000" size="2"><font face="Arial, Helvetica, sans-serif">Funzione</font></font></div></td>
<td width="4%"></td>
</tr>
<? echo "$tbl"; ?>
</table>
<? echo "$test"; ?>
</div>
</p>
</body>
</html>
Rispondi quotando