Login functionality

anthonyl · #1 (**permalink**) 08-30-2004, 08:53 AM

Hello there.
I have a requirement from a customer to implement a login functionality that will provide the user that has authenticated a list of numbers as well as access to protected word documents.
The numbers will be unique to each user but the word documents will be applicable to all logged in users.
My thinking is that I use protected directory and have links on their logged in page. Once they have logged in, they will have access to these documents.
East to upload by the customer.
What I am not sure of is how to handle the numbers -which are sales figures that will need to be maintained by the customer but unique for each logged in user.
Any thoughts on how to do these 2 but still keeping it easy enough for the customer to maintain?

steve0 · #2 (**permalink**) 08-30-2004, 04:52 PM

Depending on the system in place.. and code used..
there are several ways that may accomplish this..

White board.. high level description....

If there is some kind of internal user id; e.g. sales-personID, territoryID, employeeID..

Tie the internal ID to the user login id.. then
the all queries for information can be restricted by the login name which is carried on the environment.

An extra table.. and a JOIN query and you are in business.

anthonyl · #3 (**permalink**) 08-31-2004, 08:28 AM

So it would be a database of some sort to support this?
What about the management of the data? How would non-technical staff be able to upload new data on a daily basis?

Thanks for the advice.

php~pro · #4 (**permalink**) 08-31-2004, 04:37 PM

Use a serverside upload script. I fail to understand why you accepted the project if you lack the skills of database itegration and serverside coding. If you have zero or limited knowledge in this area, surely it would be better to be honest with the customer, rather than mess them around by missing deadlines etc.

anthonyl · #5 (**permalink**) 09-01-2004, 12:16 AM

Not entirely correct in the skills assumption. However, I never intended to do this work myself.
I wanted to explore possibilities to this requirement before getting into the detailed design with the person that will actually perform this.

You may ask that the person designing this would be able to determine the best solution. Well, possibly, but I would prefer to have more opinions expressed than just from one person hence my request here.