Script PHP aggiungi file

matthew85 · 27 Feb 2013

Ciao a tutti,
sto modificando questo script:

PHP:

<?php

/*****************************************************************************

 *                                                                           *

 * Shop-Script FREE                                                          *

 * Copyright (c) 2005 WebAsyst LLC. All rights reserved.                     *

 *                                                                           *

 ****************************************************************************/





	//ADMIN :: products managment



	ini_set("display_errors", "1");



	include("./cfg/connect.inc.php");

	include("./includes/database/mysql.php");

	include("./cfg/category_functions.php");

	include("./cfg/general.inc.php");



	//connect 2 database

	db_connect(DB_HOST,DB_USER,DB_PASS) or die (db_error());

	db_select_db(DB_NAME) or die (db_error());



	session_start();

	include("./checklogin.php");

	if (!isset($_SESSION["log"]) || strcmp($_SESSION["log"],ADMIN_LOGIN)) //unauthorized

	{

		die ("You are not authorized to view this page");

	}



	//get currency ISO 3 code

	$currency_iso_3 = (defined('CONF_CURRENCY_ISO3')) ? CONF_CURRENCY_ISO3 : "USD" ;



	//current language

	include("./cfg/language_list.php");

	if (!isset($_SESSION["current_language"]) ||

		$_SESSION["current_language"] < 0 || $_SESSION["current_language"] > count($lang_list))

			$_SESSION["current_language"] = 0; //set default language



	if (isset($lang_list[$_SESSION["current_language"]]) && file_exists("./languages/".$lang_list[$_SESSION["current_language"]]->filename))

		include("./languages/".$lang_list[$_SESSION["current_language"]]->filename); //include current language file

	else

	{

		die("<font color=red><b>ERROR: Couldn't find language file!</b></font>");

	}



	if (!isset($_GET["productID"])) $_GET["productID"] = 0;



	if (isset($_POST["save_product"])) //save item to the database

	{



		if (!isset($_POST["price"]) || !$_POST["price"] || $_POST["price"] < 0)

			$_POST["price"] = 0; //price can not be negative



		if (!isset($_POST["name"]) || trim($_POST["name"])=="") $_POST["name"] = "not defined";



		$instock = (isset($_POST["in_stock"])) ? 1 : 0;



		if ($_POST["save_product"]) { //if $_POST["save_product"] != 0 then update item



			//delete old product photos if they're being replaced

			$q = db_query("SELECT picture, big_picture, thumbnail FROM ".PRODUCTS_TABLE." WHERE productID='".$_POST["save_product"]."'") or die (db_error());

			$row = db_fetch_row($q);



			//generating query



			$s = "UPDATE ".PRODUCTS_TABLE." SET categoryID='".$_POST["categoryID"]."', name='".$_POST["name"]."', Price='".$_POST["price"]."', description='".$_POST["description"]."', in_stock=".$instock.", customers_rating='".$_POST["rating"]."', brief_description='".$_POST["brief_description"]."', list_price='".$_POST["list_price"]."', product_code='".$_POST["product_code"]."'";



			$s1 = "";



			//old pictures?

			if (isset($_FILES["picture"]) && $_FILES["picture"]["name"])

			{

				//delete old picture

				if ($row[0] && file_exists("./products_pictures/".$row[0]))

					unlink("./products_pictures/".$row[0]);

			}

			if (isset($_FILES["big_picture"]) && $_FILES["big_picture"]["name"])

			{

				//delete old picture

				if ($row[1] && file_exists("./products_pictures/".$row[1]))

					unlink("./products_pictures/".$row[1]);

			}

			if (isset($_FILES["thumbnail"]) && $_FILES["thumbnail"]["name"])

			{

				//delete old picture

				if ($row[2] && file_exists("./products_pictures/".$row[2]))

					unlink("./products_pictures/".$row[2]);

			}



			$pid = $_POST["save_product"];



		}

		else

		{

			//add new product

			db_query("INSERT INTO ".PRODUCTS_TABLE." (categoryID, name, description, customers_rating, Price, in_stock, customer_votes, items_sold, enabled, brief_description, list_price, product_code, picture, thumbnail, big_picture) VALUES ('".$_POST["categoryID"]."','".$_POST["name"]."','".$_POST["description"]."', 0, '".$_POST["price"]."', ".$instock.", 0, 0, 1, '".$_POST["brief_description"]."', '".$_POST["list_price"]."', '".$_POST["product_code"]."','','','');") or die (db_error());

			$pid = db_insert_id();



			$dont_update = 1; //don't update product



			$s  = "";

			$s1 = "UPDATE ".PRODUCTS_TABLE." SET categoryID=categoryID";

		}



		//add pictures?

		//regular photo

		if (isset($_FILES["picture"]) && $_FILES["picture"]["name"] && preg_match('/\.(jpg|jpeg|gif|jpe|pcx|bmp)$/i', $_FILES["picture"]["name"])) //upload

		{

			$_FILES["picture"]["name"] = str_replace(" ","_",$_FILES["picture"]["name"]);

			$r = move_uploaded_file($_FILES["picture"]["tmp_name"], "./products_pictures/".$_FILES["picture"]["name"]);

			if (!$r) //failed 2 upload

			{

				echo "<center><font color=red>".ERROR_FAILED_TO_UPLOAD_FILE."</font>\n<br><br>\n";

				echo "<a href=\"javascript:window.close();\">".CLOSE_BUTTON."</a></center></body>\n</html>";

				exit;

			}



			SetRightsToUploadedFile( "./products_pictures/".$_FILES["picture"]["name"] );



			$s .= ", picture='".$_FILES["picture"]["name"]."'";

			$s1.= ", picture='".$_FILES["picture"]["name"]."'";

		}

		//enlarged photo

		if (isset($_FILES["big_picture"]) && $_FILES["big_picture"]["name"] && preg_match('/\.(jpg|jpeg|gif|jpe|pcx|bmp)$/i', $_FILES["big_picture"]["name"]))

		{ 

			$_FILES["big_picture"]["name"] = str_replace(" ","_",$_FILES["big_picture"]["name"]);

			$r = move_uploaded_file($_FILES["big_picture"]["tmp_name"], "./products_pictures/".$_FILES["big_picture"]["name"]);

			if (!$r) //failed 2 upload

			{

				echo "<center><font color=red>".ERROR_FAILED_TO_UPLOAD_FILE."</font>\n<br><br>\n";

				echo "<a href=\"javascript:window.close();\">".CLOSE_BUTTON."</a></center></body>\n</html>";

				exit;

			}



			SetRightsToUploadedFile( "./products_pictures/".$_FILES["big_picture"]["name"] );



			$s .= ", big_picture='".$_FILES["big_picture"]["name"]."'";

			$s1.= ", big_picture='".$_FILES["big_picture"]["name"]."'";

		}

		//thumbnail

		if (isset($_FILES["thumbnail"]) && $_FILES["thumbnail"]["name"] && preg_match('/\.(jpg|jpeg|gif|jpe|pcx|bmp)$/i', $_FILES["thumbnail"]["name"]))

		{

			$_FILES["thumbnail"]["name"] = str_replace(" ","_",$_FILES["thumbnail"]["name"]);

			$r = move_uploaded_file($_FILES["thumbnail"]["tmp_name"], "./products_pictures/".$_FILES["thumbnail"]["name"]);

			if (!$r) //failed 2 upload

			{

				echo "<center><font color=red>".ERROR_FAILED_TO_UPLOAD_FILE."</font>\n<br><br>\n";

				echo "<a href=\"javascript:window.close();\">".CLOSE_BUTTON."</a></center></body>\n</html>";

				exit;

			}



			SetRightsToUploadedFile( "./products_pictures/".$_FILES["thumbnail"]["name"] );



			$s .= ", thumbnail='".$_FILES["thumbnail"]["name"]."'";

			$s1.= ", thumbnail='".$_FILES["thumbnail"]["name"]."'";

		}



		if (!isset($dont_update)) //update product info

		{

			$s .= " WHERE productID='".$_POST["save_product"]."'";

			db_query($s) or die (db_error());

			$productID = $_POST["save_product"];

		}

		else //don't update (insert query is already completed)

		{

			$s1.= " WHERE productID=$pid";

			db_query($s1) or die (db_error());

			$productID = $pid;

		}



		update_products_Count_Value_For_Categories(0);



		//close window

		echo "<script>\n";

		echo "window.opener.location.reload();\n";

		echo "window.close();\n";

		echo "</script>\n</body>\n</html>";

		exit;

	}

	else //get product from db

	{

		if ($_GET["productID"])

		{



			$q = db_query("SELECT categoryID, name, description, customers_rating, Price, picture, in_stock, thumbnail, big_picture, brief_description, list_price, product_code FROM ".PRODUCTS_TABLE." WHERE productID='".$_GET["productID"]."'") or die (db_error());

			$row = db_fetch_row($q);

 			if (!$row) //product wasn't found

			{

				echo "<center><font color=red>".ERROR_CANT_FIND_REQUIRED_PAGE."</font>\n<br><br>\n";

				echo "<a href=\"javascript:window.close();\">".CLOSE_BUTTON."</a></center></body>\n</html>";

				exit;

			}



			if (isset($_GET["picture_remove"])) //delete items picture from server if requested

			{

				if ($_GET["picture_remove"] && file_exists("./products_pictures/".$row[$_GET["picture_remove"]]))

					unlink("./products_pictures/".$row[$_GET["picture_remove"]]);

				$picture = "none";

			}



			if (isset($_GET["delete"])) //delete product

			{

				//at first photos...

				if ($row[5] != "none" && $row[5] != "" && file_exists("./products_pictures/".$row[5]))

					unlink("./products_pictures/".$row[5]);

				if ($row[7] != "none" && $row[7] != "" && file_exists("./products_pictures/".$row[7]))

					unlink("./products_pictures/".$row[7]);

				if ($row[8] != "none" && $row[8] != "" && file_exists("./products_pictures/".$row[8]))

					unlink("./products_pictures/".$row[8]);



				$q = db_query("DELETE FROM ".PRODUCTS_TABLE." WHERE productID='".$_GET["productID"]."'") or die (db_error());



				//close window

				echo "<script>\n";

				echo "window.opener.location.reload();\n";

				echo "window.close();\n";

				echo "</script>\n</body>\n</html>";

				exit;

			}



			$title = $row[1];



		}

		else //creating new item

		{

			$title = ADMIN_PRODUCT_NEW;

			$cat = isset($_GET["categoryID"]) ? $_GET["categoryID"] : 0;

			$row = array($cat,"","","",0,"",1,"","","",0,"");

		}

	}







?>



<html>



<head>

<link rel=STYLESHEET href="images/backend/style-backend.css" type="text/css">

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo DEFAULT_CHARSET;?>">

<title><?php echo ADMIN_PRODUCT_TITLE;?></title>

<script>

function confirmDelete(question, where)

{

	temp = window.confirm(question);

	if (temp) //delete

	{

		window.location=where;

	}

}

function open_window(link,w,h) //opens new window

{

	var win = "width="+w+",height="+h+",menubar=no,location=no,resizable=yes,scrollbars=yes";

	wishWin = window.open(link,'wishWin',win);

}

</script>

</head>



<body bgcolor=#FFFFE2>

<center>

<p>

<b><?php echo $title; ?></b>



<form enctype="multipart/form-data" action="products.php" method=post>



<table width=100% border=0 cellpadding=3 cellspacing=0>



<tr>

<td align=right><?php echo ADMIN_CATEGORY_PARENT;?></td>

<td>

<select name="categoryID">

<option value="0"><?php echo ADMIN_CATEGORY_ROOT;?></option>

<?php

	//show categories select element

	$cats = fillTheCList(0,0);

	for ($i=0; $i<count($cats); $i++)

	{

		echo "<option value=\"".$cats[$i][0]."\"";

		if ($row[0] == $cats[$i][0]) //select category

			echo " selected";

		echo ">";

		for ($j=0;$j<$cats[$i][5];$j++) echo "&nbsp;&nbsp;";

		echo $cats[$i][1];

		echo "</option>";

	}

?>

</select>

</td>

</tr>



<tr>

<td align=right><?php echo ADMIN_PRODUCT_NAME;?></td>

<td><input type="text" name="name" value="<?php echo str_replace("\"","&quot;",$row[1]); ?>"></td>

</tr>



<tr>

<td align=right><?php echo ADMIN_PRODUCT_CODE;?></td>

<td><input type="text" name="product_code" value="<?php echo str_replace("\"","&quot;",$row[11]); ?>"></td>

</tr>



<?php	if ($_GET["productID"]) { ?>

<tr>

<td align=right><?php echo ADMIN_PRODUCT_RATING;?>:</td>

<td><input type=text name="rating" value="<?php echo str_replace("\"","&quot;",$row[3]); ?>"></b></td>

</tr>



<?php }; ?>



<tr>

<td align=right><?php echo ADMIN_PRODUCT_PRICE;?>, <?php echo $currency_iso_3; ?><br>(<?php echo STRING_NUMBER_ONLY;?>):</td>

<td><input type="text" name="price" value=<?php echo $row[4]; ?>></td>

</tr>



<tr>

<td align=right><?php echo ADMIN_PRODUCT_LISTPRICE;?>, <?php echo $currency_iso_3; ?><br>(<?php echo STRING_NUMBER_ONLY;?>):</td>

<td><input type="text" name="list_price" value=<?php echo $row[10]; ?>></td>

</tr>



<?php

	if ($row[6]<0) $is = 0;

	else $is = $row[6];



?>

<tr>

<td align=right><?php echo ADMIN_PRODUCT_INSTOCK;?>:</td>

<td><input type="checkbox" name="in_stock"<?php if ($is > 0) echo " checked"; ?>></td>

</tr>





<tr><td>&nbsp;</td></tr>



<tr>

<td align=right><?php echo ADMIN_PRODUCT_PICTURE;?></td>

<td><input type="file" name="picture"></td>

<tr><td></td><td>

<?php

	if ($row[5]!="" && file_exists("./products_pictures/".$row[5]))

	{

		echo "<a class=small href=\"products_pictures/".$row[5]."\">$row[5]</a>\n";

		echo "<br><a href=\"javascript:confirmDelete('".QUESTION_DELETE_PICTURE."','products.php?productID=".$_GET["productID"]."&picture_remove=5');\">".DELETE_BUTTON."</a>\n";

	}

	else echo "<font class=average color=brown>".ADMIN_PICTURE_NOT_UPLOADED."</font>";

?>

</td>

</tr>

<tr>

<td align=right><?php echo ADMIN_PRODUCT_THUMBNAIL;?></td>

<td><input type="file" name="thumbnail"></td>

<tr><td></td><td>

<?php

	if ($row[7]!="" && file_exists("./products_pictures/".$row[7]))

	{

		echo "<a class=small href=\"products_pictures/".$row[7]."\">$row[7]</a>\n";

		echo "<br><a href=\"javascript:confirmDelete('".QUESTION_DELETE_PICTURE."','products.php?productID=".$_GET["productID"]."&picture_remove=7');\">".DELETE_BUTTON."</a>\n";

	}

	else echo "<font class=average color=brown>".ADMIN_PICTURE_NOT_UPLOADED."</font>";

?>

</td>

</tr>

<tr>

<td align=right><?php echo ADMIN_PRODUCT_BIGPICTURE;?></td>

<td valign=top><input type="file" name="big_picture"></td>

<tr><td></td><td valign=top>

<?php

	if ($row[8] && file_exists("./products_pictures/".$row[8]))

	{

		echo "<a class=small href=\"products_pictures/".$row[8]."\">$row[8]</a>\n";

		echo "<br><a href=\"javascript:confirmDelete('".QUESTION_DELETE_PICTURE."','products.php?productID=".$_GET["productID"]."&picture_remove=8');\">".DELETE_BUTTON."</a>\n";

	}

	else echo "<font class=average color=brown>".ADMIN_PICTURE_NOT_UPLOADED."</font>";

?>

</td>

</tr>





<tr>

<td align=right><?php echo ADMIN_PRODUCT_DESC;?><br>(HTML):</td>

<td><textarea name="description" rows=15 cols=40><?php echo str_replace("<","&lt;",$row[2]); ?></textarea></td>

</tr>



<tr>

<td align=right><?php echo ADMIN_PRODUCT_BRIEF_DESC;?><br>(HTML):</td>

<td><textarea name="brief_description" rows=7 cols=40><?php echo str_replace("<","&lt;",$row[9]); ?></textarea></td>

</tr>



</table>





<p><center>

<input type="submit" value="<?php echo SAVE_BUTTON;?>" width=5>

<input type="hidden" name="save_product" value=<?php echo $_GET["productID"]; ?>>

<input type="button" value="<?php echo CANCEL_BUTTON;?>" onClick="window.close();">

<?php	if ($_GET["productID"]) echo "<input type=button value=\"".DELETE_BUTTON."\" onClick=\"confirmDelete('".QUESTION_DELETE_CONFIRMATION."','products.php?productID=".$_GET["productID"]."&delete=1');\">"; ?>

</center></p>

</form>





</center>

</body>



</html>

quello che vorrei chiedervi è questo: dovrei aggiungere dei bottoni in più dove io posso andare ad aggiungere delle immagini ma non sono certo che modificando/aggiungendo le righe, che vi copierò di seguito, sia corretto oppure no.
Le righe di script che vi dicevo è questo:

PHP:

//add pictures? 

        //regular photo 

        if (isset($_FILES["picture"]) && $_FILES["picture"]["name"] && preg_match('/\.(jpg|jpeg|gif|jpe|pcx|bmp)$/i', $_FILES["picture"]["name"])) //upload 

        { 

            $_FILES["picture"]["name"] = str_replace(" ","_",$_FILES["picture"]["name"]); 

            $r = move_uploaded_file($_FILES["picture"]["tmp_name"], "./products_pictures/".$_FILES["picture"]["name"]); 

            if (!$r) //failed 2 upload 

            { 

                echo "<center><font color=red>".ERROR_FAILED_TO_UPLOAD_FILE."</font>\n<br><br>\n"; 

                echo "<a href=\"javascript:window.close();\">".CLOSE_BUTTON."</a></center></body>\n</html>"; 

                exit; 

            } 



            SetRightsToUploadedFile( "./products_pictures/".$_FILES["picture"]["name"] ); 



            $s .= ", picture='".$_FILES["picture"]["name"]."'"; 

            $s1.= ", picture='".$_FILES["picture"]["name"]."'"; 

        }

è giusto copiarlo ed incollarlo per ogni bottone che aggiungo?

matthew85 · 27 Feb 2013

Qualcuno sa darmi una mano?

Autore	Titolo	Forum	Risposte	Data
H	Script php per link 'Aggiungi agli amici'?	PHP	34	28 Ago 2012
P	lanciare script asp (o php) da jquery	Javascript	1	2 Feb 2022
G	[PHP] Creare script di prenotazione con controllo disponibilità.	PHP	7	3 Set 2021
M	Collegamento tra form html e script php	PHP	4	24 Mag 2021
	PHP e script generazione file excel	PHP	2	3 Lug 2020
R	Primo script in PHP / CSS	PHP	4	17 Mar 2020
	Script PHP per leggere un file JSON. autenticazione?	PHP	4	6 Mar 2020
T	[a pagamento] programmatore PHP che mi aiuti a migrare gli script da vecchia versione PHP a nuova	Offerte e Richieste di Lavoro e/o Collaborazione	1	28 Feb 2020
	[PHP] Script che funziona in locale e non online	PHP	16	12 Nov 2019
K	Help: problema con uno script di booking in php!	PHP	0	28 Ott 2019
O	[PHP] inviare dati da form e script ajax	PHP	0	25 Ott 2019
P	[PHP] Aggiungere un mio script a prestashop?	PHP	10	16 Ott 2019
D	[Javascript] inserire uno script in un file php	Javascript	6	27 Set 2019
	php testo errato durante la lettura del file txt quando lo script viene eseguito contemporaneamente	PHP	3	10 Set 2019
	[PHP] Script per rinominare in automatico le immagini inviate da ftp	PHP	0	11 Apr 2019
A	[PHP] Script con array con numeri che iniziano per 00	PHP	2	28 Gen 2019
	[PHP] Script per organizzazione presenza eventi	PHP	3	29 Nov 2018
D	[PHP] script che invii una mail automatica dopo risposta ad una discussione di un forum	PHP	0	9 Nov 2018
T	interpretare uno script php non fatto da me...	PHP	3	31 Ott 2018
O	Script PHP e loro visibilità	PHP	4	8 Ott 2018
A	[PHP] Script Ip camera su altervista senza sottocartelle	PHP	6	22 Set 2018
M	[PHP] Problema script ricezione e invio posta...	PHP	1	24 Ago 2018
Y	Codice AdSense su script php	PHP	4	24 Lug 2018
L	[PHP] Problema Script 'Not Found'	PHP	4	7 Lug 2018
	[PHP] Script per censurare parole	PHP	4	21 Giu 2018
C	richiamare una funzione in un altro script php	PHP	1	1 Giu 2018
M	[PHP] Script per controllo disponibilitá negozio in citta	PHP	4	18 Apr 2018
B	[PHP] hp script creare un utente diminuendo -1 e cosi via	PHP	1	15 Apr 2018
Y	Modificare script php	PHP	5	29 Mar 2018
	[PHP] script importati da internet o da file	PHP	24	27 Feb 2018
	[Vendo] Script gestionale php-mysql gestione pratiche	Altri Annunci	0	15 Feb 2018
T	mostrare il riultato di uno script php	Ajax	2	9 Feb 2018
K	Script PHP per leggere array.txt	Presentati al Forum	3	2 Dic 2017
	[PHP] problema script invio e-mail	PHP	2	30 Ago 2017
R	pagina html + script php	PHP	12	13 Ago 2017
M	Script php funziona / non funziona in base all'hosting	PHP	21	29 Mag 2017
T	[PHP] piccola modifica a script (non mio...)	PHP	8	13 Mag 2017
	Script php che non va più' con Versione MySQL: 5.6	PHP	5	25 Feb 2017
	[PHP] script per caricamento video	PHP	0	10 Feb 2017
	Screenshot da script php	PHP	0	9 Feb 2017
F	Richiesta script PHP	PHP	1	15 Gen 2017
	Bloccare utente se non loggato con script php	PHP	12	30 Dic 2016
	[PHP] Script nello script	PHP	2	10 Nov 2016
H	[PHP] Script non vengono eseguiti	PHP	2	4 Ott 2016
	[PHP] Script reminder email	PHP	11	22 Set 2016
S	Problema con script php-javascript	PHP	2	19 Ago 2016
9	inserire contenuto in un file pdf aperto sul browser tramite script php	PHP	0	16 Ago 2016
A	[PHP] inserire paginazione su script php/mysql	PHP	6	11 Lug 2016
R	[PHP] [HTML] Creare script invio modulo contatti	PHP	2	21 Giu 2016
	[Risolto] Gestione Prenotazioni script php	PHP	25	18 Giu 2016

Cerca

Cerca

Script PHP aggiungi file

matthew85

Nuovo Utente

matthew85

Nuovo Utente

Discussioni simili