← Back
Editing: stagioni_ed.php
<?php #______________________________________________________________________# ### made with SmaDIB: Smart Database Interface Builder 0.4.0 ### ### by Smartmedia 2000 http://www.smartmedia2000.it/ ### ### info email: smadib@smartmedia2000.it ### ###___###___###___###___###____###____###____###___###___###___###___### require_once ("../funct.php"); require_once ("sess.php"); require_once ("conn.php"); $ptitolo = "Stagioni"; $table = "stagioni"; $html = "y"; require_once ("testacoda.php"); $query = new doQuery(); $anno = $_REQUEST['anno']; $fine = $_REQUEST['fine']; $numero = $_REQUEST['numero']; $novuoto = array ('anno','fine','numero'); $numeroar = array ('','Prezzo unico','2 Stagioni','3 Stagioni','4 Stagioni','5 Stagioni','6 Stagioni','7 Stagioni','8 Stagioni','9 Stagioni','10 Stagioni','Min - Max','Bassa/Alta','Bassa/Media/Alta','Bassa/Media/Alta/Altissima'); if ($az=="canc") { $rows = $query->freeQuery ("SELECT `id` AS `id_listino` FROM `listini` WHERE `id_stagione` = '$id'", 0); foreach ($rows as $i=>$row) $query->freeQuery ("DELETE FROM `prezzi` WHERE `id_listino` = '".$row->id_listino."'", 0); $query->freeQuery ("DELETE FROM `listini` WHERE `id_stagione` = '$id'", 0); $query->freeQuery ("DELETE FROM `periodi` WHERE `id_stagione` = '$id'", 0); $query->delete (); header("Location: ".$_SERVER['PHP_SELF']); } $queryAr = array ('anno'=>$anno, 'fine'=>data2date($fine), 'numero'=>$numero, 'nome_it'=>$nome_it, 'nome_en'=>$nome_en, 'nome_de'=>$nome_de, 'nome_fr'=>$nome_fr, 'nome_es'=>$nome_es, 'nome_ne'=>$nome_ne, 'nome_sv'=>$nome_sv, 'testo_it'=>$testo_it, 'testo_en'=>$testo_en, 'testo_de'=>$testo_de, 'testo_fr'=>$testo_fr, 'testo_es'=>$testo_es, 'testo_ne'=>$testo_ne, 'testo_sv'=>$testo_sv); if ($op == "ds") $query->insert ($queryAr, $novuoto); else if ($op == "up") $query->update ($queryAr, $novuoto); if ($az=="ed") { $row = $query->selectById(1); $id = $row['id']; $valop = "up"; $numero = $row['numero']; $numerosel[$numero] = "selected"; $fine = date2data($row['fine']); } else $valop = "ds"; $elenco.= "<tr bgcolor=\"#EEEEEE\"> <form name=\"form1\" method=\"post\" action=\"".$_SERVER['PHP_SELF']."\" > <td align=\"center\" width=\"30\"> </td> <td><select name=\"anno\"><option value=\"".$row['anno']."\">".$row['anno']."</option>\n"; for ($i=date("Y"); $i<date("Y")+3; $i++) $elenco.= "<option value=\"$i\">$i</option>\n"; $elenco.= "</select></td> <td><input name=\"fine\" type=\"text\" size=\"10\" maxlenght=\"\" value=\"$fine\"></td> <td><select name=\"numero\"><option value=\"0\" $numerosel[0]>$numeroar[0]</option><option value=\"1\" $numerosel[1]>$numeroar[1]</option><option value=\"2\" $numerosel[2]>$numeroar[2]</option><option value=\"3\" $numerosel[3]>$numeroar[3]</option><option value=\"4\" $numerosel[4]>$numeroar[4]</option><option value=\"5\" $numerosel[5]>$numeroar[5]</option><option value=\"6\" $numerosel[6]>$numeroar[6]</option><option value=\"7\" $numerosel[7]>$numeroar[7]</option><option value=\"8\" $numerosel[8]>$numeroar[8]</option><option value=\"9\" $numerosel[9]>$numeroar[9]</option><option value=\"10\" $numerosel[10]>$numeroar[10]</option><option value=\"11\" $numerosel[11]>$numeroar[11]</option><option value=\"12\" $numerosel[12]>$numeroar[12]</option><option value=\"13\" $numerosel[13]>$numeroar[13]</option><option value=\"14\" $numerosel[14]>$numeroar[14]</option></select></td>\n"; for ($i=0; $i<count($lingue); $i++) { $colriga = colriga ($i); $k = array_search ($lingue[$i], $sigLng); $elenco.= "<tr bgcolor=\"#$colriga\"><td width=\"30\"><b>Nome ".$nomiLng[$lingue[$i]]."</b></td><td colspan=\"3\"><input name=\"nome_".$lingue[$i]."\" type=\"text\" size=\"30\" maxlenght=\"50\" value=\"".$row[($k*2)+5]."\"></td></tr> <tr bgcolor=\"#$colriga\"><td width=\"30\"><b>Note ".$nomiLng[$lingue[$i]]."</b></td><td colspan=\"3\"><textarea name=\"testo_".$lingue[$i]."\" type=\"text\" rows=\"8\" cols=\"80\">".$row[($k*2)+6]."</textarea></td></tr>\n"; } $elenco.= "<tr><td colspan=\"5\"><input type=\"hidden\" name=\"op\" value=\"$valop\"><input type=\"hidden\" name=\"id\" value=\"$id\"> <div align=\"center\"><input type=\"submit\" name=\"invio\" value=\"$intesta\">$noMod</div></td></tr></form> <tr><td colspan=\"5\" bgcolor=\"black\" height=\"4\">\n"; $rows = $query->selectAll ($table, array('anno'=>'DESC', 'id'=>'ASC'), 1); foreach ($rows as $cc=>$row) { $bgcolor = rowCol ($cc); $elenco.= "<tr bgcolor=\"#$bgcolor\"><td nowrap>\n"; $fine = date2data ($row['fine']); if ($az!="ed") $elenco.= $row['id']." <a href=\"".$_SERVER['PHP_SELF']."?id=".$row['id']."&az=ed\"><img src=\"images/edit.gif\" border=0 hspace=5 title=\"modifica stagione\"></a> <a href=\"#\" onClick=\"javascript:confDel(".$row['id'].")\"><img src=\"images/delete.gif\" border=0 title=\"cancella stagione\"></a>\n"; $elenco.= " </td><td>".$row['anno']."</td><td>".$fine."</td><td>".$numeroar[$row['numero']]."</td> <tr bgcolor=\"#".$bgcolor."\"><td width=\"30\"><b>Nome it</b></td><td colspan=\"3\">".$row[5]."</td></tr> <tr bgcolor=\"#".$bgcolor."\"><td width=\"30\"><b>Note it</b></td><td colspan=\"3\">".$row[6]."</td></tr>\n"; } echo "$testa <h2 align=\"center\">$ptitolo</h2> <table align=center><tr bgcolor=white><td><td><b>Anno listino</b></td> <td><b>Fine visualizzazione</b> (gg/mm/aaaa)</td> <td><b>Numero</b></td> $elenco</table> $coda"; ?>
Save File
Cancel