close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dataassist help regarding displaying PDF files.

Thread began 6/17/2014 9:09 am by Kumel | Last modified 6/17/2014 2:26 pm by Jason Byrnes | 983 views | 10 replies |

Kumel

Dataassist help regarding displaying PDF files.

1- I have a registration page where a user registers & then all his details are shown in home page.
2- I have created a page where admin can upload pdf files into a folder & this is stored in data base (its linked with userid of user to whom it is needed).
entries are: userid (to whom it is) , fileid( pdf file) , & filename ( name of pdf file) thats all.

now- i want to show these data for those users which the admin had uploaded for that particular user. I hope you are getting my point.

Please tell me how can this be done.

Ex:
Lets says admin uploads file named: 123.pdf & 234.pdf for user name: XYZ

So when XYZ logins, all files linked to his id must be shown. With PDF name & file to view or download.


I hope you can help me out with it.

I have created two different database: 1st is PCMS2_USER(all details about user when he registers) & 2nd is PCMS2_USERFILES (which has userid linking to that of user, fileid, & filename) thats all.


Regards

Sign in to reply to this post

Kumel

wel i have got this done myself.

So can you tell me how a admin can see list of files been uploaded for all? & then make it deleted by admin?

Sign in to reply to this post

Jason ByrnesWebAssist

Use Data Assist to create a results and delete page set for the table that contains the file names.

Sign in to reply to this post

Kumel

wel that was nice :) ok now i have only 3 columns in 1 is UserId FileID & Filename.

Now i want user name to be shown linked with UserID, which is from other table. How do i do that?

Sign in to reply to this post

Jason ByrnesWebAssist

use a join query:

http://www.w3schools.com/sql/sql_join.asp

Sign in to reply to this post

Kumel

Well i got that, this is what i got:
SELECT pcms2_userfiles.userid, pcms2_users.UserCompanyName
FROM pcms2_userfiles
INNER JOIN pcms2_users
ON pcms2_userfiles.userid=pcms2_users.UserID


But results aren't showing up properly.

Results are just showing that of one customer. (name)

please find attached DB.

Sign in to reply to this post

Jason ByrnesWebAssist

use a repeat region on the results page to loop through the entire recordset.

if you need help in setting this up, we can help through a premiere support appointment:
http://www.webassist.com/premier_request.php

Sign in to reply to this post

Kumel

I have used repeat region. still it ain't showing other results.

Attached Files
pcms2_userfiles_Results.php
Sign in to reply to this post

Jason ByrnesWebAssist

if you need help in setting this up, we can help through a premiere support appointment:
http://www.webassist.com/premier_request.php

Sign in to reply to this post

Kumel

I don't understand why i need to pay for the service. I thought the service is free of cost. But here i can see that few of my problems will not get solved until i pay extra for it.
I m sure the problem which i m facing is very simple & can be solved easily. But i m not a coder. so.

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...