To: Vinny Lape
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] User authentication and redirect
hi Vinny,
On 7/13/05, Vinny Lape [EMAIL PROTECTED] wrote:
If user validates then look at db entry location then redirect to
mydomain.com/location/index.php
i don't think it's a good idea. what
: RE: [PHP-DB] User authentication and redirect
Date: Fri, 15 Jul 2005 09:01:52 -0400
I think I need to explain my question better.
I have a db and the table contains 4 fields uid(pk) username password
location
I can authenticate the user / pass properly. The problem I am having is
getting
-db@lists.php.net
Subject: RE: [PHP-DB] User authentication and redirect
Date: Fri, 15 Jul 2005 09:01:52 -0400
I think I need to explain my question better.
I have a db and the table contains 4 fields uid(pk) username password
location
I can authenticate the user / pass properly. The problem I am
hi Vinny,
On 7/13/05, Vinny Lape [EMAIL PROTECTED] wrote:
If user validates then look at db entry location then redirect to
mydomain.com/location/index.php
i don't think it's a good idea. what if the user bookmarked or took
down a notice with the URL to your secured page
Ahmed Saad wrote:
hi Vinny,
On 7/13/05, Vinny Lape [EMAIL PROTECTED] wrote:
If user validates then look at db entry location then redirect to
mydomain.com/location/index.php
i don't think it's a good idea. what if the user bookmarked or took
down a notice with the URL to your
I am trying to make a login script that will check a mysql db for usernme,
password and location.
If user validates then look at db entry location then redirect to
mydomain.com/location/index.php
Anyone have an idea about this?
Thanks
Vinny
--
PHP Database Mailing List (http://www.php.net/)
To
if (authorized($user)) {
header(Location: http://mydomain.com/$user/index.php;);
}
On Wednesday 13 July 2005 1:13 pm, Vinny Lape wrote:
I am trying to make a login script that will check a mysql db for usernme,
password and location.
If user validates then look at db entry location
Vinny Lape a écrit :
I am trying to make a login script that will check a mysql db for usernme,
password and location.
If user validates then look at db entry location then redirect to
mydomain.com/location/index.php
Anyone have an idea about this?
header(Location: /somewhere/index.php) ;
Hello,
I could use some help here. I have a script that checks a user name
and password against the MySQL DB. I have it set as a function so I
included/require it on the page. Here is the script:
function login($username, $password)
// check username and password with db
{
// connect to db
Craig Hoffman wrote:
$result = (select user_id password FROM users WHERE
username='$username' AND password=md5('$password'));
password is a reserved word. try this instead:
$result = (select user_id password FROM users WHERE
username='$username' AND `password`=md5('$password'));
Erwin Kerk
Try fixing your SQL:
$result = (select user_id, password FROM users WHERE username='$username'...
You forgot a comma between user_id and password.
On Fri, 27 Feb 2004, Craig Hoffman wrote:
// check if username
$result = (select user_id password FROM users WHERE
username='$username'
Peter Beckman wrote:
Try fixing your SQL:
$result = (select user_id, password FROM users WHERE username='$username'...
You forgot a comma between user_id and password.
Yup, that too. Oops, missed it too.
Erwin Kerk
Web Developer
--
PHP Database Mailing List (http://www.php.net/)
To
On Friday 27 February 2004 22:26, Craig Hoffman wrote:
I could use some help here. I have a script that checks a user name
and password against the MySQL DB. I have it set as a function so I
included/require it on the page. Here is the script:
[snip]
When I change the return false to
Jason Wong wrote:
You aren't actually performing any queries -- you're missing a mysql_query().
Ah. Did i mis that too? Unbelievable
Erwin Kerk
Web Developer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks - I can't believe I missed that. :(
Craig
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimbmedia.com
_
On Feb 27, 2004, at 8:34 AM, Jason Wong wrote:
On Friday 27
On Friday 27 February 2004 22:42, Craig Hoffman wrote:
Thanks - I can't believe I missed that. :(
And I'm sure you'll want to stick in a mysql_error() as well.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
* Web Design Hosting * Internet
I have this script which is giving me a couple of problems -
1 - I cannot use include ../connect.inc, I get headers already sent error
2 - I can use this script once, but if I try to reload the page to continue
testing I get error Unable to execute query. Clearing the browsers cache
does not
Hi all,
I'm still trying to get my site to work just right. Basically I'm
building a "secure" portal. What I want to do is:
1) get user info from form
2) submit name password to query template
3) query template checks login:::
i) if good - needs to...
a) initialize this user's
18 matches
Mail list logo
