close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

User Profile Image

Thread began 11/13/2014 9:21 am by sebastian | Last modified 11/18/2014 11:48 am by Jason Byrnes | 2167 views | 12 replies |

sebastian

User Profile Image

Hey, i have a user registration system that SecurityAssist 2 has built for me along with some pages that i have added.

They read as follows:

Login.php, Registration.php, UserUpdate.php, ForgotPassword.php, UserLanding.php (displays session variables such as first name, last name, email address, etc), and UserINSERT.php (for admin to manually insert new users).

My question is, How do I add a file upload field to the Registration.php and UserINSERT.php pages for users to have a profile picture image/thumbnail that will display on the UserLanding.php page?

And how would i set it up in my users table for my database to receieve the image so i can display it on the landing page dynamically?

Sign in to reply to this post

Jason ByrnesWebAssist

You asked this in another thread as well, pease don't post the same question ion multiple threads.
the column in the database should be a strait text column

add the file field to the userinsert and registration page, then add the file upload server behavior.

the file upload server behavior will create a new binding group na,ed WA Uploaded Files(File Field Name) where File Field Name is the name of the file field.

in this binding group is a binding for server file name.

on the user insert and registration pages, edit the insert server behavior, and bind the image column to the server file name binding.

Sign in to reply to this post

sebastian

Sorry didn't mean to post it two times, after I posted it the page did not refresh with the newly added post so I made another one

Sign in to reply to this post

Jason ByrnesWebAssist

Saving the image to a session from the login and using that to show the image is fine.

Alternatively, the login saves the User ID to a session, you could create a recordset that filters the ID column of the users table on the user ID session that is saved to retroeve the image name.

as for the details page, the details link should pass the ID as a URL variable.

On the details page, you create a recordset that filters the ID on the URL variable to retrieve the information for the detail record.

See the Database starter kit tutorial for details on creating this, it is written for a products table, but the concept is the same:
http://www.webassist.com/tutorials/Getting-started-with-MySQL-and-dynamic-websites

Sign in to reply to this post

sebastian

"Alternatively, the login saves the User ID to a session, you could create a recordset that filters the ID column of the users table on the user ID session that is saved to retroeve the image name."

Can you tell me the steps to go about this and what pages to do it on?

I noticed if i register and choose a profile image, then log in, the picture does not load

It was working but now all of a sudden it just doesn't work. After I register or insert a user, when i go login with the account then go to the userLanding.php all i get is a blank question mark where the picture was supposed to be.

I know i am missing something somewhere but i've followed all of your steps to my knowledge

Here are the pages if this helps you

I appreciate it very much!

Attached Files
login.php
registration.php
userlanding.php
users_insert.php
users_results.php
Sign in to reply to this post

Jason ByrnesWebAssist

looking at your login page, the user ID iOS saved to a session named:
SecurityAssist_UserID

  Can you tell me the steps to go about this  



create a new recordset for the users table, in the filtering section set it to filter the UserID column Equal to Session "SecurityAssist_UserID"

use that recordset to set the image source similar to what is described in the Database starter kit tutorial:
http://www.webassist.com/tutorials/Getting-started-with-MySQL-and-dynamic-websites


  and what pages to do it on?  



On the page you wish to display the image

Sign in to reply to this post

sebastian

Jason, Why are you so awesome?

You're the man.. seriously.

Sign in to reply to this post

Jason ByrnesWebAssist

Glad to help.

Sign in to reply to this post

sebastian

Looks like this

Sign in to reply to this post

sebastian

V

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...