Re: User Authentication

From: Date: Tue, 18 Mar 2003 18:14:04 +0000
Subject: Re: User Authentication
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-140154@lists.php.net to get a copy of this message
"Chris Shiflett" <shiflett@php.net> wrote in message news:20030318162508.83387.qmail@web14305.mail.yahoo.com... > --- shaun <shaun@mania.plus.com> wrote: > > Using the following code I am able to authenticate which type of user is > > visiting my page, however if I try to log in again with a different type of > > user the session variables still assume that the original user was logged > > in, is there a way to reset the session variables, I have tried > > session_destroy() and session_unset() but without success... > > > > <?php > > require("dbconnect.php"); > > > > // Assume user is not authenticated > > $auth = false; > > > > // Formulate the query > > $query = "SELECT * FROM WMS_User WHERE > > User_Username = '$_POST[username]' AND > > User_Password = '$_POST[password]'"; > > > > // Execute the query and put results in $result > > $result = mysql_query( $query ) > > or die ( 'Unable to execute query.' ); > > > > // Get number of rows in $result. > > $num = mysql_numrows( $result ); > > > > if ( $num != 0 ) { > > > > // A matching row was found - the user is authenticated. > > $auth = true; > > > > //get the data for the session variables > > $suser_name = mysql_result($result, 0, "User_Name"); > > $suser_password = mysql_result($result, 0, "User_Password"); > > $stype_level = mysql_result($result, 0, "User_Type"); > > > > $ses_name = $suser_name; > > $ses_pass = $suser_password; > > $ses_level = $stype_level; > > > > session_register("ses_name"); > > session_register("ses_pass"); > > session_register("ses_level"); > > This is the moment where you lose your new session data. You need to register > your session variables before you use them. At this point, PHP retrieves the > session data that is saved for you, and you lose all of the stuff you did > above. > > Chris > > ===== > Become a better Web developer with the HTTP Developer's Handbook > http://httphandbook.org/ sorry but you have lost me, surely the session_register(); function is storing what I have done above this point, if not then how would I store the new values instead?

« previous php.general (#140154) next »