Jump to content


Photo

session variable


  • Please log in to reply
1 reply to this topic

#1 keyboard

keyboard
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 12 February 2005 - 03:24 PM

1) I have a login page which writes username and password into a database. After login the server behavior swich to a login_ok.php or a login_fail.php. Thusfar every works fine. But in the login_ok I want to use the session variable MM_username created by the login page. In the datababindings panel I created a session variable MM_username and dragt it into the page. This doesn't work. What do I do wrong?
I have even defined a recordset in the login page: session variable = MM_username. Still no succes.

2) Can I use the session variable MM_UserGroup to display the access level of the user?


This my login page :
php require_once('Connections/conn_Dmenu.php');

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'Connections/conn_Dmenu.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>
<?php
mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_conn_Dmenu[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$conn_Dmenu[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$query_rstUsers [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM tblUsers\"[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$rstUsers [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_rstUsers[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$conn_Dmenu[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]());
[/span][span style=\"color:#0000BB\"]$row_rstUsers [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$rstUsers[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$totalRows_rstUsers [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_num_rows[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$rstUsers[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]?>
<?php
[/span][span style=\"color:#FF8000\"]// *** Validate request to login to this site.
[/span][span style=\"color:#0000BB\"]session_start[/span][span style=\"color:#007700\"]();

[/span][span style=\"color:#0000BB\"]$loginFormAction [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_SERVER[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'PHP_SELF\'[/span][span style=\"color:#007700\"]];
if (isset([/span][span style=\"color:#0000BB\"]$accesscheck[/span][span style=\"color:#007700\"])) {
  [/span][span style=\"color:#0000BB\"]$GLOBALS[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'PrevUrl\'[/span][span style=\"color:#007700\"]] = [/span][span style=\"color:#0000BB\"]$accesscheck[/span][span style=\"color:#007700\"];
  [/span][span style=\"color:#0000BB\"]session_register[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\'PrevUrl\'[/span][span style=\"color:#007700\"]);
}

if (isset([/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Username\'[/span][span style=\"color:#007700\"]])) {
  [/span][span style=\"color:#0000BB\"]$loginUsername[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'Username\'[/span][span style=\"color:#007700\"]];
  [/span][span style=\"color:#0000BB\"]$password[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]$_POST[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'UserPw\'[/span][span style=\"color:#007700\"]];
  [/span][span style=\"color:#0000BB\"]$MM_fldUserAuthorization [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"UserStatus\"[/span][span style=\"color:#007700\"];
  [/span][span style=\"color:#0000BB\"]$MM_redirectLoginSuccess [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"login_ok.php\"[/span][span style=\"color:#007700\"];
  [/span][span style=\"color:#0000BB\"]$MM_redirectLoginFailed [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"login_fail.php\"[/span][span style=\"color:#007700\"];
  [/span][span style=\"color:#0000BB\"]$MM_redirecttoReferrer [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]false[/span][span style=\"color:#007700\"];
  [/span][span style=\"color:#0000BB\"]mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_conn_Dmenu[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$conn_Dmenu[/span][span style=\"color:#007700\"]);
      
  [/span][span style=\"color:#0000BB\"]$LoginRS__query[/span][span style=\"color:#007700\"]=[/span][span style=\"color:#0000BB\"]sprintf[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"SELECT UserName, UserPw, UserStatus FROM tblUsers WHERE UserName=\'%s\' AND UserPw=\'%s\'\"[/span][span style=\"color:#007700\"],
  [/span][span style=\"color:#0000BB\"]get_magic_quotes_gpc[/span][span style=\"color:#007700\"]() ? [/span][span style=\"color:#0000BB\"]$loginUsername [/span][span style=\"color:#007700\"]: [/span][span style=\"color:#0000BB\"]addslashes[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$loginUsername[/span][span style=\"color:#007700\"]), [/span][span style=\"color:#0000BB\"]get_magic_quotes_gpc[/span][span style=\"color:#007700\"]() ? [/span][span style=\"color:#0000BB\"]$password [/span][span style=\"color:#007700\"]: [/span][span style=\"color:#0000BB\"]addslashes[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$password[/span][span style=\"color:#007700\"]));
   
  [/span][span style=\"color:#0000BB\"]$LoginRS [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$LoginRS__query[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$conn_Dmenu[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]());
  [/span][span style=\"color:#0000BB\"]$loginFoundUser [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_num_rows[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$LoginRS[/span][span style=\"color:#007700\"]);
  if ([/span][span style=\"color:#0000BB\"]$loginFoundUser[/span][span style=\"color:#007700\"]) {
    
    [/span][span style=\"color:#0000BB\"]$loginStrGroup  [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_result[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$LoginRS[/span][span style=\"color:#007700\"],[/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"],[/span][span style=\"color:#DD0000\"]\'UserStatus\'[/span][span style=\"color:#007700\"]);
    
    [/span][span style=\"color:#FF8000\"]//declare two session variables and assign them
    [/span][span style=\"color:#0000BB\"]$GLOBALS[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'MM_Username\'[/span][span style=\"color:#007700\"]] = [/span][span style=\"color:#0000BB\"]$loginUsername[/span][span style=\"color:#007700\"];
    [/span][span style=\"color:#0000BB\"]$GLOBALS[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'MM_UserGroup\'[/span][span style=\"color:#007700\"]] = [/span][span style=\"color:#0000BB\"]$loginStrGroup[/span][span style=\"color:#007700\"];          

    [/span][span style=\"color:#FF8000\"]//register the session variables
    [/span][span style=\"color:#0000BB\"]session_register[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"MM_Username\"[/span][span style=\"color:#007700\"]);
    [/span][span style=\"color:#0000BB\"]session_register[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"MM_UserGroup\"[/span][span style=\"color:#007700\"]);

    if (isset([/span][span style=\"color:#0000BB\"]$_SESSION[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'PrevUrl\'[/span][span style=\"color:#007700\"]]) && [/span][span style=\"color:#0000BB\"]false[/span][span style=\"color:#007700\"]) {
      [/span][span style=\"color:#0000BB\"]$MM_redirectLoginSuccess [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_SESSION[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'PrevUrl\'[/span][span style=\"color:#007700\"]];    
    }
    [/span][span style=\"color:#0000BB\"]header[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"Location: \" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$MM_redirectLoginSuccess [/span][span style=\"color:#007700\"]);
  }
  else {
    [/span][span style=\"color:#0000BB\"]header[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"Location: \"[/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]$MM_redirectLoginFailed [/span][span style=\"color:#007700\"]);
  }
}
[/span][span style=\"color:#0000BB\"]?>
[/span]
[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
*************************************************************
This is my login_ok page:
<body>
<h4>Login succesfull</h4>
<p>You are loged in as : <?php echo $_SESSION['MM_Username']; ?></p>
<p>Your status is :    </p>
<p><a href="index.php">Back to homepage</a> </p>
</body>
</html>


#2 keyboard

keyboard
  • New Members
  • Pip
  • Newbie
  • 2 posts

Posted 19 February 2005 - 04:07 PM

DW doesn't add the code 'session_start()' automatically to the login_ok page when dragging the session var to the login_ok page. . I had to insert it manually into the code. Every page where I use a session variable must have this piece of code.

Now it works :-)
Anybody knows why DW doesn't add this code by default when you drag a session variable into a php-page.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users