Codice PHP:
<?php
//Modifica dell'evento selezionato
if(isSet($_GET["modifevento"])){
$tipoaff='affitto';
$a= mysql_query("UPDATE evento SET evento=\"$_POST[evento]\", via=\"$_POST[indirizzo]\", citta=\"$_POST[citta]\", provincia=\"$_POST[provincia]\", cap=\"$_POST[cap]\", descrizione=\"$_POST[descrizione]\", contatto=\"$_POST[contatto]\" WHERE ID=\"$_GET[modifevento]\" ") or print ("<script>alert('Impossibile modificare il seguente evento!')</script>");
if($a){print("<script> alert('Evento modificato con successo!')</script>");}
do {
$imgold=mysql_query("SELECT foto, foto1, foto2, foto3 FROM evento WHERE ID=\"$_GET[modifevento]\" ");
$img_old=mysql_fetch_array($imgold);
$flag=0;
$directory = "evento/";
$nofoto = "images/nofoto.jpg";
$timestamp = time();
include "SmartImage.class.php";
$waterMark = "images/smartimage.gif";
//Inserimento prima immmagine
if (!empty($_FILES['image1']['name'])){
if($img_old[0]!='images/nofoto.jpg'){
unlink($img_old[0]);}
if (is_uploaded_file($_FILES['image1']['tmp_name'])){
$file = $_FILES["image1"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '1_' . $_FILES['image1']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '1_' . $_FILES['image1']['name']);
$foto=$directory. time() . '1_' . $_FILES['image1']['name'];
}else{
echo "Errore";
}
}}}else{ $foto= $img_old[0]; }
//Inserimento 2° immagine
if (!empty($_FILES['image2']['name'])){
if($img_old[1]!=""){
unlink($img_old[1]);}
if (is_uploaded_file($_FILES['image2']['tmp_name'])){
$file = $_FILES["image2"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '2_' . $_FILES['image2']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '2_' . $_FILES['image2']['name']);
$foto1=$directory. time() . '2_' . $_FILES['image2']['name'];
}else{
echo "Errore";
}
}}}else{ $foto1=$img_old[1];}
//Inserimento 3° immagine
if (!empty($_FILES['image3']['name'])){
if($img_old[2]!=""){
unlink($img_old[2]);}
if (is_uploaded_file($_FILES['image3']['tmp_name'])){
$file = $_FILES["image3"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '3_' . $_FILES['image3']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '3_' . $_FILES['image3']['name']);
$foto2=$directory. time() . '3_' . $_FILES['image3']['name'];
}else{
echo "Errore";
}
}}}else{ $foto2=$img_old[2];}
//Inserimento 4° immagine
if (!empty($_FILES['image4']['name'])){
if($img_old[3]!=""){
unlink($img_old[3]);}
if(is_uploaded_file($_FILES["image4"]['tmp_name'])){
$file = $_FILES["image4"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '4_' . $_FILES['image4']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '4_' . $_FILES['image4']['name']);
$foto3=$directory. time() . '4_' . $_FILES['image4']['name'];
}else{
echo "Errore";
}
}}}else{ $foto3=$img_old[3];}
//Fine inserimento immagine
} while (false);
if($flag==1){print("<script> alert('".$msg."')</script>");}
else{
mysql_query("UPDATE evento SET foto=\"$foto\", foto1=\"$foto1\", foto2=\"$foto2\", foto3=\"$foto3\" WHERE ID=\"$_GET[modifevento]\" ") or print("<script>alert('Impossibile modificare l\'immagine')</script>");
}
}
//Inserimento di un evento
if(isSet($_GET["evento"])){
do{
$flag=0;
$nofoto = "images/nofoto.jpg";
$directory = "evento/";
$timestamp = time();
include "SmartImage.class.php";
$waterMark = "images/smartimage.gif";
//Inserimento 1° immagine
if (!empty($_FILES['image1']['name'])){
if (is_uploaded_file($_FILES['image1']['tmp_name'])){
$file = $_FILES["image1"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '1_' . $_FILES['image1']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '1_' . $_FILES['image1']['name']);
$foto=$directory. time() . '1_' . $_FILES['image1']['name'];
}else{
echo "Errore";
}
}}}else{ $foto=$nofoto;}
//Inserimento 2° immagine
if (!empty($_FILES['image2']['name'])){
if (is_uploaded_file($_FILES['image2']['tmp_name'])){
$file = $_FILES["image2"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '2_' . $_FILES['image2']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '2_' . $_FILES['image2']['name']);
$foto1=$directory. time() . '2_' . $_FILES['image2']['name'];
}else{
echo "Errore";
}
}}}else{ $foto1="";}
//Inserimento 3° immagine
if (!empty($_FILES['image3']['name'])){
if (is_uploaded_file($_FILES['image3']['tmp_name'])){
$file = $_FILES["image3"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '3_' . $_FILES['image3']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '3_' . $_FILES['image3']['name']);
$foto2=$directory. time() . '3_' . $_FILES['image3']['name'];
}else{
echo "Errore";
}
}}}else{ $foto2="";}
//Inserimento 4° immagine
if (!empty($_FILES['image4']['name'])){
if(is_uploaded_file($_FILES['image4']['tmp_name'])){
$file = $_FILES["image4"];
if($file["name"] != ""){
if($file["error"] == 0){
$logo = new SmartImage($file["tmp_name"]);
$logo->addWaterMarkImage($waterMark);
$logo->resize(450,380);
if (file_exists($directory. time() . '4_' . $_FILES['image4']['name'])) {
$msg = "File gia' esistente sul server. Rinominarlo e riprovare.";
$flag=1;
break;}
$logo->saveImage($directory. time() . '4_' . $_FILES['image4']['name']);
$foto3=$directory. time() . '4_' . $_FILES['image4']['name'];
}else{
echo "Errore";
}
}}}else{ $foto3="";}
//Fine inserimento immagine
} while (false);
if($flag==1){print("<script> alert('".$msg."')</script>");}
else{
$a=mysql_query("INSERT INTO evento (user,evento,via,citta,provincia,cap,descrizione,foto,foto1,foto2,foto3,contatto) VALUES(\"$_SESSION[user]\",\"$_POST[evento]\",\"$_POST[indirizzo]\",\"$_POST[citta]\",\"$_POST[provincia]\",\"$_POST[cap]\",\"$_POST[descrizione]\",\"$foto\",\"$foto1\",\"$foto2\",\"$foto3\",\"$_POST[contatto]\")") or die (mysql_error());
if($a)print("<script> alert('Nuovo evento inserito!')</script>");
}
}
// Elimnazione dell'evento selezionato
if(isSet($_GET["cancella"])){
$img=mysql_query("SELECT foto,foto1,foto2,foto3 FROM evento WHERE ID=\"$_GET[cancella]\" ");
$result=mysql_fetch_array($img);
if($result[0]!='images/nofoto.jpg'){
unlink($result[0]);
if($result[1]!=""){
unlink($result[1]);}
if($result[2]!=""){
unlink($result[2]);}
if($result[3]!=""){
unlink($result[3]);}
}
mysql_query("DELETE FROM evento WHERE ID=\"$_GET[cancella]\" ") or print ("<script>alert('Impossibile eliminare l'immobile selezionato!");
}
// Modulo per la modifica di un evento
if(isSet($_GET["modifica"])){
$mod = @mysql_query("SELECT * FROM evento WHERE ID=\"$_GET[modifica]\" ");
$mod1 = mysql_fetch_array($mod)?>
<div id="stiletitolo">Modifica il seguente evento</div>
<form method="POST" name="modulo" action="index.php?page=18&modifevento=<?php echo $mod1[0];?>" onSubmit="return formCheck(this)" enctype="multipart/form-data">
<table align="center" cellspacing="10">
<tr align="left">
<td width="91">Nome evento</td>
<td colspan="3"><input type="text" name="evento" value="<?php echo $mod1[2]; ?>" size="29"></td>
</tr>
<tr align="left">
<td>Via</td>
<td colspan="3"><input type="text" name="indirizzo" value="<?php echo $mod1[3]; ?>" size="29"></td>
</tr>
<tr align="left">
<td>Citta'</td>
<td colspan="3"><input type="text" name="citta" value="<?php echo $mod1[4]; ?>" size="29" style="text-transform:uppercase"></td>
</tr>
<tr align="left">
<td>Provincia</td>
<td colspan="3"><select name="provincia">
<option selected="" value="<?php echo $mod1[5]; ?>"><?php echo $mod1[5]; ?></option>
<option value="Agrigento">Agrigento</option>
<option value="Caltanissetta">Caltanissetta</option>
<option value="Catania">Catania</option>
<option value="Enna">Enna</option>
<option value="Messina">Messina</option>
<option value="Palermo">Palermo</option>
<option value="Ragusa">Ragusa</option>
<option value="Siracusa">Siracusa</option>
<option value="Trapani">Trapani</option>
</select></td>
</tr>
<tr align="left">
<td>CAP</td>
<td colspan="3"><input type="text" name="cap" value="<?php echo $mod1[6]; ?>" size="5" onKeyPress="return MaxCaratteri(this, 4)" onBlur="validate()"></td>
</tr>
<tr align="left">
<td>Descrizione</td>
<td colspan="3"><textarea name="descrizione" rows="8" cols="22" onKeyUp="CheckLength2()"><?php echo $mod1[7]; ?></textarea>
<input type="text" name="contatore2" size="2" onFocus="this.blur()"> </td>
////CONTINUA.......