echo "<option>" . (date("Y") + 1) . "</option>\n "; } else { echo "<option>" . date("Y") . "</option>\n "; echo "<option selected>" . (date("Y") + 1) . "</option>\n "; } ?> </select> </td> <td id="tdresp" class="title">Capogita</td> <td id="resp"> <?php include_once "lib/db_mysql.php"; $resp = new db_local(); $resp->query("SELECT * FROM anagrafiche WHERE (carica = 'C' OR carica = 'A') AND id >= 1 ORDER BY nome;"); echo "\t<select onchange=\"newass();\" size=\"1\" name=\"resp\">\n"; while ($resp->next_record()) { if (intval($db->record['idresp']) == intval($resp->record['id'])) { $s = "selected "; } echo "\t\t\t<option " . $s . "value=\"" . intval($resp->record['id']) . "\">" . $resp->record['nome'] . " " . $resp->record['cognome'] . "</option>\n"; $s = ""; } ?> </select> </td> </tr> <tr> <td id="tdtipogita" class="title">Tipo di gita</td> <td> <select onchange="cambiaTipogita();" size="1" name="tipogita"> <?php
?> </table> <br> <table width="90%" border=1 align="center" cellpadding="2"> <tr> <td colspan="2" style="color:green" align="center">EVENTI</td> </tr> <tr> <td class="data" width="13%">Data</td> <td class="difficili">Titolo</td> </tr> <?php unset($db); include_once "lib/db_mysql.php"; $db = new db_local(); if ($_GET['limitev'] == '0') { $db->query("SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM eventi WHERE DATE(dataeora) >= CURDATE() AND approvato = 1 ORDER BY dataeora;"); } else { $db->query("SELECT *,UNIX_TIMESTAMP(dataeora) as 'data' FROM eventi WHERE DATE(dataeora) >= CURDATE() AND approvato = 1 ORDER BY dataeora LIMIT 0,10 ;"); } while ($db->next_record()) { echo "<tr>\n" . "\t<td class=\"data\">" . date("d/m/Y", $db->record['data']) . "</td>\n\t" . "\t<td class=\"difficili\"><a class=\"difficili\" href=\"index.php?evid=" . $db->record['id'] . "\">" . $db->record['titolo'] . "</a></td>\n\t" . "</tr>\n"; } $db->close(); ?> </table> </div> <br> <div align= "right"><a href="admin.php" target="_parent"><img alt="Amministrazione" src="img/lucchetto.jpg" width="50" height="50"></a></div> <?php makeTail();
$rowcolorlight = '#004070'; $rowcolor = $rowcolorlight; $headercolor = $rowcolordark; $cellpad = '"1"'; $cellspc = '"3"'; //template config require_once "patTemplate.php"; $design = new patTemplate(); $design->setBasedir('./templates'); $design->readTemplatesFromFile('basic.xml'); $design->addVar("basic", "LANG_USERSONLINE", $lang['usersonline']); $design->addVar("basic", "LANG_QUICKSEARCH", $lang['quicksearch']); $design->addVar("basic", "LANG_EXTENDEDSEARCH", $lang['extendedsearch']); $design->addVar("basic", "LANG_ARTISTBROWSE", $lang['artistbrowser']); $design->addVar("basic", "LANG_ADDLYRICS", $lang['addlyrics']); $design->addVar("basic", "LANG_PREFERENCES", $lang['preferences']); $design->addVar("basic", "LANG_STAFF", $lang['staff']); $design->addVar("basic", "LANG_STATISTICS", $lang['statistics']); $db = new db_local(); $db_user = new db_local(); $db_user->query("SELECT id FROM catusers WHERE name = '{$_COOKIE['user']}' AND pass = '******'pass']}'"); if ($db_user->num_rows() == 0) { $user_id = 0; } else { $db_user->next_record(); $user_id = $db_user->record['id']; } $db_user->close(); $username = isset($_COOKIE['user']) ? $_COOKIE['user'] : '******'; $design->addVar("basic", "USERNAME", $username); unset($output);
function iscr_gita() { if (is_numeric($_GET['iscr'])) { //$message = "Per iscriverti ad una gita devi effettuare il login, inserisci il tuo nome utente e la tua password."; if (file_exists("db_mysql.php")) { include_once "db_mysql.php"; } else { include_once "lib/db_mysql.php"; } $db = new db_local(); $db->query("SELECT UNIX_TIMESTAMP(dataeora) as data FROM gite WHERE id = " . $_GET['iscr'] . " LIMIT 1"); if ($db->next_record()) { /*echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG class.php] iscr gita -- trovata gita</div>\n"; if (date("Y") == date("Y",$db->record['data'])) echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG] iscr gita -- Stesso anno</div>\n"; if (date("n") == date("n",$db->record['data'])) echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG] iscr gita -- Stesso mese</div>\n"; if ((date("j")-date("j",$db->record['data'])) <= 2) echo "<div id=\"msg\" align=\"center\" style=\"color: #FFFFFF\">[DEBUG] iscr gita -- Mancano meno di due giorni e precisamente".((date("j",$db->record['data']))-(date("j")))."</div>\n";*/ if (date("Y") == date("Y", $db->record['data']) && date("n") == date("n", $db->record['data']) && date("j", $db->record['data']) - date("j") <= 1) { makeHead("Gestione Gite", "<meta http-equiv=\"refresh\" content=\"5;url=index.php?id=" . $_GET['iscr'] . "\">"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">Le iscrizioni alla gita sono terminate. Contattare il capogita.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\">Fra 5 secondi sarete rimandati alla gita.</div>\n"; $db->close(); unset($db); makeTail(); exit; } } if ($_POST['nonsocio'] == 1) { //echo "nome=>".$_POST['nome']."< cognome=>".$_POST['cognome']."< tel=>".$_POST['tel1']."< email=>".$_POST['nome']."<"; if (!$_POST['nome'] || !$_POST['cognome'] || !$_POST['email'] || !$_POST['tel1']) { //header("Location: admin.php?iscr=" . $_GET['iscr']); makeHead("Gite"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">Attenzione devi inserire tutti i campi marcati in rosso.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione della gita.</a></div>\n"; $db->close(); unset($db); makeTail(); exit; } if (get_magic_quotes_gpc() == 1) { $nome = htmlentities($_POST['nome']); $cognome = htmlentities($_POST['cognome']); $via = htmlentities($_POST['via']); $tel1 = htmlentities($_POST['tel1']); $cell = htmlentities($_POST['cell']); $comune = htmlentities($_POST['comune']); $sesso = htmlentities($_POST['sesso']); $cap = htmlentities($_POST['cap']); $prov = htmlentities($_POST['prov']); $giorno = htmlentities($_POST['giorno']); $mese = htmlentities($_POST['mese']); $anno = htmlentities($_POST['anno']); $email = htmlentities($_POST['email']); } else { $nome = addslashes(htmlentities($_POST['nome'])); $cognome = addslashes(htmlentities($_POST['cognome'])); $via = addslashes(htmlentities($_POST['via'])); $tel1 = addslashes(htmlentities($_POST['tel1'])); $cell = addslashes(htmlentities($_POST['cell'])); $comune = addslashes(htmlentities($_POST['comune'])); $sesso = addslashes(htmlentities($_POST['sesso'])); $cap = addslashes(htmlentities($_POST['cap'])); $prov = addslashes(htmlentities($_POST['prov'])); $giorno = addslashes(htmlentities($_POST['giorno'])); $mese = addslashes(htmlentities($_POST['mese'])); $anno = addslashes(htmlentities($_POST['anno'])); $email = addslashes(htmlentities($_POST['email'])); } $datanascita = date("Y-m-d G:i:00", mktime(0, 0, 0, intval($mese), intval($giorno), intval($anno))); $db->query("SELECT * FROM anagrafiche WHERE LOWER(nome) LIKE '%" . strtolower($nome) . "%' AND LOWER(cognome) LIKE '%" . strtolower($cognome) . "%' LIMIT 1"); if ($db->next_record()) { makeHead("Gite"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">Attenzione c'è già una persona iscritta con i tuoi stessi dati. Le iscrizioni alle gite per i non soci sono possibili UNA sola volta. Se è la prima volta che ti iscrivi ad una gita, ti prego di contattare il capogita.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='index.php?id=" . $_GET['iscr'] . "'>Ritorna alla gita.</a></div>\n"; $db->close(); unset($db); makeTail(); exit; } if (!$db->query("INSERT INTO anagrafiche (nome,cognome,via,tel1,cell,citta,sesso,cap,prov,datanascita,carica) VALUES ('{$nome}','{$cognome}','{$via}','{$tel1}','{$cell}','{$citta}','{$sesso}','{$cap}','{$prov}','{$datanascita}','NS');")) { makeHead("Errore"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">ERRORE inserimento dati, ti prego di contattare il WebMaster segnalando questo errore.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione.</a></div>\n"; $db->close(); unset($db); makeTail(); exit; } $db->query("SELECT id FROM anagrafiche WHERE nome = '" . $nome . "' AND cognome = '" . $cognome . "' LIMIT 1"); if (!$db->next_record()) { makeHead("Errore"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">ERRORE prima dell'inserimento iscrizione, ti prego di contattare il WebMaster segnalando questo errore.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione.</a></div>\n"; $db->close(); unset($db); makeTail(); exit; } if (!$db->query("INSERT INTO iscrizioni (idgita,idassociato,idresp) VALUES (" . $_GET['iscr'] . "," . $db->record['id'] . "," . $db->record['id'] . ");")) { makeHead("Errore"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #FF0000\">ERRORE inserimento iscrizione, ti prego di contattare il WebMaster segnalando questo errore.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='admin.php?iscr=" . $_GET['iscr'] . "'>Ritorna all'iscrizione.</a></div>\n"; $db->close(); unset($db); makeTail(); exit; } makeHead("Complimenti"); echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px; color: #0000FF\">COMPLIMENTI. Ti sei iscritto alla gita.</div>\n"; echo "<br><br><div id=\"msg\" align=\"center\" style=\"font-size:16px;\"><a style='color: #0000FF;' href='index.php'>Ritorna alle gite.</a></div>\n"; $db->close(); unset($db); makeTail(); exit; } makeHead("Iscrizione"); $db->close(); unset($db); $message = ""; include "lib/check_login.php"; if (!isset($user)) { return; } $user->iscrizione($_GET['iscr']); } else { echo "Errore iscr_gita, nessuna gita selezionata"; } }
<?php //echo "<br> act = $act <br>"; session_start(); $login = $_SESSION['login']; $password = $_SESSION['password']; if ($login == "") { echo "Devi effettuare il login prima."; echo "<br><center>[<a href='http://www.biciedintorni.it/application/admin.php'>Login</a>]</center>"; exit; } include_once "class.php"; include_once "db_mysql.php"; $db = new db_local(); $db->query("SELECT user,email FROM anagrafiche WHERE user = '******';"); if ($db->next_record()) { //echo "--------------".$db->record['email']."<br>"; if ($_POST["password"] != "") { if ($_POST["password"] == $_POST["password2"]) { if (check($login, $_POST["password"])) { if ($_POST["email"] != "") { $strqry = "UPDATE anagrafiche SET passch = passch + 1, pw = '" . $_POST["password"] . "', pass = MD5('" . $_POST["password"] . "'),email = '" . trim($_POST["email"]) . "' WHERE user = '******' LIMIT 1;"; } else { $strqry = "UPDATE anagrafiche SET passch = passch + 1, pw = '" . $_POST["password"] . "', pass = MD5('" . $_POST["password"] . "') WHERE user = '******' LIMIT 1;"; } if ($db->query($strqry)) { $_SESSION['password'] = md5($_POST["password"]); if ($_GET['iscr']) { $variabile = "?iscr=" . $_GET['iscr']; } $script = '' . "<script type=\"text/javascript\">\n" . "\t\t\tfunction ok()\n" . "\t\t\t{\n" . "\t\t\t\talert('Password modificata.');\n" . "\t\t\t\tlocation.replace('http://www.biciedintorni.it/application/admin.php" . $variabile . "');\n" . "\t\t\t}\n" . "\t\t</script>";
<?php include_once "lib/db_mysql.php"; include_once "lib/class.php"; $dbanag2008 = new db_local(); $dbanag = new db_local(); $dbanag2008->query("SELECT * FROM anag2008"); $i = 0; while ($dbanag2008->next_record()) { $dbanag->query("SELECT * FROM anagrafiche WHERE TRIM(nome) LIKE \"%" . trim($dbanag2008->record['nome']) . "%\" AND TRIM(cognome) LIKE \"%" . trim($dbanag2008->record['cognome']) . "%\""); echo "SELECT * FROM anagrafiche WHERE TRIM(nome) LIKE \"%" . trim($dbanag2008->record['nome']) . "%\" AND TRIM(cognome) LIKE \"%" . trim($dbanag2008->record['cognome']) . "%\"<br>"; echo "nrow: " . $dbanag->num_rows() . "<br>"; if ($dbanag->num_rows() == 1 && $dbanag->next_record()) { $dbanag2008->query("SELECT id FROM anag2008 WHERE '" . trim($dbanag->record['nome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(nome)),'%\"') AND '" . trim($dbanag->record['cognome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(cognome)),'%\"')"); echo "SELECT id FROM anag2008 WHERE '" . trim($dbanag->record['nome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(nome)),'%\"') AND '" . trim($dbanag->record['cognome']) . "' LIKE CONCAT(CONCAT('\"%',TRIM(cognome)),'%\"')<br>"; echo "nrow: " . $dbanag2008->num_rows() . "<br>"; if ($dbanag2008->num_rows() == 1 && $dbanag2008->next_record()) { $id = $dbanag2008->record['id']; $dbanag2008->query("DELETE FROM anag2008 WHERE id = " . $id); $dbanag2008->query("SELECT * FROM anag2008 AND id > " . $id); $i++; // "SELECT id FROM anag2008 WHERE 'ciccio' LIKE CONCAT(CONCAT('%',TRIM(nome)),'%') AND 'ciccio' LIKE CONCAT(CONCAT('%',TRIM(cognome)),'%')" } $id = 0; } } echo "Eliminate: {$i} righe.";
<?php require_once 'config.inc.php'; $db = new db_local(); if ($_REQUEST['id'] == "") { $design->addVar("error", "ERROR", "id ist leer!"); //HELP ME! $design->addVar("basic", "PAGECONTENT", $design->getParsedTemplate('error')); $design->displayParsedTemplate('basic'); exit; } $db->query("SELECT comment FROM catusers WHERE id = {$_REQUEST['id']}"); $db->next_record(); $design->addVar("basic", "PAGECONTENT", $db->record['comment']); $design->displayParsedTemplate('basic');
<!-- title>FIAB Torino Bici e Dintorni - gita - <?php echo $db->record['titolo']; ?> </title>--> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"> </head> <body> <div class="container-fluid"> <?php if ($db->next_record()) { $ciscr = new db_local(); if ($ciscr->query("SELECT COUNT(*) AS niscr FROM iscrizioni WHERE idgita = '" . $db->record['id'] . "';", true)) { if ($ciscr->next_record()) { $niscri = $ciscr->record['niscr']; } else { echo "Errore vis_gita 'numero iscritti' iscr, query falsa."; } } $ciscr->close(); unset($ciscr); ?> <div id="tddata">Data: <?php echo substr($db->record['dataeora'], 8, 2) . "/" . substr($db->record['dataeora'], 5, 2) . "/" . substr($db->record['dataeora'], 0, 4); if ($niscri > 0) { echo ", <a href=\"index.php?iscrid=" . $db->record['id'] . "\">Numero iscritti: {$niscri}</a>"; } /*else echo ", Nessun iscritto a questa gita.";*/
function listgruppi() { $db = new db_local(); /*$sqlqry = "select * from gruppimail inner join lnk_gruppi_soci on gruppimail.id = lnk_gruppi_soci.idgruppo";*/ $sqlqry = "select * from gruppimail"; if ($db->query($sqlqry)) { ?> <br> <table style="width:900px;" align="center" border="1"> <tbody> <tr class="title"> <td align="center">Nome Gruppo</td> <td align="center">Descrizione</td> <td align="center">Modifica</td> <td align="center">Elimina</td> </tr> <?php $i = 0; if ($db->num_rows() == 0) { echo "<tr>\n\t<td colspan=\"4\">Nessun gruppo presente nel database</td>\n</tr>"; } else { while ($db->next_record()) { echo "<tr>"; echo "<td>" . $db->record['nome'] . " </td>\n\t\t\t\t\t\t"; echo "<td>" . $db->record['descrizione'] . " </td>\n\t\t\t\t\t\t"; echo "<td><a href=\"admin.php?fun=modgruppo&id=" . $db->record['id'] . "\">Modifica</a></td>\n\t\t\t\t\t\t"; echo "<td><a href=\"\" onclick=\"javascript: eliminagruppo(" . $db->record['id'] . "); return false; \">Elimina</a></td>\n\t\t\t\t\t\t"; echo "</tr>"; } } ?> </tbody> </table> <br> <?php } }
title="Crea Un documento Doc con tutte le gite approvate.">[Scarica doc promemoria gite <?php echo date("Y"); ?> ] </a> </div> <table> <tbody> <tr> <th class="data">Data</th> <th class="facili">Descrizione</th> <th class="facili" align="center">Km</th> <th class="medie">Difficoltà</th> </tr> <?php while ($snipdb->next_record()) { ?> <tr> <td class="data"><?php echo substr($snipdb->record['dataeora'], 8, 2) . "/" . substr($snipdb->record['dataeora'], 5, 2) . "/" . substr($snipdb->record['dataeora'], 0, 4); ?> </td> <td><span class="medie"><a href="http://www.biciedintorni.it/application/index.php?id=<?php echo $snipdb->record['id']; ?> "><?php echo $snipdb->record['titolo']; ?> </a></span></td> <td align="center"><?php
if ($database->next_record()) { if (mail($database->record['email'], $_POST['oggetto'], $_POST['messaggio'], "From: " . $_POST['nome'] . " <" . $_POST['da'] . ">\r\n" . "Reply-To: " . $_POST['da'] . "\r\n" . "X-Mailer: Mailer/Bici&Dintorni")) { echo "<div align=\"center\">Il messaggio è stato inviato correttamente.</div>"; } else { echo "<div align=\"center\">Errore nell'invio del messaggio.(Segnalare il problema al webmaster (Error: mail false)</div>"; } } else { echo "<div align=\"center\">Errore nell'invio del messaggio.(Segnalare il problema al webmaster (Error: nessun utente a cui inviare il messaggio)</div>"; } makeTail(); exit; } if (is_numeric($_GET['id'])) { $database = new db_local(); $database->query("SELECT * FROM anagrafiche WHERE id = '" . $_GET['id'] . "' LIMIT 1;", true); if (!$database->next_record()) { echo "Errore sconosciuto"; makeTail(); return; } ?> <form action="mail.php" method="post" name="emailForm"> <table align="center"> <tr> <td colspan="2">Manda una e-mail a questo contatto:<br><br></td> </tr> <tr> <td>Il tuo nome:</td> <td><input size="50" name="nome" value="<?php echo $user->nome . " " . $user->cognome; ?>
function appgita($id) { if (is_numeric($id)) { include_once "lib/db_mysql.php"; $db = new db_local(); if ($db->query("SELECT approvata FROM gite WHERE id = '" . $id . "' ;")) { if ($db->next_record()) { if ($db->record['approvata'] == '1') { if ($db->query("UPDATE gite SET approvata = '0' WHERE id = '" . $id . "' ;")) { return "Non approvata"; } else { return "appgita (approvazione gita), query falsa."; } } else { if ($db->query("UPDATE gite SET approvata = '1' WHERE id = '" . $id . "' ;")) { return "Approvata"; } else { return "appgita (approvazione gita), query falsa."; } } } else { return "appgita (approvazione gita), gita non esistente."; } } else { return "appgita (approvazione gita), query select falsa."; } $db->close(); unset($db); } else { return "nessun id specificato."; } }
function listass() { $db = new db_local(); if ($this->matricola == 0) { $sqlqry = "SELECT * FROM anagrafiche ORDER BY cognome;"; } else { switch ($this->carica) { case 'A': case 'S': $sqlqry = "SELECT * FROM anagrafiche ORDER BY cognome;"; //break; } } if ($db->query($sqlqry)) { ?> <table align="center" border="1"> <tbody> <tr> <td align="center" colspan="3">Lista associati.</td> <td align="center" colspan="3"><a href="admin.php?fun=listaass" title="Lista di tutti gli associati">Lista di tutti gli associati</a></td> </tr> <tr> <td align="center">Cognome</td> <td align="center">Nome</td> <td align="center">UserName</td> <td align="center">Indirizzo</td> <td align="center">Tel1</td> <td align="center">Cell</td> <td align="center">E-Mail</td> <td align="center">Carica</td> <td align="center">Tipo Socio</td> </tr> <?php $i = 0; if ($db->num_rows() == 0) { echo "<tr>\n\t<td colspan=\"6\">Nessun associato presente nel database</td>\n</tr>"; } else { while ($db->next_record()) { echo "\t\t\t\t\t<tr>\n\t\t\t\t\t\t<td>" . $db->record['cognome'] . "</td>\n\t\t\t\t\t\t"; //echo "<td><a target=\"_blank\" href=\"index.php?id=".$db->record['id']."\">".$db->record['titolo']."</a></td>\n "; echo "<td>" . $db->record['nome'] . "</td>\n\t\t\t\t\t\t"; echo "<td>" . $db->record['user'] . "</td>\n\t\t\t\t\t\t"; echo "<td>" . $db->record['via'] . "</td>\n\t\t\t\t\t\t"; echo "<td>"; if ($db->record['difficolta'] == 'F') { echo "Facile"; } elseif ($db->record['difficolta'] == 'M') { echo "Media"; } elseif ($db->record['difficolta'] == 'U') { echo "Facile per famiglie"; } else { echo "Impegnativa"; } echo "</td>\n\t\t\t\t\t\t"; echo "<td><a href=\"admin.php?fun=modgita&id=" . $db->record['id'] . "\">Modifica</a></td>\n\t\t\t\t\t\t"; if ($this->carica != 'A') { echo "<td>Elimina</td>\n\t\t\t\t\t"; echo "<td>Approva</td>\n\t\t\t\t\t</tr>\n"; } else { echo "<td><a href=\"\" onclick=\"javascript: elimina(" . $db->record['id'] . "); return false; \">Elimina</a></td>\n\t\t\t\t\t\t"; if ($db->record['approvata'] == '1') { $str = 'Approvata'; } else { $str = 'Non approvata'; } echo "<td><a href=\"\" id=\"linkapp" . $i++ . "\" onclick=\"approva(" . $db->record['id'] . ",'linkapp" . ($i - 1) . "'); return false;\">" . $str . "</a></td>\n\t\t\t\t\t\t"; } } } ?> </tbody> </table> <?php } $db->close(); unset($db); }