Uploading Multiple Files

[obrienkev]

Hi all,

I want the user to be able to upload more than one image onto my server. I presume that I create multiple form fields.

Here's my php code for uploading one image. How can I change this for 2 or more?

// connect to db
include('db_connect.php');

// $fileName is original file name
$fileName = $_FILES['image']['name'];

// $tmpName is where file went on server
$tmpName = $_FILES['image']['tmp_name'];

// $fileSize is size in bytes
$fileSize = $_FILES['image']['size'];

// $fileType is mime type e.g. image/gif
$fileType = $_FILE['image']['type'];

// $fileError is any error encountered
$fileError = $_FILE['image']['error'];

/*   End Declaring Variables   */

// Error Checking
if ($fileError > 0)
{
      echo 'Error: ';
     switch ($fileError)
     {
          case 1: echo 'File exceeded upload_max_filesize';
         break;
         case 2: echo 'File exceeded max_file_size';
         break;
         case 3: echo 'File only partially uploaded';
         break;
         case 4: echo 'No file uploaded';
         break;
     }
     exit;
}
//echo $fileName.'<br /><br /><br />';
// put the file into folder
$uploaddir = 'uploads/';
$uploadfile = $uploaddir . basename($fileName);

if (move_uploaded_file($tmpName, $uploadfile))
{
      echo '<p>File Successfully Uploaded!</p><br />';
}

// perform query
$query = "INSERT INTO news ".
                  "VALUES(NULL, '$title', '$content', '$fileName', '$name', '$email', NOW(), 'No')";

$result = mysql_query($query) or die(mysql_error());

Thanks.

Kevin.

[Kudose]

Untested and not built from your code. You should get the general idea. 🙂

<?php
if(!isset($_POST['submit'])){
  echo '<form action="'.$_SERVER['PHP_SELF'].'" method="POST" enctype="multipart/form-data">';
    echo 'File 1:&nbsp;<input type="file" name="myfile[]"><br>';
    echo 'File 2:&nbsp;<input type="file" name="myfile[]"><br>';
    echo 'File 3:&nbsp;<input type="file" name="myfile[]"><br>';
    echo 'File 4:&nbsp;<input type="file" name="myfile[]"><br>';
    echo 'File 5:&nbsp;<input type="file" name="myfile[]"><br>';
    echo '<input type="submit" name="submit">';
  echo '</form>';
} else {
  //get all of the files into a local array
  //$files[0]['name'] would equal the filename to the first file
  $files = $_FILES['myfile'];

  //set allowed types
  $allowed = array("jpg", "jpeg", "gif", "png", "bmp");

  //upload directory
  $dir = '/home/user/public_html/files/';

  //loop through them
  foreach($files as $key=>$file){
    //check em
    if(filesize($file[$key]['tmp_name']) < 500000) //roughly 500K
      if(in_array($file[$key]['type'], $allowed)) //if file type is allowed continue
        if(is_uploaded_file($file[$key]['tmp_name'])) //if file is in tmp dir
          if(move_uploaded_file($file[$key]['tmp_name'], $dir.$file[$key]['name']))
            echo 'File '.$key.' was uploaded.';
          else
            echo 'Could not move uploaded file '.$key.'.';
        else
          echo 'File '.$key.' was not uploaded.';
      else
        echo 'File '.$key.' type is not allowed.';
    else
      echo 'File '.$key.' size is too great.';
  }

}
?>

####EDITED SPELLING ERROR####

[richie]

The above code doesn't work, try changing

name="myfile"
to
name="myfile[]"

[Kudose]

Good eye.

[obrienkev]

Thanks. How do I insert images into the database in one query?

[Kudose]

Unless your table is setup with infinite columns for image names, you can't.

You will have to insert them row by row. If you really only want to run ONE query, then you can concat several INSERT queries together, delimited by semicolon ';', and run it.

i.e.

$sql = "INSERT INTO table (title) VALUES ('Smurfs');";
$sql .= "INSERT INTO table (title) VALUES ('Goonies');";
$sql .= "INSERT INTO table (title) VALUES ('Inuyasha');";

mysql_query($sql);

Your best bet would be to execute the insert query in the foreach statement though. You will have multiple queries, but I think it would be easier than trying to mesh them all into one big query.