Codice PHP:
<? session_start(); require_once('Connections/diserbo.php'); $currentPage = $HTTP_SERVER_VARS['PHP_SELF']; $maxRows_Recordset1 = 25; $pageNum_Recordset1 = 0; if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) { $pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1']; } $startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1; $varcoltura_Recordset1 = "%"; if (isset($_POST['coltura'])) { $varcoltura_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['coltura'] : addslashes($_POST['coltura']); $_SESSION['varcoltura_Recordset1'] = $varcoltura_Recordset1; } if (isset($_SESSION['varcoltura_Recordset1'])) { $varcoltura_Recordset1 = $_SESSION['varcoltura_Recordset1']; } $varepoca_Recordset1 = "%"; if (isset($_POST['epoca'])) { $varepoca_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['epoca'] : addslashes($_POST['epoca']); $_SESSION['varepoca_Recordset1'] = $varepoca_Recordset1; } if (isset($_SESSION['varepoca_Recordset1'])) { $varepoca_Recordset1 = $_SESSION['varepoca_Recordset1']; } $varpa_Recordset1 = "%"; if (isset($_POST['pa'])) { $varpa_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['pa'] : addslashes($_POST['pa']); $_SESSION['varpa_Recordset1'] = $varpa_Recordset1; } if (isset($_SESSION['varpa_Recordset1'])) { $varpa_Recordset1 = $_SESSION['varpa_Recordset1']; } $varinfestante_Recordset1 = "%"; if (isset($_POST['infestante'])) { $varinfestante_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['infestante'] : addslashes($_POST['infestante']); $_SESSION['varinfestante_Recordset1'] = $varinfestante_Recordset1; } if (isset($_SESSION['varinfestante_Recordset1'])) { $varinfestante_Recordset1 = $_SESSION['varinfestante_Recordset1']; } mysql_select_db($database_diserbo, $diserbo); $query_Recordset1 = sprintf("SELECT DISTINCT tesi.id_tesi, colture.coltura, pa.pa, formulato, epoche.epoche, pa_tesi.dose, fito_s.Fito_ewrs, eff_s.eff_ewrs FROM anni, colture, tesi, fito_s, eff_s, epoche, pa_tesi, pa, efficacia, fito, infestanti WHERE anni.id_anno = tesi.rif_anno AND colture.id_coltura = tesi.rif_coltura AND tesi.rif_fito_s = fito_s.id_fito_s AND epoche.id_epoche = pa_tesi.rif_epoca AND pa_tesi.rif_tesi = tesi.id_tesi AND infestanti.id_infestanti = efficacia.rif_infestante AND pa_tesi.rif_pa = pa.id_pa AND eff_s.id_eff_s = tesi.rif_eff_s AND efficacia.rif_eff = tesi.id_tesi AND fito.rif_fito = tesi.id_tesi AND colture.id_coltura LIKE '%s' AND pa.id_pa LIKE '%s' AND infestanti.id_infestanti LIKE '%s' AND epoche.id_epoche LIKE '%s' ORDER BY tesi.id_tesi", $varcoltura_Recordset1,$varpa_Recordset1,$varinfestante_Recordset1,$varepoca_Recordset1); $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1); $Recordset1 = mysql_query($query_limit_Recordset1, $diserbo) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) { $totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1']; } else { $all_Recordset1 = mysql_query($query_Recordset1); $totalRows_Recordset1 = mysql_num_rows($all_Recordset1); } $totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1; $queryString_Recordset1 = ""; if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) { $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_Recordset1") == false && stristr($param, "totalRows_Recordset1") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_Recordset1 = "&" . implode("&", $newParams); } } $queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1); $record = "SELECT COUNT(DISTINCT tesi.id_tesi) FROM anni, colture, tesi, fito_s, eff_s, epoche, pa_tesi, pa, efficacia, fito, infestanti WHERE anni.id_anno = tesi.rif_anno AND colture.id_coltura = tesi.rif_coltura AND tesi.rif_fito_s = fito_s.id_fito_s AND epoche.id_epoche = pa_tesi.rif_epoca AND pa_tesi.rif_tesi = tesi.id_tesi AND infestanti.id_infestanti = efficacia.rif_infestante AND pa_tesi.rif_pa = pa.id_pa AND eff_s.id_eff_s = tesi.rif_eff_s AND efficacia.rif_eff = tesi.id_tesi AND fito.rif_fito = tesi.id_tesi AND colture.id_coltura LIKE '$varcoltura_Recordset1' AND pa.id_pa LIKE '$varpa_Recordset1' AND infestanti.id_infestanti LIKE '$varinfestante_Recordset1' AND epoche.id_epoche LIKE '$varepoca_Recordset1'"; $query_record = mysql_query($record, $diserbo) or die(mysql_error()); $row_query_record = mysql_result($query_record,0,0); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>HESDBASE</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="stili/menu.css" rel="stylesheet" type="text/css"> <style type="text/css"> </style> <style type="text/css"> </style> </head> <body> <div align="center"> <table width="1022" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF"> <tr> <td height="100" colspan="2" valign="middle"> <div align="center">[img]immagini/Logo_Universita.gif[/img]</div></td> <td colspan="3" valign="top" bgcolor="#FFFFFF">[img]immagini/titolo.gif[/img]</td> <td colspan="2" valign="middle"> <div align="center">[img]immagini/logofac.gif[/img]</div></td> </tr> <tr> <td width="91" height="19"></td> <td width="26"></td> <td width="16"></td> <td width="746"></td> <td width="27"></td> <td width="36"></td> <td width="80"></td> </tr> <tr> <td height="53"></td> <td colspan="5" valign="top"> <table width="100%" border="1" bordercolor="#99CC66"> <tr align="left" valign="middle" class="titricerca"> <td width="20" height="28" align="center" class="titricerca">[b]ID[/b]</td> <td width="100">[b]Coltura[/b]</td> <td width="150">[b]Principio Attivo[/b]</td> <td width="120">Formulazione</td> <td width="120">[b]Epoca trattamento[/b]</td> <td width="80">[b]Dose PA g o ml/ha[/b]</td> <td width="100">[b]Fitotossicità PA
(scala EWRS)[/b]</td> <td width="100">[b]Efficacia PA
(scala EWRS)[/b]</td> </tr> <?php do { ?> <tr align="left" valign="middle"> <td height="23" align="center" class="ricerca">[url="dettaglio.php?varid=<?php echo $row_Recordset1['id_tesi']; ?>"]<?php echo $row_Recordset1['id_tesi']; ?>[/url]</td> <td class="ricerca"><?php echo $row_Recordset1['coltura']; ?></td> <td class="ricerca"><?php echo $row_Recordset1['pa']; ?></td> <td class="ricerca"><?php echo $row_Recordset1['formulato']; ?></td> <td class="ricerca"><?php echo $row_Recordset1['epoche']; ?></td> <td class="ricerca"><?php echo $row_Recordset1['dose']; ?></td> <td class="ricerca"><?php echo $row_Recordset1['Fito_ewrs']; ?></td> <td class="ricerca"><?php echo $row_Recordset1['eff_ewrs']; ?></td> </tr> <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </table></td> <td></td> </tr> <tr> <td height="19"></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td height="19"></td> <td></td> <td></td> <td valign="top"> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr valign="middle" class="ricerca"> <td width="70" height="19" valign="top"> <div align="center">[url="<?php printf("]">Primo[/url]</div></td> <td width="70" valign="top"> <div align="center">[url="<?php printf("]">Indietro[/url]</div></td> <td width="468" valign="top"> <div align="center">n° tesi trovate: <?php echo $row_query_record?> </div></td> <td width="65" valign="top"> <div align="center">[url="<?php printf("]">Avanti[/url]</div></td> <td width="73" valign="top"> <div align="center">[url="<?php printf("]">Ultimo[/url]</div></td> </tr> </table></td> <td></td> <td></td> <td></td> </tr> <tr> <td height="13"></td> <td></td> <td></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr> <td height="30" colspan="7" valign="top" bgcolor="#FFFFFF" class="Piedipagina">
Università degli studi di Perugia - Facoltà di Agraria - Dipartimento di Scienze Agrarie e Ambientali sezione di Agronomia e Coltivazioni Erbacee - Borgo XX giugno, 74 - 06100 Perugia</p></td> </tr> </table> </div> </body> </html> <?php mysql_free_result($Recordset1); ?>