[Resolved] How do I associate a caption for a multiple file upload?

[jasonmills58]

ok, so this code works beautifully for uploading multiple files at the same time. Now I want to add a caption (from a text field sitting next to each upload field).

the layout:

<td colspan="2"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
	<td class="formContent"><input name="caption[]" type="text" size="41"></td>
	<td class="formContent"><input name="upload1" type="file" size="25"></td>
  </tr>
  <tr>
	<td class="formContent"><input name="caption[]" type="text" size="41"></td>
	<td class="formContent"><input name="upload2" type="file" size="25"></td>
  </tr>
  <tr>
	<td class="formContent"><input name="caption[]" type="text" size="41"></td>
	<td class="formContent"><input name="upload3" type="file" size="25"></td>
  </tr>
  <tr>
	<td class="formContent"><input name="caption[]" type="text" size="41"></td>
	<td class="formContent"><input name="upload4" type="file" size="25"></td>
  </tr>
</table></td>

and the file processor:

$file_dir = "/home/httpd/vhosts/*****.tv/httpdocs/controlPanel/uploads"; 
$file_url = "http://*****.tv/controlPanel/uploads"; 
if ( isset ( $_FILES ) ) {
	foreach( $_FILES as $file_name => $file_array ) { 
		if ( is_uploaded_file ( $file_array['tmp_name'] ) ) {
			$time = time();  

			$safe_filename = $time."-".$file_array['name'];  

			$filename = $file_array['name']; 
			$safe_filename = str_replace( " ", "_", $safe_filename );
			move_uploaded_file( $file_array['tmp_name'], $file_dir.'/'.$safe_filename )
				or die ( "Couldn't Copy" ); 
			$file_query = "INSERT INTO caseFiles ( caseid, caseFilename, caseSafeFilename )
VALUES( '$caseid', '$filename', '$safe_filename' )";
			if( ! mysql_query( $file_query, $link ) ) { 
				die("Could not execute query: ".mysql_error()); 
			} 
		 }
	}
}

Basically, I can't figure out how to insert the right caption with the right file upload. Thanks for any input!

jason

[LordShryku]

Why not number the captions the same as the uploads?

Like for the upload1 caption, name the field caption1 or caption[1]....

[jasonmills58]

I guess I could do that. I was thinking I would have to make the captions an array that I loop through. Do oyu think if I number them that the foreach will loop through them in the right order?

I'll give it a shot.

cheers,
jason

[LordShryku]

assuming you use the non-array approach(caption1, caption2,etc), try this:

if(isset($_FILES)) {
    $i=1; // set counter
    foreach($_FILES as $file_name => $file_array) { 
        if(is_uploaded_file($file_array['tmp_name'])) {
            $caption = $_POST['caption'.$i]; // set caption name
            $time = time();  

            $safe_filename = $time."-".$file_array['name'];  

            $filename = $file_array['name']; 
            $safe_filename = str_replace(" ","_",$safe_filename);
            move_uploaded_file($file_array['tmp_name'], $file_dir.'/'.$safe_filename)
                 or die("Couldn't Copy"); 
            // query adds caption 
            $file_query = "INSERT INTO caseFiles (caseid, caseFilename, caseSafeFilename,caption)
                                VALUES('$caseid', '$filename', '$safe_filename', '$caption')";
            $i++; // increment counter
            mysql_query($file_query,$link)) or die("Could not execute query: ".mysql_error()); 
        }
    }
}

[jasonmills58]

Thanks man, that did it. LOL Why are these things always way simpler than I imagine? :rolleyes:

cheers,
jason