Edit.php page
Code: Select all
<?php require_once('Connections/prodotti.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
$updateSQL = sprintf("UPDATE articoli SET marca=%s, nome=%s, colore=%s, price=%s, descrizione=%s, small=%s, `large`=%s WHERE id=%s",
GetSQLValueString($_POST['marca'], "text"),
GetSQLValueString($_POST['nome'], "text"),
GetSQLValueString($_POST['colore'], "text"),
GetSQLValueString($_POST['price'], "double"),
GetSQLValueString($_POST['descrizione'], "text"),
GetSQLValueString("small/".$_FILES["img_upload"]["name"],"text"),
GetSQLValueString($_POST['large'], "text"),
GetSQLValueString($_POST['id'], "int"));
mysql_select_db($database_prodotti, $prodotti);
$Result1 = mysql_query($updateSQL, $prodotti) or die(mysql_error());
$updateGoTo = "list.php";
if (isset($_SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}
$colname_rs_update = "-1";
if (isset($_GET['id'])) {
$colname_rs_update = $_GET['id'];
}
mysql_select_db($database_prodotti, $prodotti);
$query_rs_update = sprintf("SELECT * FROM articoli WHERE id = %s", GetSQLValueString($colname_rs_update, "int"));
$rs_update = mysql_query($query_rs_update, $prodotti) or die(mysql_error());
$row_rs_update = mysql_fetch_assoc($rs_update);
$totalRows_rs_update = mysql_num_rows($rs_update);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
include_once("script/edit.php");
original();
large();
small();
micro();
?>
<form action="<?php echo $editFormAction; ?>" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table align="center">
<tr valign="baseline">
<td nowrap="nowrap" align="right">Id:</td>
<td><?php echo $row_rs_update['id']; ?></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Marca:</td>
<td><input type="text" name="marca" value="<?php echo htmlentities($row_rs_update['marca'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Nome:</td>
<td><input type="text" name="nome" value="<?php echo htmlentities($row_rs_update['nome'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Colore:</td>
<td><input type="text" name="colore" value="<?php echo htmlentities($row_rs_update['colore'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Price:</td>
<td><input type="text" name="price" value="<?php echo htmlentities($row_rs_update['price'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Descrizione:</td>
<td><input type="text" name="descrizione" value="<?php echo htmlentities($row_rs_update['descrizione'], ENT_COMPAT, 'utf-8'); ?>" size="32" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Immagine attuale:</td>
<td><img src="<?php echo $row_rs_update['small']; ?>" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right">Cambia immagine:</td>
<td><label for="img_upload"></label>
<input type="file" name="img_upload" id="img_upload" /></td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td> </td>
</tr>
<tr valign="baseline">
<td nowrap="nowrap" align="right"> </td>
<td><input type="submit" value="Update record" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form1" />
<input type="hidden" name="id" value="<?php echo $row_rs_update['id']; ?>" />
</form>
<p> </p>
</body>
</html>
<?php
mysql_free_result($rs_update);
?>
And this is the php script that resize the image and insert it into 3 folder:
Code: Select all
<?php
////////////////// ORIGINAL IMAGE SIZE STORED INTO "ORIGINAL" FOLDER ///////////////////////////
error_reporting(0);
function original(){
if($_FILES["img_upload"]["name"]!=""){
$message = "You must waiting the upload proccess";
if(!copy($_FILES["img_upload"]["tmp_name"],"original/".$_FILES["img_upload"]["name"])){
$message = "Can not upload the Image!!!";
}else{
$message = "The Image was uploaded successfuly...";
echo "<img src='"."original/".$_FILES["img_upload"]["name"]."'/>";
}
}else{
$message = "You must select an Image File!!!";
}
if($message != ""){
echo "<div style='background:yellow;color:red;font-size:20px;padding:12px;text-align:center;'>".$message."</div>";
}
}
////////////////// LARGE IMAGE SIZE (600PX WIDE) STORED INTO "LARGE" FOLDER ///////////////////////////
function large(){
if($_FILES["img_upload"]["name"]!=""){
$message = "You must waiting the upload proccess";
$img_file = $_FILES["img_upload"]["tmp_name"];
list($width_ori,$height_ori) = getimagesize($img_file);
$folder = "large/";
if(!is_dir($folder)){
mkdir($folder);
}
$width_new = 300;
$ratio_ori = $width_ori / $height_ori;
$height_new = $width_new / $ratio_ori;
$img_one = imagecreatefromjpeg($img_file);
$img_two = imagecreatetruecolor($width_new,$height_new);
imagecopyresampled($img_two,$img_one,0,0,0,0,$width_new,$height_new,$width_ori,$height_ori);
if(imagejpeg($img_two,$folder."/".$_FILES["img_upload"]["name"],100)){
$message = "The File was Uploaded!!!";
echo "<img src='"."large/".$_FILES["img_upload"]["name"]."'/>";
}
}else{
$message = "You must select an Image File!!!";
}
if($message != ""){
echo "<div style='background:yellow;color:red;font-size:20px;padding:12px;text-align:center;'>".$message."</div>";
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////// SMALL IMAGE SIZE STORED INTO "SMALL" FOLDER ///////////////////////////
function small(){
if($_FILES["img_upload"]["name"]!=""){
$message = "You must waiting the upload proccess";
$img_file = $_FILES["img_upload"]["tmp_name"];
list($width_ori,$height_ori) = getimagesize($img_file);
$folder = "small/";
if(!is_dir($folder)){
mkdir($folder);
}
$width_new = 100;
$ratio_ori = $width_ori / $height_ori;
$height_new = $width_new / $ratio_ori;
$img_one = imagecreatefromjpeg($img_file);
$img_two = imagecreatetruecolor($width_new,$height_new);
imagecopyresampled($img_two,$img_one,0,0,0,0,$width_new,$height_new,$width_ori,$height_ori);
if(imagejpeg($img_two,$folder."/".$_FILES["img_upload"]["name"],100)){
$message = "The File was Uploaded!!!";
echo "<img src='"."small/".$_FILES["img_upload"]["name"]."'/>";
}
}else{
$message = "You must select an Image File!!!";
}
if($message != ""){
echo "<div style='background:yellow;color:red;font-size:20px;padding:5px;text-align:center;'>".$message."</div>";
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////////
////////////////// MICRO IMAGE SIZE STORED INTO "MICRO" FOLDER ///////////////////////////
function micro(){
if($_FILES["img_upload"]["name"]!=""){
$message = "You must waiting the upload proccess";
$img_file = $_FILES["img_upload"]["tmp_name"];
list($width_ori,$height_ori) = getimagesize($img_file);
$folder = "micro/";
if(!is_dir($folder)){
mkdir($folder);
}
$width_new = 50;
$height_new = 50;
$ratio_width = $width_new / $width_ori;
$ratio_height = $height_new / $height_ori;
if($width_ori > $height_ori){
$width_crop = $width_ori * $ratio_height;
$height_crop = $height_new;
}else if($width_ori < $height_ori){
$width_crop = $width_new;
$height_crop = $height_ori * $ratio_width;
}else{
$width_crop = $width_new;
$height_crop = $height_new;
}
$img_one = imagecreatefromjpeg($img_file);
$img_two = imagecreatetruecolor($width_new,$height_new);
imagecopyresampled($img_two,$img_one,-(($width_crop / 2) - ($width_new / 2)),-(($height_crop / 2) - ($height_new / 2)),0,0,$width_crop,$height_crop,$width_ori,$height_ori);
if(imagejpeg($img_two,$folder."/".$_FILES["img_upload"]["name"],100)){
$message = "The File was Uploaded!!!";
echo "<img src='"."micro/".$_FILES["img_upload"]["name"]."'/>";
}
}else{
$message = "You must select an Image File!!!";
}
if($message != ""){
echo "<div style='background:yellow;color:red;font-size:20px;padding:12px;text-align:center;'>".$message."</div>";
}
}
?>
Thanks in advance.