Solved

Redirection to a unique page based on user/pass in ASP

Posted on 2004-04-27
8
214 Views
Last Modified: 2010-04-06
I have a logon set up, but I'm looking to redirect the users to a page that will have info specifically for them.  I have considered storring the page in the database and then getting it once the pass/user are checked.  Also, I'm trying to figure out how to protect these pages.  I've thought of using the session variable to restrict access, but I could use some coding examples on this.  I'm a newbie with ASP, so as much step through as you can give would help.  I place a high value on this and I'm not in the same time crunch I was, but time is somewhat of a factor.
0
Comment
Question by:themikecooke
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 10

Assisted Solution

by:m8rix
m8rix earned 100 total points
ID: 10935925
First of all, read the tutorial on this page http://www.codefixer.com/tutorials/session_cookies.asp, it is very straight forward and easy to follow there.

In addition to that you can set a cookie:

Session("UserAccount")=Username

and query your database with this information.
0
 
LVL 6

Accepted Solution

by:
pkaleda earned 400 total points
ID: 10938837
Another great resource for ASP and all other web dev subjects is http://www.w3schools.com/.  You can start by reading ASP section.  they have an area for Sessions as well.

What I would do is store the information you want to show teh user in a database.  Tie it to a user id or username.  when they login, you can do this?

<%
session("Username") = rs("Username") ' rs is teh recordset from a database or you can use any other way to set it.
session("UserID") = rs("UserID")
%>

Then you create a single page that pulls the information from a database and displays it based on the user.

<%
Userid = Session("UserID")

conn=Connect String
sql = "Select * from userinfotable where userid = '"&userid&"'"
set rs = conn.execute(sql)

If not rs.eof then
on error resume next
while not rs.eof
response.write("here is your info "&rs("column1")&"<br />")
rs.movenext()
wend
end if
%>

Now you have one page that is used by all users, but the info displayed is taylored based on thier userid or username.

PK
 
0
 

Author Comment

by:themikecooke
ID: 10943911
PK
   I'm liking your solution.  Basically I have a ppt that I want the user to have access to and to be able to see.  Each presentation is tailored to the user.  I'm going to play with this solution a for another 12 hours before closing the question.  Thanks for the help!
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Expert Comment

by:pkaleda
ID: 10944289
Cool.  Glad I can help.  I think this is a great simple solution.
0
 
LVL 6

Expert Comment

by:pkaleda
ID: 10944298
You can also when they go to the page, have it auto redirect them to teh PPT so it opens without them having to click anything.
0
 
LVL 10

Expert Comment

by:m8rix
ID: 10944545
> First of all, read the tutorial on this page http://www.codefixer.com/tutorials/session_cookies.asp, it is very straight
> forward and easy to follow there.

> In addition to that you can set a cookie:
>
> Session("UserAccount")=Username
>
> and query your database with this information.

Thanks to PK for following on from my post and demonstrating on how to query your database with the user information I specified.

all you have to do now is store the ppt file name in a database field so when the user's log in has been authenticated you can then retrieve the personalised ppt file.

The best thing about this is that you can display any number of ppt files for each unique user.

Glad we could help.

m8rix
0
 
LVL 6

Expert Comment

by:pkaleda
ID: 10948860
Thank you for the A.  Glad we could help.
0
 

Author Comment

by:themikecooke
ID: 10956150
Can you give me some coding for how I might display the ppt files.  I would like to have them as pps files so that they simply run.  But, I can pull the location from the database, but how do I open the pps in a new window.  Any suggestions would be greatly appreciated.

Mike
0

Featured Post

Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you work with shopping cart / ecommerce relates web sites, you need to pass the certain form post details to the payment gateway process page with required details for the products items you give to order. Also you may need to track the ordered…
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question