Duh, of course switch hosts. Is this just for some cheesey operation, or is
it a serious application. If this is suppose to be serious, then splurge the
$10/month for a host with php/mysql. Or, use a DB remotely.
As far as redirection.... you don't need to redirect, or use some crazy
authentication scheme. All you do is have them go to myaccounts.php. It has
a login and password. Query the DB, see if it matches. If it does pass it to
the query statement--> SELECT * FROM $agentlogin;
And for the different schemes on prices... its not hard to add a coulumn
that defines the scheme.
Anyways, in a nutshell, get a real host. Use PHP based authorization. Don't
do redirects, just query the DB based on the login name. If you there's more
than one part/page to the application you can use sessions or set a cookie.
No, you do not need to put a cookie on a disk, you set it in the browser
when you access the page.
-----Original Message-----
From: olinux [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 10:35 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] redirection based on login username
*PHP is supported but there is no mySQL access on this host [not sure what
the point is... maybe I should just tell them to switch hosts...] I am
looking to see if i can connect to a freeservers sql DB [www.f2s.com]
*It will be for agents who are logging in, depending on their assigned
username they should be directed to THEIR pricing schedule, currently there
are three different price schemes
*I would like it to be expandable from the current [a new company, they are
looking to grow fairly large... naturally]
MY THOUGHTS
*I only know how to do DB based authentication, so the agent may have to
login TWICE [one for PHP redirect, another for apache protected dir.
*Cookies might be the best way to go, (agent logs in to a gateway page that
reads the cookie value and directs to according page) I don't like this cuz
where does the cookie initially get set [give them each a disk with THEIR
cookie on it?]
*agent ID's could be assigned like this
AGENT001
AGENT101
AGENT202
Then the script could direct to up to [10 price schedules, by using AGENT0,
AGENT1, AGENT2, get it?] or [100 price schedules, if you extended to the
second number AGENT01, AGENT02, AGENT10, AGENT11] etc. each could
theoretically have unlimited agents. Just keep adding numbers after the
"base" ID
So, anyone have any ideas to go about this, I don't think that I can use a
DB, unless maybe it was a flat text file... [never worked with those
before:)]
Thanks Much
olinux
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
