function riducitesto($testo,$caratteri){ if(strlen($testo)>$caratteri){ $risultato=substr($testo,0,$caratteri)."[...]"; }else{ $risultato=$testo; } print puliscitesto($risultato); }
$prezzodb=@mysql_result($query3,0,2); //Messaggio di inserimento o modifica del prezzo del prodotto if(isset($_POST['salvaprezzi']) and strlen($_POST['salvaprezzi'])>0){ print $msg; } ?> <form action="caricoprezzi.php" name="modprezzo" id="modprezzo" method="POST"> <table style="padding-left: 10px; color: #fff; background-color: #333; font-size: 16px; font-weight: bold; height: 30px; width: 720px; border: 1px solid #000; font-family: Arial;" cellpadding="0" cellspacing="0"> <tr> <td width="620px"><? print puliscitesto(strtoupper($nomemarca)." - ".utf8_encode($nomeprodotto)); ?></td> </tr> </table> <table style="height: 50px; width: 720px; border: 1px solid #000; font-family: Arial;" cellpadding="0" cellspacing="0"> <tr> <td style="border: 1px solid #000; width: 100px;"><img src="<? print "../upload/".$prodottoprev; ?>" width="100px" height="100px"></td> <td style="border: 1px solid #000; width: 400px;"><? print "<div style=\"font-family: Arial; font-size: 12px; padding-left: 10px;\">".puliscitesto(utf8_encode($descprodotto))."</div>"; ?></td> <td style="border: 1px solid #000; width: 220px;"> <center> <span style="font-family: Arial; font-size: 14px; font-weight: bold;">Prezzo dell'articolo:<br /> <input type="text" name="prezzo" id="prezzo" value="<? print $prezzodb; ?>" onkeypress="javascript: sistemaprezzo(this.value,this);"> <input type="hidden" name="idprodotto" id="idprodotto" value="<? print $_POST['idprodotto']; ?>"> <input type="hidden" name="salvaprezzi" id="salvaprezzi" value="1"> </center> </td> </tr> </table> <input type="Submit" name="cmd" id="cmd" value="Conferma" style="margin-left: 570px; height: 40px; width: 150px; margin-top: 10px;"/> </form> <? }else{ print "Seleziona un prodotto"; }
<?php } ?> </head> <body bgcolor="#D5E2EB"> <select name="prodotti" id="prodotti" class="selectcambio" Onchange="javascript: scriviid(this.value);"> <?php //Dati database, connessione e selezione del database include "../config.php"; //connessione al database $db = mysql_connect($host, $user, $psw) or die("Errore nella connessione. Verificare i parametri nel file config.inc.php"); //selezione del database mysql_select_db($database) or die("Non riesco a selezionare il database"); //query prodotti per la marca selezionata $queryprod = mysql_query("SELECT id,titolo FROM `prodotti` WHERE idmarca='" . $_GET['marca'] . "' order by titolo asc") or die("Query: prodotti non eseguita!"); while ($nomeprod = mysql_fetch_array($queryprod)) { print "<option value='" . $nomeprod[0] . "'>" . utf8_encode(puliscitesto($nomeprod[1])) . "</option>"; } mysql_close($db); ?> </select> <script type="text/javascript"> scriviid(document.getElementById('prodotti').value); </script> </body> </html>
<hr /> <table border="0" width="500px"> <tr> <td style="width: 500px; padding-top: 20px;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Link banner:</span><br /> <input type="text" name="titolo" id="titolo" value="<?php print puliscitesto(utf8_encode($link_banner)); ?> " size="50"> </td> </tr> <tr> <td style="width: 500px; padding-top: 20px;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Numero:</span><br /> <input type="text" id="descrizione" name="descrizione" value="<?php print puliscitesto(utf8_encode($numero_banner)); ?> " size="50"> </td> </tr> <tr> <td style="width: 500px; padding-top: 20px;"> <?php if (strlen($nome_immagine) > 0) { ?> <div style="width: 150px; float: left; text-align: center;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Immagine Attuale:</span><br /> <?php if (strlen($nome_immagine) == 0) { ?> <img src="/w-admin/immagini/noimg.jpg">
print $data[1]; ?> &visualizza=<?php print $idvisualizza; ?> " style="color: #fff;">X Elimina</a></td> </tr> </table> <table style="height: 50px; width: 720px; border: 1px solid #000; font-family: Arial;" cellpadding="0" cellspacing="0"> <tr> <td style="border: 1px solid #000; width: 100px;"><img src="<?php print "../upload/" . $prodottoprev; ?> " width="100px" height="100px"></td> <td style="border: 1px solid #000; width: 400px;" valign="top"><div style="font-family: Arial; font-size: 12px; padding-left: 10px; padding-top: 3px;"><?php print puliscitesto(riducitesto($descprodotto, 200)); ?> </div></td> <td style="border: 1px solid #000; width: 220px;"> <center> <span style="font-family: Arial; font-size: 14px; font-weight: bold;">Prezzo dell'articolo:</span><br /> <input type="text" name="prezzo<?php print $fine; ?> " id="prezzo<?php print $fine; ?> " value="<?php print $prezzodb; ?> " onkeypress="javascript: sistemaprezzo(this.value,this);">
Modifica Marca <? }else{ ?> Inserimento Marca <? } ?> <hr /> <table border="0" width="500px"> <tr> <td style="width: 500px; padding-top: 20px;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Nome marca:</span><br /> <input type="text" name="titolo" id="titolo" value="<? print puliscitesto($nomec); ?>" size="50"> </td> </tr> <tr> <td style="width: 500px; padding-top: 20px;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Descrizione marca:</span> <textarea id="descrizione" name="descrizione" style="height: 200px; width: 400px;"><? print puliscitesto($descrizionec); ?></textarea> <script language="JavaScript"> generate_wysiwyg('descrizione'); </script> </td> </tr> <tr> <td style="width: 500px; padding-top: 20px;"> <? if(strlen($immaginecat)>0){ ?> <div style="width: 150px; float: left; text-align: center;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Immagine Attuale:</span><br /> <img src="../upload<? print $immaginecat; ?>" width="100" height="100"> </div> <? } ?> <div style="width: 300px; float: left; padding-top: 80px;"> <span style="font-size: 14px; font-family: Arial; font-weight: bold;">Nuova Immagine marca:</span><br />
} ?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 15px;" cellpadding="0" cellspacing="0"> <tr> <td style="<?php print $visualizza; ?> border: 1px solid #000; height: 40px; width: 100px; text-align: center;"><?php print $data[0]; ?> </td> <td style="<?php print $visualizza; ?> border: 1px solid #000; height: 40px; width: 400px; padding-left: 10px;"><?php print puliscitesto(utf8_encode($data[1])); ?> </td> <td style="<?php print $visualizza; ?> border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="caricomarca.php?mod=<?php print $data[0]; ?> "><img src="immagini/modifica.gif" border="0"></a></td> <td style="<?php print $visualizza; ?> border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="gestionemarca.php?<?php print $_SERVER['QUERY_STRING'] . $var; ?>
//prezzo $queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!"); $prezzodb=@mysql_result($queryprezzo,0,2); //misure del prod $misura="L. ".mysql_result($queryprod,0,5)." P. ".mysql_result($queryprod,0,6)." H. ".mysql_result($queryprod,0,7); ?> <div style="margin-bottom: 50px; overflow: hidden; width: 950px; height: <? if($cont>1){ print "1343px; background: url('../s-admin/immagini/sfondoanteprima.jpg') no-repeat; padding-top: 30px;";}else{ print "1034px;";}?>;"> <table border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: <? if($cont>1){ print "20px;";}else{ print "15px;";}?>"> <tr> <td height="40" width="900" style="padding-left: 20px; padding-top: 10px; background: url('../s-admin/immagini/riquadro4.jpg') no-repeat;"><? print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper($nomemarcadb))." - ".puliscitesto($nomeproddb)."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">€. ".sistemaprezzo($prezzodb)."</div>"; ?></td> </tr> <tr> <td height="36" width="890" style="padding-left: 20px;"> <div style="height: 100px; width: 890px; overflow: hidden;"> <? print puliscitesto($descproddb,300); ?> <? if($misura!="L. 0 P. 0 H. 0"){ print $misura; } ?> </div> </td> </tr> </table> <table border="0" width="900" cellpadding="0" cellspacing="0" style="margin-left: 15px; "> <tr> <td width="900" align="center" height="<? if($cont>1){ print "956px;";}else{ print "650px;";}?>"> <div style="overflow: hidden; width: 900px; height: <? if($cont>1){ print "956px;";}else{ print "650px;";}?>"> <? //cartella sorgente dell'img $percorsosorgente=$_SERVER['DOCUMENT_ROOT']."/upload/";
//prezzo $queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!"); $prezzodb=@mysql_result($queryprezzo,0,2); $totale=$totale+$prezzodb; //misure del prod $misura="L. ".mysql_result($queryprod,0,4)." P. ".mysql_result($queryprod,0,5)." H. ".mysql_result($queryprod,0,6); ?> <table border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: 10px;"> <tr> <td height="40" width="900" style="padding-left: 20px; padding-top: 10px; border: 1px solid #000;"><? print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper($nomemarcadb))." - ".puliscitesto($nomeproddb)."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">€. ".sistemaprezzo($prezzodb)."</div>"; ?></td> </tr> <tr> <td height="36" width="890" style="padding-left: 10px; border: 1px solid #000; font-size: 12px;"> <div style="width: 890px; height: 92px; overflow: hidden;"> <? print utf8_encode(puliscitesto($descproddb,300)); ?> <? if($misura!="L. 0 P. 0 H. 0"){ print $misura; } ?> </div> </td> </tr> </table> <table style="font-family: Arial;" border="0" cellpadding="0" cellspacing="0" style="margin-left: 15px; padding-left: 20px; font-weight: bold;"> <tr> <td height="29" align="left" width="900"> <? if(strlen($notedb)>0){ print "N.B. ".html_entity_decode($notedb);}else{ print " ";} ?> </td> </tr> </table>
<td style="width: 110px; text-align: center;">MODIFICA</td> <td style="width: 110px; text-align: center;">ELIMINA</td> </tr> </table> <? //connessione al database $db = mysql_connect($host, $user, $psw) or die ("Errore nella connessione. Verificare i parametri nel file config.inc.php"); //selezione del database mysql_select_db($database) or die ("Non riesco a selezionare il database"); $query="select * from marche order by id desc LIMIT ".$partenza.",".$num.""; $ris=mysql_query($query) or die ("Query: ".$query." non eseguita!"); if($righe>0){ while($data=mysql_fetch_array($ris)){ ?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 15px;" cellpadding="0" cellspacing="0"> <tr> <td style="border: 1px solid #000; height: 40px; width: 100px; text-align: center;"><? print $data[0]; ?></td> <td style="border: 1px solid #000; height: 40px; width: 400px; padding-left: 10px;"><? print puliscitesto($data[1]); ?></td> <td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="caricomarca.php?mod=<? print $data[0]; ?>"><img src="immagini/modifica.gif" border="0"></a></td> <td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="gestionemarca.php?<? print $_SERVER['QUERY_STRING'].$var;?>elim=<? print $data[0]; ?>"><img src="immagini/elimina.gif" border="0"></a></td> </tr> </table> <? } }else{ print "Nessun marca inserita"; } ?> <div class="divpiede"> </div> <table style="margin-top: 50px; width: 720px; height: 30px; font-family: Arial; font-weight: bold; font-size: 14px;" cellpadding="0" cellspacing="0"> <tr> <td style="width: 720px; text-align: center;"><? divisioneprodotti($corrente,$pagine); ?></td> </tr> </table> </div>
$righeb=mysql_num_rows($bloc); if($righeb>0){ ?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 16px;" cellpadding="0" cellspacing="0"> <tr> <td style="width: 100px; background-color: #FF7575; border: 1px solid #000; text-align: center; font-weight: bold;"><? print $data[0]; ?></td> <td style="width: 290px; background-color: #FF7575; border: 1px solid #000;"><? print puliscitesto($data[1]); ?></td> <td style="width: 110px; background-color: #FF7575; border: 1px solid #000; text-align: center;"><img src="immagini/modificadis.gif" border="0"></td> <td style="width: 110px; background-color: #FF7575; border: 1px solid #000; text-align: center;"><img src="immagini/eliminadis.gif" border="0"></td> <td style="width: 110px; background-color: #FF7575; border: 1px solid #000; text-align: center;"><a href="inclusi/sblocca.php?<? print $_SERVER['QUERY_STRING'].$var;?>id=<? print $data[0]; ?>"><img src="immagini/sblocca.gif" border="0"></a></td> </tr> </table> <? }else{ ?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 16px;" cellpadding="0" cellspacing="0"> <tr> <td style="width: 100px; border: 1px solid #000; text-align: center; font-weight: bold;"><? print $data[0]; ?></td> <td style="width: 290px; border: 1px solid #000;"><? print puliscitesto($data[1]); ?></td> <td style="width: 110px; border: 1px solid #000; text-align: center;"><a href="modificaprodotti.php?mod=<? print $data[0]; ?>"><img src="immagini/modifica.gif" border="0"></a></td> <td style="width: 110px; border: 1px solid #000; text-align: center;"><a href="gestioneprodotti.php?<? print $_SERVER['QUERY_STRING'].$var;?>elim=<? print $data[0]; ?>"><img src="immagini/elimina.gif" border="0"></a></td> <td style="width: 110px; border: 1px solid #000; text-align: center;"><a href="inclusi/blocca.php?<? print $_SERVER['QUERY_STRING'].$var;?>id=<? print $data[0]; ?>"><img src="immagini/blocca.gif" border="0"></a></td> </tr> </table> <? } } }else{ print "Nessun prodotto inserito"; } ?> <div class="divpiede"> </div> <div class="pagine"> <? paginefooter($corrente,$pagine); ?> </div>
<hr /> <form name="invio" id="invio" action="modificanewsletter.php?mod=<?php print $_GET['mod']; ?> " method="post"> <div class="contentitolo"> <div>Oggetto:</div><br /> <input type="text" name="titolo" id="titolo" value="<?php print puliscitesto($titolo); ?> " size="50"> </div><br /> <div class="contentitolo"> <div>Newsletter:</div><br /> <textarea id="descrizione" name="descrizione" style="height: 200px; width: 400px;"><?php print puliscitesto($descrizione); ?> </textarea> <script language="JavaScript"> generate_wysiwyg('descrizione'); </script> </div> <div class="bottone"> <input type="hidden" name="modi" id="modi" value="<?php print $_GET['mod']; ?> "> <input type="Submit" name="cmd" id="cmd" value="Modifica newsletter"> </div> </div> </form>
$queryprezzo=mysql_query("select * from prezzi where idprodotto='".$data[1]."'") or die ("Query: prodotti non eseguita!"); $prezzodb=@mysql_result($queryprezzo,0,2); //misure del prod $misura="L. ".@mysql_result($queryprod,0,5)." P. ".@mysql_result($queryprod,0,6)." H. ".@mysql_result($queryprod,0,7); ?> <div style="margin-bottom: 50px; overflow: hidden; margin-left: 20px; width: 950px; height: <?php if($cont>1){ print "1343px; background: url('immagini/sfondoanteprima.jpg') no-repeat; padding-top: 30px;";}else{ print "1034px;";}?>;"> <table style="font-family: Arial;" border="0" cellpadding="0" cellspacing="0" style="margin-left: 5px; padding-left: 20px; font-weight: bold;"> <tr> <td height="29" align="left" width="900"> <?php if(strlen($notedb)>0){ print "N.B. ".html_entity_decode($notedb, ENT_COMPAT | ENT_HTML401, "UTF-8");}else{ print " ";} ?> </td> </tr> </table> <table border="0" width="900" cellpadding="0" cellspacing="0" style="font-family: Arial; margin-left: <?php if($cont>1){ print "20px;";}else{ print "-4px;";}?>"> <tr> <td height="40" width="900" style="padding-left: 20px; padding-top: 10px; background: url('immagini/riquadro4.jpg') no-repeat;"><?php print "<div style=\"float: left; width: 750px;\">".puliscitesto(strtoupper(htmlentities($nomemarcadb)))." - ".puliscitesto(htmlentities($nomeproddb))."</div><div style=\"font-family: Arial; float: left; font-weight: bold;\">Euro: ".sistemaprezzo($prezzodb)."</div>"; ?></td> </tr> <tr> <td height="36" width="890" style="padding-left: 10px; font-size: 12px;"> <div style="height: 90px; width: 890px; overflow: hidden; margin-top: 10px;"> <?php print riducitesto(htmlspecialchars_decode(htmlentities($descproddb)),200)."<br />"; ?> <?php if(strlen(@mysql_result($queryprod,0,5))>0 or strlen(@mysql_result($queryprod,0,6))>0 or strlen(@mysql_result($queryprod,0,7))>0){ print $misura; } ?> </div> </td> </tr> </table> <table border="0" width="900" cellpadding="0" cellspacing="0"> <tr> <td width="900" align="center" height="<?php if($cont>1){ print "956px;";}else{ print "650px;";}?>">
if ($data[4] == "1") { $visualizza = "background-color: #FFD2D2;"; $bottonevis = "visualizza1.jpg"; } else { $visualizza = ""; $bottonevis = "visualizza.jpg"; } ?> <table style="border: 1px solid #000; width: 720px; height: 30px; font-family: Arial; font-size: 15px;" cellpadding="0" cellspacing="0"> <tr> <td style="border: 1px solid #000; height: 40px; width: 100px; text-align: center;"><?php print $data[0]; ?> </td> <td style="border: 1px solid #000; height: 40px; width: 400px; padding-left: 10px;"><?php print puliscitesto($data[1]); ?> </td> <td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="caricomarca.php?mod=<?php print $data[0]; ?> "><img src="immagini/modifica.gif" border="0"></a></td> <td style="border: 1px solid #000; height: 40px; width: 110px; text-align: center;"><a href="gestionemarca.php?<?php print $_SERVER['QUERY_STRING'] . $var; ?> elim=<?php print $data[0]; ?> "><img src="immagini/elimina.gif" border="0"></a></td> <td style="<?php print $visualizza;