Solved

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

Posted on 2004-04-27
8
211 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
  • 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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

766 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