[Resolved] uploading multiple files associated with one database entry

[jasonmills58]

Before I implemented the daabase aspect of this, I was able to upload four files at a time,
and view their $_FILES data just on the screen, but I ran into a little bit of a snag here.

when I'm uploading multiple files,
they may all be associated with one comment/note,
and there may not be 4, it could be 1, 2, 3, or 4.

So if i run the entire query for each file, like this:

foreach( $_FILES as $file_name => $file_array ) { 
    if(move_uploaded_file( $file_array['tmp_name'], $file_dir.'/'.$file_array['name'] )) { 
		$query = "INSERT INTO notes ( clientid, topic, date, comment, report1, file1, path1, 
									report2, file2, path2, report3, file3, path3, report4, file4, path4 )
				VALUES( '$id', '$topic', '$date', '$comment', '$report1', '$file1', '$path1', '$report2', 
					'$file2', '$path2', '$report3', '$file3', '$path3', '$report4', '$file4', '$path4' )";
        if( ! mysql_query( $query, $link ) ) { 
            die("Could not execute query: ".mysql_error()); 
        } 
    } 
    else { 
        die("Couldn't Copy"); 
    } 
}

the comments and notes get all screwed up.

So, I'm guessing I need to just use the loop to build the query in pieces,
but I'm not totally sure how that would work.

I think it needs to look something like:

$path = $file_dir.'/';

foreach( $_FILES as $file_name => $file_array ) { 
    if( move_uploaded_file( $file_array['tmp_name'], $file_dir.'/'.$file_array['name'] ) ) { 
	if ( isset file1 ) {
	    $report1 = $report1; //from the form input
	    $file1 = $filearray['name'];
	}
	if ( isset file2 ) {
	    $report2 = $report2; //from the form input
	    $file2 = $filearray['name'];
	}
	if ( isset file3 ) {
	    $report3 = $report3; //from the form input
	    $file3 = $filearray['name'];
	}
	if ( isset file4 ) {
	    $report4 = $report4; //from the form input
	    $file4 = $filearray['name'];
	}
        if( ! mysql_query( $query, $link ) ) { 
            die("Could not execute query: ".mysql_error()); 
        } 
    } 
    else { 
        die("Couldn't Copy"); 
    } 
}

$query = "INSERT INTO notes ( clientid, topic, date, comment, report1, file1, path1, 
				report2, file2, path2, report3, file3, path3, report4, file4, path4 )
	VALUES( '$id', '$topic', '$date', '$comment', '$report1', '$file1', '$path', '$report2', 
		'$file2', '$path', '$report3', '$file3', '$path', '$report4', '$file4', '$path' )";

but i know thats not the way to do it. I hope this is really as complex as it seems to me. 😃

cuz i'm going to feel pretty silly if there's some really easy way to do all of this...

cheers all!
Jason

[leatherback]

Hey Jason,

Still puttering along on those files are you? 😃

I would hate to ruin your evening but eeh..

If you do not know how many files a user is uploading, how about adding a table 'files' to your database? (And the rest of the evening was filled! J.😃 )

You put the colums | ID | user | name | path | in there, and then your users can upload as many files as they want, and you can justkeep on filling that table.

If you ever need the files from a user: select * from files where user = $userid;

Bang-slabang. Done.

?

[jasonmills58]

yup, there it is. thats me feeling silly. thanks tho. so, if i need to have that by userid AND by particular note
(each note is uploaded with 0-4 files associated with it, and any user will have many such notes) do i just
make the note_id unique?

cheers!

[leatherback]

In general, as soon as you start to duplicate big parts of data within a database, you should look at making a new table. So if you say there can be 4 files for each note and a user can have several notes...

I'd say you are alomst looking at 3 tables; users - Notes - Files

J.

[jasonmills58]

ok. Yeah, I do have a user table. i don't know why i didn't think to make a files table.

something like clientid | notename | filename | pathname

thanks a ton!