Re: [PHP-DB] User authentication and redirect

2005-07-15 Thread Thomas Dodson
From: "Vinny Lape" <[EMAIL PROTECTED]> To: 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 authentic

RE: [PHP-DB] User authentication and redirect

2005-07-15 Thread Bastien Koert
.= "?" . $QUERY_STRING; $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer); header("Location: ". $MM_restrictGoTo); exit; } ?> -Original Message- From: Ahmed Saad [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005

RE: [PHP-DB] User authentication and redirect

2005-07-15 Thread Vinny Lape
header("Location: ". $MM_restrictGoTo); exit; } ?> -Original Message- From: Ahmed Saad [mailto:[EMAIL PROTECTED] Sent: Thursday, July 14, 2005 8:34 AM To: Vinny Lape Cc: php-db@lists.php.net Subject: Re: [PHP-DB] User authentication and redirect hi Vinny, On 7

Re: [PHP-DB] User authentication and redirect

2005-07-14 Thread Thomas Dodson
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 "se

Re: [PHP-DB] User authentication and redirect

2005-07-14 Thread Ahmed Saad
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 (mydomain.com/l

Re: [PHP-DB] User authentication and redirect

2005-07-13 Thread Alain Rivest
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"

Re: [PHP-DB] User authentication and redirect

2005-07-13 Thread Micah Stevens
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 loca

Re: [PHP-DB] User Authentication

2004-02-27 Thread Jason Wong
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 &

Re: [PHP-DB] User Authentication

2004-02-27 Thread Craig Hoffman
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 Februa

Re: [PHP-DB] User Authentication

2004-02-27 Thread Erwin Kerk
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

Re: [PHP-DB] User Authentication

2004-02-27 Thread Jason Wong
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" t

Re: [PHP-DB] User Authentication

2004-02-27 Thread Erwin Kerk
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 unsubscribe

Re: [PHP-DB] User Authentication

2004-02-27 Thread Peter Beckman
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

Re: [PHP-DB] User Authentication

2004-02-27 Thread Erwin Kerk
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 Ke