PHP - Multiple Photo Upload

Hey Guys,

I have a php script that update's franchise information using a mysql table.

Note: Ter = Territory, ie. the territory that franchise covers.

<?php 
include('config.php'); 
if (isset($_GET['Ter']) ) { 
$ter = (int) $_GET['Ter']; 
if (isset($_POST['submitted'])) {

//Photo Upload

//This is the directory where images will be saved 
$target = "images/"; 
$target = $target . basename( $_FILES['photo']['name']); 
//This gets all the other information from the form 
$photo =($_FILES['photo']['name']);
//Pause Photo Upload


foreach($_POST AS $key => $value) { $_POST[$key] = mysql_real_escape_string($value); } 
$sql= "UPDATE `ter` SET `Ter` =  '{$_POST['Ter']}' , `BranchName` = '{$_POST['BranchName']}' ,  `BranchAddress` =  '{$_POST['BranchAddress']}' ,  `BranchTel` =  '{$_POST['BranchTel']}' , `BranchEmail` =  '{$_POST['BranchEmail']}' , `BranchLink` =  '{$_POST['BranchLink']}' , `Theme` =  '{$_POST['Theme']}' , `LocalInfo` =  '{$_POST['LocalInfo']}' , `BranchInfo` =  '{$_POST['BranchInfo']}' , `photo` =  '{$_POST['photo']}' WHERE `Ter` = '$ter' "; 

mysql_query($sql) or die(mysql_error()); 


//Unpause Photo Upload
//Writes the photo to the server 
move_uploaded_file($_FILES['photo']['tmp_name'], $target);
//End of Photo Upload

echo (mysql_affected_rows()) ? "Edited Branch.<br />" : "Nothing changed. <br />";  
} 
$row = mysql_fetch_array ( mysql_query("SELECT * FROM `ter` WHERE `Ter` = '$ter' "));
?>

In phpmyadmin I can see my table and it has the correct image name displayed in the photo column. So you would assume its worked. But when I look in the 'images/' location no image has been uploaded. So I think there is an error with the upload part but cant figure out whats wrong.

Cheers, S

I have used the same method for uploading photos for ages but feel there may be a better way.

For both methods, please assume all uploads are large digital camera uploads of a few megabytes and thousands of pixels wide (as you would expect from large digital camera images).

CURRENT METHOD

(1) receive uploaded file and use ImageMagick to convert to 4 file sizes, then store these file sizes (also set so ImageMagick reduces the quality to something like a setting of 80 out of 100 which will further reduce file size.
- file sizes (widths):
800
240
120
60 (mobile phones etc.)
(2) Based on the type of size and view required I then use <img src="/photos/240/file.jpg to display (240 being the required image size of course)

POSSIBLE BETTER METHOD
(1) Use ImageMagick to reduce to 800 wide as will never display bigger than this anyway, reduce quality also. But don't resize further and only need one file.
(2) Use PHP commands to display an image, and set height/width/quality then. Eg: <img src="showImage.php?file=file.jpg&width=240&quality=60

So both would do the same thing but the second seems better as you don't need to create 4 images for every photo upload. Why make lots of thumbnails when you can make one and then get PHP to create at the time of display?

Although I suppose if you regularly displayed these images in a search result then PHP would need to do that extra processing on every search. Creating all 4 at the time of upload only requires the one bit of processing.

Have I just found the answer?

Still working on the same project.
I had a function to upload a photo and you could use it as a profile picture.
Now I wanted to expand on it and decided you can upload more than one photo, creating a gallery.
I figured I could use the same script to create two images (one original size and one thumbnail for browsing) and went about it in two different ways, both failed miserably.
First I figured my upload code could take the indata and make TWO photos at once with different name.
I guess it can only keep on image in mind at once - or I did something else wrong.
I used the same code to create $user.jpg and $user_tn.jpg and move them to the user's image folder.

So try number two was to make two folders for the photo, one named after the user (for thumb) and another in a folder named big.
That isn't working for me either.

Anyone who likes to chime in with ideas or facepalms is very welcome.

Here is the generic code I set out with:

Code: [Select]
if ($view == $user) {
mkdir("grafik/users/$user");
mkdir("grafik/users/$user/big/");

if (isset($_FILES['image']['name']))
{
$saveto = "grafik/users/$user/big/$user.jpg";
move_uploaded_file($_FILES['image']['tmp_name'], $saveto);
$typeok = TRUE;

switch($_FILES['image']['type'])
{
case "image/gif": $src = imagecreatefromgif($saveto); break;
case "image/jpeg":
case "image/pjpeg": $src = imagecreatefromjpeg($saveto); break;
case "image/png": $src = imagecreatefrompng($saveto); break;
default: $typeok = FALSE; break;
}

if ($typeok)
{
list($w, $h) = getimagesize($saveto);
$max = 200;
$tw = $w;
$th = $h;

if ($w > $h && $max < $w)
{
$th = $max / $w * $h;
$tw = $max; }
elseif ($h > $w && $max < $h)
{
$tw = $max / $h *$w;
$th = $max;}
elseif ($max < $w)
{
$tw = $th = $max;}
$tmp = imagecreatetruecolor($tw,$th);
imagecopyresampled($tmp, $src, 0, 0, 0, 0, $tw, $th, $w, $h);
imageconvolution($tmp, array(
array(-1, -1, -1),
array(-1, 16, -1),
array(-1, -1, -1)
), 8, 0);
imagejpeg($tmp, $saveto);
imagedestroy($tmp);
imagedestroy($src);
}
}
echo <<<_END
<div id='main'>
<form method='post' action='profile.php' enctype='multipart/form-data'>
Image: <input type='file' name='image' size='14' maxlength='32' />
<input type='submit' value='Save Profile' />
</form>
</div>
_END;
}

It is the page in minimalist form and it still contains the big folder version.
Thanks for putting up with my nooby questions.

I am creating a system for my students. I teach Photography and I want to do more online integration for my class. As of right now I have a whole system in which the students have their on accounts on my site. Now the challenging part for me.

I need students to upload photos to me, and I will critique them. My questions for this forum a

1. Should I have a line of code that creates a folder per user to upload photos to?
2. Should I have the photos stored in the SQL database?
3. Are there any scripts out there that can be easily adapted for this idea?

Adam

I have this script that I am using to upload new video galleries to a website. The script allows the user to upload an image that will display when they click on the gallery. As of now the image gets uploaded and a thumbnail is created automatically and stored in the appropriate places. The original image however remains its original dimensions. How would I tweak this script to resize the original image to MAX_WIDHT = 400px and MAX_HEIGHT = 750px along with keeping the create thumbnail feature?

Code: [Select]
<?php require_once('Connections/DBConnect.php'); ?>
<?php

session_start();

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
   $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_insert"])) && ($_POST["MM_insert"] == "uploadvideo")) {

// make the gallery name available for the result message
$video = $_POST['videocaption'];

// define a constant for the maximum upload size
define ('MAX_FILE_SIZE', 256000);

if (array_key_exists('upload', $_POST)) {
// define constant for upload folder
   define('UPLOAD_DIR', 'C:/wamp/www/test/videos/video_photos/');
   // replace any spaces in original filename with underscores
   // at the same time, assign to a simpler variable
   $file = str_replace(' ', '_', $_FILES['videophotoname']['name']);
   // convert the maximum size to KB
   $max = number_format(MAX_FILE_SIZE/1024, 1).'KB';
   // create an array of permitted MIME types
   $permitted = array('image/gif', 'image/jpeg', 'image/pjpeg', 'image/png');
   // begin by assuming the file is unacceptable
   $sizeOK = false;
   $typeOK = false;
  
   // check that file is within the permitted size
   if ($_FILES['videophotoname']['size'] > 0 && $_FILES['videophotoname']['size'] <= MAX_FILE_SIZE) {
     $sizeOK = true;
}

   // check that file is of an permitted MIME type
   foreach ($permitted as $type) {
    if ($type == $_FILES['videophotoname']['type']) {
     $typeOK = true;
  break;
   }
}
  
if ($sizeOK && $typeOK) {
switch($_FILES['videophotoname']['error']) {
case 0:
// define constants
   define('THUMBS_DIR', 'C:/wamp/www/test/videos/video_photos/thumbs/');
   define('MAX_WIDTH', 150);
   define('MAX_HEIGHT',225);

// process the uploaded image
   if (is_uploaded_file($_FILES['videophotoname']['tmp_name'])) {
     $original = $_FILES['videophotoname']['tmp_name'];
     // begin by getting the details of the original
     list($width, $height, $type) = getimagesize($original);
// calculate the scaling ratio
     if ($width <= MAX_WIDTH && $height <= MAX_HEIGHT) {
       $ratio = 1;
       }
     elseif ($width > $height) {
       $ratio = MAX_WIDTH/$width;
       }
     else {
       $ratio = MAX_HEIGHT/$height;
       }
// strip the extension off the image filename
$imagetypes = array('/\.gif$/', '/\.jpg$/', '/\.jpeg$/', '/\.png$/');
     $name = preg_replace($imagetypes, '', basename($_FILES['videophotoname']['name']));

     // move the temporary file to the upload folder
$moved = move_uploaded_file($original, UPLOAD_DIR.$_FILES['videophotoname']['name']);
if ($moved) {
   $result = $_FILES['videophotoname']['name'].' successfully uploaded; ';
   $original = UPLOAD_DIR.$_FILES['videophotoname']['name'];
   }
else {
   $result = 'Problem uploading '.$_FILES['videophotoname']['name'].'; ';
   }

// create an image resource for the original
switch($type) {
       case 1:
         $source = @ imagecreatefromgif($original);
     if (!$source) {
       $result = 'Cannot process GIF files. Please use JPEG or PNG.';
       }
     break;
       case 2:
         $source = imagecreatefromjpeg($original);
     break;
       case 3:
         $source = imagecreatefrompng($original);
     break;
       default:
         $source = NULL;
     $result = 'Cannot identify file type.';
       }
// make sure the image resource is OK
if (!$source) {
   $result = 'Problem copying original';
   }
else {
   // calculate the dimensions of the thumbnail
       $thumb_width = round($width * $ratio);
       $thumb_height = round($height * $ratio);
   // create an image resource for the thumbnail
       $thumb = imagecreatetruecolor($thumb_width, $thumb_height);
   // create the resized copy
   imagecopyresampled($thumb, $source, 0, 0, 0, 0, $thumb_width, $thumb_height, $width, $height);
   // save the resized copy
   switch($type) {
         case 1:
       if (function_exists('imagegif')) {
         $success = imagegif($thumb, THUMBS_DIR.$name.'_thb.gif');
         $thumb_name = $name.'_thb.gif';
     }
       else {
         $success = imagejpeg($thumb, THUMBS_DIR.$name.'_thb.jpg', 50);
     $thumb_name = $name.'_thb.jpg';
     }
       break;
     case 2:
       $success = imagejpeg($thumb, THUMBS_DIR.$name.'_thb.jpg', 100);
       $thumb_name = $name.'_thb.jpg';
       break;
     case 3:
       $success = imagepng($thumb, THUMBS_DIR.$name.'_thb.png');
       $thumb_name = $name.'_thb.png';
     }
if ($success) {

$insertSQL = sprintf("INSERT INTO tblmembervideo 
(videophotoname, videothumbname, videodescription, videocaption, modelid, `date`) 
VALUES (%s, %s, %s, %s, %s, %s)",
                        GetSQLValueString($_FILES['videophotoname']['name'], "text"),
GetSQLValueString($thumb_name, "text"),
                        GetSQLValueString($_POST['videodescription'], "text"),
                        GetSQLValueString($_POST['videocaption'], "text"),
                        GetSQLValueString($_POST['modelid'], "int"),
                        GetSQLValueString($_POST['date'], "date"));

   mysql_select_db($database_DBConnect, $DBConnect);
   $Result1 = mysql_query($insertSQL, $DBConnect) or die(mysql_error());

$videoid = mysql_insert_id();
$_SESSION['videoid'] = $videoid;

   $result .= "$thumb_name created and $video uploaded. Click <a href='addclip.php'>here</a> to add clips.";
   }
else {
   $result .= 'Problem creating thumbnail';
   }
   // remove the image resources from memory
   imagedestroy($source);
       imagedestroy($thumb);
   }
}
break;
case 3:
$result = "Error uploading $file. Please try again.";
   default:
         $result = "System error uploading $file. Contact webmaster.";
   }
     }
   elseif ($_FILES['videophotoname']['error'] == 4) {
     $result = 'No file selected';
}
   else {
     $result = "$file cannot be uploaded. Maximum size: $max. Acceptable file types: gif, jpg, png.";
}
}
}

mysql_select_db($database_DBConnect, $DBConnect);
$query_rsgetmodel = "SELECT modelid, modelname FROM tblmembermodel";
$rsgetmodel = mysql_query($query_rsgetmodel, $DBConnect) or die(mysql_error());
$row_rsgetmodel = mysql_fetch_assoc($rsgetmodel);
$totalRows_rsgetmodel = mysql_num_rows($rsgetmodel);
?>
<!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>
<div align="center">
<?php
// if the form has been submitted, display result
if (isset($result)) {
echo "<p>$result</p>";
}
?>
</div>
<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="uploadvideo" id="uploadvideo">
Select a Photo (thumbnail will automatically be created) for Video:<br />
<input name="MAX_FILE_SIZE" type="hidden" id="MAX_FILE_SIZE" value="<?php echo MAX_FILE_SIZE; ?>" />
<input type="file" name="videophotoname" id="videophotoname" />
  <br />
  <br />
Video Caption:<br />
<input type="text" name="videocaption" id="videocaption" />
<br />
<br />
Video Description:<br />
<textarea name="videodescription" id="videodescription" cols="35" rows="3"></textarea>
<br />
<br />
Model:<br />
<select name="modelid" id="modelid">
  <?php
do {  
?>
  <option value="<?php echo $row_rsgetmodel['modelid']?>"><?php echo $row_rsgetmodel['modelname']?></option>
  <?php
} while ($row_rsgetmodel = mysql_fetch_assoc($rsgetmodel));
   $rows = mysql_num_rows($rsgetmodel);
   if($rows > 0) {
       mysql_data_seek($rsgetmodel, 0);
   $row_rsgetmodel = mysql_fetch_assoc($rsgetmodel);
   }
?>
</select>
<br />
<br />
<input type="submit" name="upload" id="upload" value="Add Video" />
<input name="date" type="hidden" id="date" value="<?php echo date ("Y-m-d H:m:s"); ?>" />
<input type="hidden" name="MM_insert" value="uploadvideo" />
<br />
</form>
</body>
</html>
<?php
mysql_free_result($rsgetmodel);
?>

[CODE/]