Multiple files upload while updating DB

MoroccoIT

Greetings -

I saw somewhat similar code (pls see link below) that does mupltiple files upload. It works fine, but I wanted to populate the database with the same files that are uploaded to mydirectory, but for some reason, I am getting different file names on the database.

Here is the full code: please do serach on kewword "database" to see where I added my database code - that where I need help with.

And here the link where I got it from:
http://www.bennadel.com/blog/1117-As...ColdFusion.htm

Thank you so much for any input you can provide

@Karim

Expand|Select|Wrap|Line Numbers

 <!---

Set the number of files that can uploaded in a single

form submission.

--->

<cfset REQUEST.FileCount = 5 />
 
<!--- Set the destination folder for uploads. --->

<cfset REQUEST.UploadPath = ExpandPath( "./uploads/" ) />
 
<!--- Param the appropriate number of file fields. --->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<!--- Param file value. --->

<cfparam

name="FORM.file#intFileIndex#"

type="string"

default=""

/>
 
</cfloop>
 
<!--- Param upload flag. --->

<cftry>

<cfparam

name="FORM.submitted"

type="numeric"

default="0"

/>
 
<cfcatch>

<cfset FORM.submitted = 0 />

</cfcatch>

</cftry>
 
<!--- Set up an array to hold errors. --->

<cfset arrErrors = ArrayNew( 1 ) />
 
<!--- Check to see if the form has been submitted. --->

<cfif FORM.submitted>
 
<!---

Here is where we would validate the data; however,

in this example, there really isn't anything to

validate. In order to validate something, we are going

to require at least one file to be uploaded!

--->
 
<!---

Since we are going to require at least one file, I am

going to start off with an error statement. Then, I am

gonna let the form tell me to DELETE IT.

--->

<cfset ArrayAppend(

arrErrors,

"Please select at least one file to upload"

) />
 
<!--- Loop over the files looking for a valid one. --->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<cfif Len( FORM[ "file#intFileIndex#" ] )>
 
<!--- Clear the errors array. --->

<cfset ArrayClear( arrErrors ) />
 
<!--- Break out of loop. --->

<cfbreak />
 
</cfif>
 
</cfloop>
 
<!---

Check to see if there were any form validation

errors. If there are no errors, then we can continue

to process the form. Otherwise, we are going to skip

this and just let the page render again.

--->

<cfif NOT ArrayLen( arrErrors )>
 
<!---

Create an array to hold the list of uploaded

files.

--->

<cfset arrUploaded = ArrayNew( 1 ) />
 
<!---

Loop over the form fields and upload the files

that are valid (have a length).

--->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<!--- Check to see if file has a length. --->

<cfif Len( FORM[ "file#intFileIndex#" ] )>
 
<!---

When uploading, remember to use a CFTry /

CFCatch as complications might be encountered.

--->

<cftry>

<cffile

action="upload"

destination="#REQUEST.UploadPath#"

filefield="file#intFileIndex#"

nameconflict="makeunique"

/>
 
<!---

Store this file name in the uploaded file

array so we can reference it later.

--->

<cfset ArrayAppend(

arrUploaded,

(CFFILE.ServerDirectory & "\" & CFFILE.ServerFile)

) />
 
<!---  Store file names in the database --->

<CFQUERY NAME="CreateDocumentRecord" DATASOURCE="mydb">

   INSERT INTO Uploads (user_ID, File_Name, Date_Published)

   VALUES (#Form.ClientID#, 'file#intFileIndex#', #Now()#)

</CFQUERY>
 
<!--- #FILE.ClientFile# #intFileIndex# File_Name, #intFileIndex#--->
 
<!--- Catch upload errors. --->

<cfcatch>
 
<!--- Store the error. --->

<cfset ArrayAppend(

arrErrors,

"There was a problem uploading file ###intFileIndex#: #CFCATCH.Message#"

) />
 
<!---

Break out of the upload loop as we

don't want to deal with any more

files than we have to.

--->

<cfbreak />
 
</cfcatch>

</cftry>
 
</cfif>
 
</cfloop>
 
<!--- Check to see if we have any form errors. --->

<cfif ArrayLen( arrErrors )>
 
<!---

We encountered an error somewhere in the upload

process. As such, we want to clean up the server

a bit by deleteing any files that were

successfully uploaded as part of this process.

--->

<cfloop

index="intFileIndex"

from="1"

to="#ArrayLen( arrUploaded )#"

step="1">
 
<!--- Try to delete this file. --->

<cftry>

<cffile

action="delete"

file="#arrUploaded[ intFileIndex ]#"

/>
 
<cfcatch>

<!--- File could not be deleted. --->

</cfcatch>

</cftry>
 
</cfloop>
 
<cfelse>
 
<!---

!! SUCCESS !!

The files were properly uploaded and processed.

Here is where you might forward someone to some

sort of success / confirmation page.

--->
 
</cfif>
 
</cfif>
 
</cfif>
 
<!--- Set the content type and reset the output buffer. --->

<cfcontent

type="text/html"

reset="true"

/>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

<title>Multiple File Uploads</title>

</head>

<body>
 
<cfoutput>
 
<h1>

Multiple File Upload ColdFusion Example

</h1>
 
<!--- Check to see if we have any errors to display. --->

<cfif ArrayLen( arrErrors )>
 
<p>

Please review the following errors:

</p>
 
<ul>

<cfloop

index="intError"

from="1"

to="#ArrayLen( arrErrors )#"

step="1">
 
<li>

#arrErrors[ intError ]#

</li>
 
</cfloop>

</ul>
 
</cfif>
 
<form

action="#CGI.script_name#"

method="post"

enctype="multipart/form-data">
 
<!--- Submission flag. --->

<input type="hidden" name="ClientID" value="163">

<input type="hidden" name="submitted" value="1" />
 
<!---

Loop over the number of files we are going to

allow for the upload.

--->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<label for="file#intFileIndex#">

File #intFileIndex#:

</label>
 
<input

type="file"

name="file#intFileIndex#"

id="file#intFileIndex#"

/>
 
<br />
 
</cfloop>
 
<input type="submit" value="Upload Files" />
 
</form>

MoroccoIT

Greetings -

ATTN Bytes Admin: My apologies, I am new to your Forum, I posted this thread on other place by accident, I tried to delete it but I couldn't, please delete the other one when you have a chance. Thank you.

Back to my thread:
I saw this code (pls see link below or code is pasted blow as well) that does mupltiple files upload. It works fine, but I wanted to populate the database with the same files that are uploaded to mydirectory, but for some reason, I am getting different file names on the database.

exp: when I ploaded this files: photo1 photo2 photo3 photo4, I see all of them with right files names photo1.jpg photo2.jpg photo3.jpg photo4.jpg on the upload folder, but they get renamed on the database to: file1 file2 file3 file4. I'd like to see the same file names on the database as well.

Below is the full code: Please do serach on kewword "database" to see where I added my database code - that's where I need help with - everything else is working fine.

And here the link where I got it from:
http://www.bennadel.com/blog/1117-As...ColdFusion.htm

Thank you so much for any input you can provide

@Karim
MoroccoUSA.com

Expand|Select|Wrap|Line Numbers

 <!---

Set the number of files that can uploaded in a single

form submission.

--->

<cfset REQUEST.FileCount = 5 />
 
<!--- Set the destination folder for uploads. --->

<cfset REQUEST.UploadPath = ExpandPath( "./uploads/" ) />
 
<!--- Param the appropriate number of file fields. --->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<!--- Param file value. --->

<cfparam

name="FORM.file#intFileIndex#"

type="string"

default=""

/>
 
</cfloop>
 
<!--- Param upload flag. --->

<cftry>

<cfparam

name="FORM.submitted"

type="numeric"

default="0"

/>
 
<cfcatch>

<cfset FORM.submitted = 0 />

</cfcatch>

</cftry>
 
<!--- Set up an array to hold errors. --->

<cfset arrErrors = ArrayNew( 1 ) />
 
<!--- Check to see if the form has been submitted. --->

<cfif FORM.submitted>
 
<!---

Here is where we would validate the data; however,

in this example, there really isn't anything to

validate. In order to validate something, we are going

to require at least one file to be uploaded!

--->
 
<!---

Since we are going to require at least one file, I am

going to start off with an error statement. Then, I am

gonna let the form tell me to DELETE IT.

--->

<cfset ArrayAppend(

arrErrors,

"Please select at least one file to upload"

) />
 
<!--- Loop over the files looking for a valid one. --->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<cfif Len( FORM[ "file#intFileIndex#" ] )>
 
<!--- Clear the errors array. --->

<cfset ArrayClear( arrErrors ) />
 
<!--- Break out of loop. --->

<cfbreak />
 
</cfif>
 
</cfloop>
 
<!---

Check to see if there were any form validation

errors. If there are no errors, then we can continue

to process the form. Otherwise, we are going to skip

this and just let the page render again.

--->

<cfif NOT ArrayLen( arrErrors )>
 
<!---

Create an array to hold the list of uploaded

files.

--->

<cfset arrUploaded = ArrayNew( 1 ) />
 
<!---

Loop over the form fields and upload the files

that are valid (have a length).

--->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<!--- Check to see if file has a length. --->

<cfif Len( FORM[ "file#intFileIndex#" ] )>
 
<!---

When uploading, remember to use a CFTry /

CFCatch as complications might be encountered.

--->

<cftry>

<cffile

action="upload"

destination="#REQUEST.UploadPath#"

filefield="file#intFileIndex#"

nameconflict="makeunique"

/>
 
<!---

Store this file name in the uploaded file

array so we can reference it later.

--->

<cfset ArrayAppend(

arrUploaded,

(CFFILE.ServerDirectory & "\" & CFFILE.ServerFile)

) />
 
 <!--- Store file names in the database --->

<CFQUERY NAME="CreateDocumentRecord" DATASOURCE="mydb">

INSERT INTO Uploads (user_ID, File_Name, Date_Published)

VALUES (#Form.ClientID#, 'file#intFileIndex#', #Now()#)

</CFQUERY>
 
<!--- #FILE.ClientFile# #intFileIndex# File_Name, #intFileIndex#--->
 
<!--- Catch upload errors. --->

<cfcatch>
 
<!--- Store the error. --->

<cfset ArrayAppend(

arrErrors,

"There was a problem uploading file ###intFileIndex#: #CFCATCH.Message#"

) />
 
<!---

Break out of the upload loop as we

don't want to deal with any more

files than we have to.

--->

<cfbreak />
 
</cfcatch>

</cftry>
 
</cfif>
 
</cfloop>
 
<!--- Check to see if we have any form errors. --->

<cfif ArrayLen( arrErrors )>
 
<!---

We encountered an error somewhere in the upload

process. As such, we want to clean up the server

a bit by deleteing any files that were

successfully uploaded as part of this process.

--->

<cfloop

index="intFileIndex"

from="1"

to="#ArrayLen( arrUploaded )#"

step="1">
 
<!--- Try to delete this file. --->

<cftry>

<cffile

action="delete"

file="#arrUploaded[ intFileIndex ]#"

/>
 
<cfcatch>

<!--- File could not be deleted. --->

</cfcatch>

</cftry>
 
</cfloop>
 
<cfelse>
 
<!---

!! SUCCESS !!

The files were properly uploaded and processed.

Here is where you might forward someone to some

sort of success / confirmation page.

--->
 
</cfif>
 
</cfif>
 
</cfif>
 
<!--- Set the content type and reset the output buffer. --->

<cfcontent

type="text/html"

reset="true"

/>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

<title>Multiple File Uploads</title>

</head>

<body>
 
<cfoutput>
 
<h1>

Multiple File Upload ColdFusion Example

</h1>
 
<!--- Check to see if we have any errors to display. --->

<cfif ArrayLen( arrErrors )>
 
<p>

Please review the following errors:

</p>
 
<ul>

<cfloop

index="intError"

from="1"

to="#ArrayLen( arrErrors )#"

step="1">
 
<li>

#arrErrors[ intError ]#

</li>
 
</cfloop>

</ul>
 
</cfif>
 
<form

action="#CGI.script_name#"

method="post"

enctype="multipart/form-data">
 
<!--- Submission flag. --->

<input type="hidden" name="ClientID" value="163">

<input type="hidden" name="submitted" value="1" />
 
<!---

Loop over the number of files we are going to

allow for the upload.

--->

<cfloop

index="intFileIndex"

from="1"

to="#REQUEST.FileCount#"

step="1">
 
<label for="file#intFileIndex#">

File #intFileIndex#:

</label>
 
<input

type="file"

name="file#intFileIndex#"

id="file#intFileIndex#"

/>
 
<br />
 
</cfloop>
 
<input type="submit" value="Upload Files" />
 
</form>

acoder

Use CFFILE.ServerFile instead of file#intFileIndex# because file#intFileIndex# is the name of the file field in the form, not the uploaded file name.

MoroccoIT

Thank you so much acoder, it worked.

However, I am still struggling to limit the number of files to be uploaded. As you can see, at the begening of the code I pasted, you should see:

Expand|Select|Wrap|Line Numbers

<cfset REQUEST.FileCount = 5 />

But this only displays 5 Forms from which a user can select the 5 files to upload. Once these 5 files are uploaded, he/she can keep uploading more files.

Instead, I'd like to see a message stating "you already uploaded 5 files, sorry that was your limit"

I am also working to limit the filesize, let say only 1MB file is allowed.

But, If I can get help on having a user to upload up to 5 files, I would really appreciate that.

Thanks again, you have been very helpful.

@Karim
MoroccoUSA.com

acoder

Use session variables to keep track of the number of uploads by a user. For file size, use cffile.fileSize.

Multiple files upload while updating DB

✓ answered by acoder

Post your reply

Similar topics