rendered paste body[QUOTE]<?php//-------------------------------// cerca1 CustomIncludes begininclude ("./common.php");// cerca1 CustomIncludes end//-------------------------------session_start();//===============================// Save Page and File Name available into variables//-------------------------------$filename = "cerca1.php";$template_filename = "cerca1.html";//===============================//===============================//Save the name of the form and type of action into the variables//-------------------------------$sAction = get_param("FormAction");$sForm = get_param("FormName");//===============================// cerca1 Show begin//===============================// Display page//-------------------------------// Load HTML template for this page//-------------------------------$tpl = new Template($app_path);$tpl->load_file($template_filename, "main");//-------------------------------// Load HTML template of Header and Footer//-------------------------------//-------------------------------$tpl->set_var("FileName", $filename);//-------------------------------// Step through each form//-------------------------------Sito_show();Immagini_show();//-------------------------------// Output the page to the browser//-------------------------------$tpl->pparse("main", false);// cerca1 Show end//********************************************************************************//===============================// Display Grid Form//-------------------------------function Immagini_show(){//-------------------------------// Initialize variables //------------------------------- global $tpl; global $db; global $sImmaginiErr; $sWhere = ""; $sOrder = ""; $sSQL = ""; $sFormTitle = "Immagini"; $HasParam = false; $bReq = true; $iRecordsPerPage = 15; $iCounter = 0; $iSort = ""; $iSorted = ""; $sDirection = ""; $sSortParams = ""; $tpl->set_var("TransitParams", "nomesito=" . tourl(get_param("nomesito")) . "&"); $tpl->set_var("FormParams", "nomesito=" . tourl(get_param("nomesito")) . "&"); //-------------------------------// Build WHERE statement//------------------------------- $pnomesito = get_param("nomesito"); if(strlen($pnomesito)) { $HasParam = true; $sWhere = $sWhere . "c.nomesito=" . tosql($pnomesito, "Text") . ""; } else { $bReq = false; } if($HasParam) $sWhere = " WHERE (" . $sWhere . ")";//-------------------------------// Build ORDER BY statement//------------------------------- $iSort = get_param("FormImmagini_Sorting"); $iSorted = get_param("FormImmagini_Sorted"); if(!$iSort) { $tpl->set_var("Form_Sorting", ""); } else { if($iSort == $iSorted) { $tpl->set_var("Form_Sorting", ""); $sDirection = " DESC"; $sSortParams = "FormImmagini_Sorting=" . $iSort . "&FormImmagini_Sorted=" . $iSort . "&"; } else { $tpl->set_var("Form_Sorting", $iSort); $sDirection = " ASC"; $sSortParams = "FormImmagini_Sorting=" . $iSort . "&FormImmagini_Sorted=" . "&"; } }//-------------------------------// Build base SQL statement//------------------------------- $sSQL = "select c.immagine1 as c_immagine1, " . "c.nomesito as c_nomesito " . " from cdflegrei c ";//-------------------------------//-------------------------------// Assemble full SQL statement//------------------------------- $sSQL .= $sWhere . $sOrder;//------------------------------- $tpl->set_var("FormTitle", $sFormTitle);//-------------------------------// Process the parameters for sorting//------------------------------- $tpl->set_var("SortParams", $sSortParams);//-------------------------------//-------------------------------// Process if form has all required parameter//------------------------------- if(!$bReq) { $tpl->set_var("DListImmagini", ""); $tpl->parse("ImmaginiNoRecords", false); $tpl->parse("FormImmagini", false); return; }//-------------------------------//-------------------------------// Execute SQL statement//------------------------------- $db->query($sSQL); $next_record = $db->next_record();//-------------------------------// Process empty recordset//------------------------------- if(!$next_record) { $tpl->set_var("DListImmagini", ""); $tpl->parse("ImmaginiNoRecords", false); $tpl->parse("FormImmagini", false); return; }//-------------------------------//-------------------------------// Initialize page counter and records per page//------------------------------- $iRecordsPerPage = 15; $iCounter = 0;//-------------------------------//-------------------------------// Display grid based on recordset//------------------------------- while($next_record && $iCounter < $iRecordsPerPage) {//-------------------------------// Create field variables based on database fields//------------------------------- $fldimmagine1_URLLink = $db->f("c_immagine1"); $fldimmagine1 = $db->f("c_immagine1"); $next_record = $db->next_record(); //-------------------------------// Replace Template fields with database values//------------------------------- $tpl->set_var("immagine1", $fldimmagine1); $tpl->set_var("immagine1_URLLink", $fldimmagine1_URLLink);//-------------------------------// Process the record separator//------------------------------- if(!$next_record || $iCounter == $iRecordsPerPage - 1) $tpl->set_var("ImmaginiRecordSeparator", ""); else $tpl->parse("ImmaginiRecordSeparator", false);//------------------------------- $tpl->parse("DListImmagini", true);//-------------------------------// Move to the next record and increase record counter//------------------------------- $iCounter++; }//-------------------------------// Finish form processing//------------------------------- $tpl->set_var( "ImmaginiNoRecords", ""); $tpl->parse( "FormImmagini", false);//-------------------------------// Immagini Close Event begin// Immagini Close Event end//-------------------------------}//===============================//===============================// Display Grid Form//-------------------------------function Sito_show(){//-------------------------------// Initialize variables //------------------------------- global $tpl; global $db; global $sSitoErr; $sWhere = ""; $sOrder = ""; $sSQL = ""; $sFormTitle = "Scheda Sito"; $HasParam = false; $bReq = true; $iRecordsPerPage = 15; $iCounter = 0; $iSort = ""; $iSorted = ""; $sDirection = ""; $sSortParams = ""; $tpl->set_var("TransitParams", "nomesito=" . tourl(get_param("nomesito")) . "&"); $tpl->set_var("FormParams", "nomesito=" . tourl(get_param("nomesito")) . "&"); //-------------------------------// Build WHERE statement//------------------------------- $pnomesito = get_param("nomesito"); if(strlen($pnomesito)) { $HasParam = true; $sWhere = $sWhere . "c.nomesito like " . tosql("%".$pnomesito ."%", "Text"); } else { $bReq = false; } if($HasParam) $sWhere = " WHERE (" . $sWhere . ")";//-------------------------------// Build ORDER BY statement//------------------------------- $iSort = get_param("FormSito_Sorting"); $iSorted = get_param("FormSito_Sorted"); if(!$iSort) { $tpl->set_var("Form_Sorting", ""); } else { if($iSort == $iSorted) { $tpl->set_var("Form_Sorting", ""); $sDirection = " DESC"; $sSortParams = "FormSito_Sorting=" . $iSort . "&FormSito_Sorted=" . $iSort . "&"; } else { $tpl->set_var("Form_Sorting", $iSort); $sDirection = " ASC"; $sSortParams = "FormSito_Sorting=" . $iSort . "&FormSito_Sorted=" . "&"; } }//-------------------------------// Build base SQL statement//------------------------------- $sSQL = "select c.botanica as c_botanica, " . "c.comune as c_comune, " . "c.conservazione as c_conservazione, " . "c.geologia as c_geologia, " . "c.interesse as c_interesse, " . "c.nomesito as c_nomesito, " . "c.note as c_note, " . "c.rilevanza as c_rilevanza, " . "c.settori as c_settori, " . "c.toponimo as c_toponimo, " . "c.zoologia as c_zoologia " . " from cdflegrei c ";//-------------------------------//-------------------------------// Sito Open Event begin// Sito Open Event end//-------------------------------//-------------------------------// Assemble full SQL statement//------------------------------- $sSQL .= $sWhere . $sOrder;//------------------------------- $tpl->set_var("FormTitle", $sFormTitle);//-------------------------------// Process the parameters for sorting//------------------------------- $tpl->set_var("SortParams", $sSortParams);//-------------------------------//-------------------------------// Process if form has all required parameter//------------------------------- if(!$bReq) { $tpl->set_var("DListSito", ""); $tpl->parse("SitoNoRecords", false); $tpl->parse("FormSito", false); return; }//-------------------------------//-------------------------------// Execute SQL statement//------------------------------- $db->query($sSQL); $next_record = $db->next_record();//-------------------------------// Process empty recordset//------------------------------- if(!$next_record) { $tpl->set_var("DListSito", ""); $tpl->parse("SitoNoRecords", false); $tpl->parse("FormSito", false); return; }//-------------------------------//-------------------------------// Initialize page counter and records per page//------------------------------- $iRecordsPerPage = 15; $iCounter = 0;//-------------------------------//-------------------------------// Display grid based on recordset//------------------------------- while($next_record && $iCounter < $iRecordsPerPage) {//-------------------------------// Create field variables based on database fields//------------------------------- $fldbotanica = $db->f("c_botanica"); $fldcomune = $db->f("c_comune"); $fldconservazione = $db->f("c_conservazione"); $fldgeologia = $db->f("c_geologia"); $fldinteresse = $db->f("c_interesse"); $fldnomesito = $db->f("c_nomesito"); $fldnote = $db->f("c_note"); $fldrilevanza = $db->f("c_rilevanza"); $fldsettori = $db->f("c_settori"); $fldtoponimo = $db->f("c_toponimo"); $fldzoologia = $db->f("c_zoologia"); $next_record = $db->next_record(); //-------------------------------// Sito Show begin//-------------------------------//-------------------------------// Sito Show Event begin// Sito Show Event end//-------------------------------//-------------------------------// Replace Template fields with database values//------------------------------- $tpl->set_var("nomesito", tohtml($fldnomesito)); $tpl->set_var("comune", tohtml($fldcomune)); $tpl->set_var("toponimo", tohtml($fldtoponimo)); $tpl->set_var("conservazione", tohtml($fldconservazione)); $tpl->set_var("interesse", tohtml($fldinteresse)); $tpl->set_var("settori", tohtml($fldsettori)); $tpl->set_var("rilevanza", tohtml($fldrilevanza)); $tpl->set_var("geologia", tohtml($fldgeologia)); $tpl->set_var("botanica", tohtml($fldbotanica)); $tpl->set_var("zoologia", tohtml($fldzoologia)); $tpl->set_var("note", tohtml($fldnote));//-------------------------------// Process the record separator//------------------------------- if(!$next_record || $iCounter == $iRecordsPerPage - 1) $tpl->set_var("SitoRecordSeparator", ""); else $tpl->parse("SitoRecordSeparator", false);//------------------------------- $tpl->parse("DListSito", true);//-------------------------------// Sito Show end//-------------------------------//-------------------------------// Move to the next record and increase record counter//------------------------------- $iCounter++; }//-------------------------------// Finish form processing//------------------------------- $tpl->set_var( "SitoNoRecords", ""); $tpl->parse( "FormSito", false);//-------------------------------// Sito Close Event begin// Sito Close Event end//-------------------------------}//===============================?>[/QUOTE] [QUOTE]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><!-- DW6 --><head><META name="verify-v1" content="diJZnVyQDnCTHflLwY22QBDpbJoEJFu++yZGFAbrewE=" /><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /><title>Campi Flegrei - Cerca nel DB</title><link rel="stylesheet" type="text/css" media="screen" href="./css1/screenStyle.css"/><link rel="stylesheet" type="text/css" media="print" href="./css1/print.css" /><style type="text/css"><!--.Stile1 {color: #000080}--></style></head><body><center><div id="wrapper"> <div id="header"> <a href="./index.html"> <div id="top"> <h1 id="siteName" class="hide">Cd Campi Flegrei</h1> </div> </a></div><div id="colSx"> </div> <!--end colonnaSx div --> <div id="content"><div id="contentIco"><a href="javascript:printPage()"><span class="Stile1"><img src="./img/ico_stampa.gif" alt="Stampa questa pagina" width="21" height="21" border="0"/></span></a><span class="Stile1"><a href="javascript:window.external.AddFavorite('http://scienzenaturali.unina.it','Cd Campi Flegrei')"><img src="./img/ico_pref.gif" alt="Aggiungi questo sito ai tuoi preferiti" width="21" height="21" border="0"/></a><a href="javascript:history.go(-1)"><img src="./img/ico_back.gif" alt="Torna alla pagina precedente" width="21" height="21" border="0"/></a><a href="./index.html"><img src="./img/ico_home.gif" alt="Torna alla home" width="21" height="21" border="0" /></a></span></div><div id="corpo"> <h2 class="Stile1" id="pageName">Cd Campi Flegrei </h2> <div class="bacheca"> <div class="thumbnail"></div> <div class="thumbnail"></div> <p align="justify" class="articolo"> </p><font size="2"><p>{Header} <table> <tr> <td valign="top"> <!--BeginFormSitoHeader--> <!--EndFormSitoHeader--> <!--BeginFormSito--><table style="border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"> <tr> <td style="background-color: #14B0E4; text-align: center; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080" colspan="1"><a name="Sito"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; font-size: 10pt; color: #FFFFFF; font-weight: bold; text-align: center">{FormTitle}</font></a></td> </tr> <!--BeginDListSito--><tr><td><table width="100%" style="border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Nome del Sito </font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{nomesito} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Comune</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{comune} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Toponimo</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{toponimo} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Stato di Conservazione</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{conservazione} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Interesse del Sito </font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{interesse} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Settori di Interesse </font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{settori} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Rilevanza del Sito </font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{rilevanza} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Geologia</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{geologia} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Botanica</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{botanica} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Zoologia</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{zoologia} </font></td> </tr> <tr> <td style="background-color: #B7E9F9; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt; font-weight: bold">Note</font></td> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">{note} </font></td> </tr></table></td></tr> <!--BeginSitoRecordSeparator--> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"> </td> </tr><!--EndSitoRecordSeparator--> <!--EndDListSito--> <!--BeginSitoNoRecords--> <tr><td colspan="1" style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">No records</font></td></tr> <!--EndSitoNoRecords--> </table> <!--EndFormSito--> <!--BeginFormSitoFooter--> <!--EndFormSitoFooter--> </td> <td valign="top"> <!--BeginFormImmaginiHeader--> <!--EndFormImmaginiHeader--> <!--BeginFormImmagini--><table style="border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"> <tr> <td style="background-color: #14B0E4; text-align: center; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080" colspan="1"><a name="Immagini"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; font-size: 10pt; color: #FFFFFF; font-weight: bold; text-align: center">{FormTitle}</font></a></td> </tr> <!--BeginDListImmagini--><tr><td><table width="100%" style="border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"> <tr> </tr> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><img src="{immagine1_URLLink}"></a></td> </tr></table></td></tr> <!--BeginImmaginiRecordSeparator--> <tr> <td style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"> </td> </tr><!--EndImmaginiRecordSeparator--> <!--EndDListImmagini--> <!--BeginImmaginiNoRecords--> <tr><td colspan="1" style="background-color: #EAF9FD; border-top: 1px solid #000080; border-bottom: 1px solid #000080; border-right: 1px solid #000080; border-left: 1px solid #000080"><font style="font-family: Arial, Tahoma, Verdana, Helvetica; color: #000000; font-size: 8pt">No records</font></td></tr> <!--EndImmaginiNoRecords--> </table> <!--EndFormImmagini--> <!--BeginFormImmaginiFooter--> <!--EndFormImmaginiFooter--> </td> </tr> </table>{Footer} <p class="articolo"> </p> <p class="articolo"> </p> <p class="articolo"><font size="2"></font></p> </font></div><font size="2"> <div class="articolo"> <h3> </h3> </div> </font></div></div><font size="2"> <!--end content --> <!--end colSx --><div id="footer"> <div id="siteInfo"><a href="./credits.htm">Credits</a></div></div> </font></div></center></body></html>[/QUOTE]