Skip to main content
Participant
September 12, 2006
Question

Uploading image

  • September 12, 2006
  • 2 replies
  • 465 views
I'm got a cool uploading images tutorial from Asfusion.com. I got it working but this is my issue. I created a db table called "photos", in the photos table I made two columns named "id" and "images". I'm allowing users to login and upload images to a folder on my server. I now want to save the name of the image that was uploaded, to my db column named "images" aswell as save the user id to my "id" column. I'm using SESSION.Auth.id .

I'm using a tabbed cfform to do this, what I'm trying to make happen is on one tab is the upload field and upload button, on the second tab I want to bind the images that was upload by a specifc user (called by the id) to a cfgrid and display all the images uploaded by that user. So I want to associate all the images of a specific user to there user id.

How do I send the users id through the query string to get saved to my db table called photos?

If my code is incorrect, can someone lead me in the right direction? Or is there an easier way to get what I nreed to get done?

Thanks
Rob


This is the upload code:

<cf_flashUpload label="Picture:" name="myfile2" fileTypes="*.jpg;*.png;*.gif" fileDescription="Image files" actionFile="upload.cfm" maxSize="500">


<cf_flashUploadInput buttonStyle="corner-radius: 10;" inputStyle="fontWeight:bold" inputWidth="190" uploadButton="true" uploadButtonLabel="Upload" chooseButtonLabel="Choose file" progressBar="true" progressInfo="true" required="yes" message="Please enter a valid file to upload!" />
</cf_flashUpload>

This is the processing script:

<cfif structkeyexists(form,"Filedata")>
<cffile action="UPLOAD" filefield="FileData" destination="#expandpath("\uploads")#" nameconflict="MAKEUNIQUE">
</cfif>


<CFQUERY DATASOURCE="#DataSource#">
INSERT into photos(images,id)
VALUES('#Trim(FORM.myfile2)#',
('#Trim(URL.SESSION.Auth.id)#')
</CFQUERY>
This topic has been closed for replies.

2 replies

infaAuthor
Participant
September 15, 2006
Ok, I'm new to cf so if I understand you, this is what I should do:

<cfinput
type="Text"
name="myimages" (This is the name of my image table)
value="SESSION.Auth.id"
size="20"
maxlength="100">

Now from here, do I ad this field above my upload field?
And does the user enter their id into this field before they uploading?

Could you perhaps write an example code of passing the value to the cfc. Again I'm new to cf, I understand what they are and how they work thanks ot Ben Forta's book, but I have not yet try to make one. this is the part of you message that has me puzzled:

"Then pass this over to the cfc via
the remoting and insert it into your db."

Thanks a lot Rick for your help.

Rob.
Inspiring
September 13, 2006
Add a cfinput to your for name it whatever your db field is and use
SESSION.Auth.id vaerable as the value. Then pass this over to the cfc via
the remoting and insert it into your db.

"infa" <webforumsuser@macromedia.com> wrote in message
news:ee5e7v$mgk$1@forums.macromedia.com...
> I'm got a cool uploading images tutorial from Asfusion.com. I got it
> working
> but this is my issue. I created a db table called "photos", in the photos
> table I made two columns named "id" and "images". I'm allowing users to
> login
> and upload images to a folder on my server. I now want to save the name
> of the
> image that was uploaded, to my db column named "images" aswell as save the
> user
> id to my "id" column. I'm using SESSION.Auth.id .
>
> I'm using a tabbed cfform to do this, what I'm trying to make happen is on
> one
> tab is the upload field and upload button, on the second tab I want to
> bind the
> images that was upload by a specifc user (called by the id) to a cfgrid
> and
> display all the images uploaded by that user. So I want to associate all
> the
> images of a specific user to there user id.
>
> How do I send the users id through the query string to get saved to my db
> table called photos?
>
> If my code is incorrect, can someone lead me in the right direction? Or is
> there an easier way to get what I nreed to get done?
>
> Thanks
> Rob
>
>
> This is the upload code:
>
> <cf_flashUpload label="Picture:" name="myfile2"
> fileTypes="*.jpg;*.png;*.gif"
> fileDescription="Image files" actionFile="upload.cfm" maxSize="500">
>
>
> <cf_flashUploadInput buttonStyle="corner-radius: 10;"
> inputStyle="fontWeight:bold" inputWidth="190" uploadButton="true"
> uploadButtonLabel="Upload" chooseButtonLabel="Choose file"
> progressBar="true"
> progressInfo="true" required="yes" message="Please enter a valid file to
> upload!" />
> </cf_flashUpload>
>
> This is the processing script:
>
> <cfif structkeyexists(form,"Filedata")>
> <cffile action="UPLOAD" filefield="FileData"
> destination="#expandpath("\uploads")#" nameconflict="MAKEUNIQUE">
> </cfif>
>
>
> <CFQUERY DATASOURCE="#DataSource#">
> INSERT into photos(images,id)
> VALUES('#Trim(FORM.myfile2)#',
> ('#Trim(URL.SESSION.Auth.id)#')
> </CFQUERY>
>
>