January 31st, 2004, 12:31 PM
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Boro, England
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
PHP MySQL Session Variables
Hey all,
having a spot of bother with my lame ass Final Project and was wondering if any of you bigger brains out there could help me as i left my spare bigger brain at home.
I'm creatin a members only section for an existing site. once users log in they will be able to view the publications that they subscribe to. so what i would like to do is save their usernames and passwords or User_ids as session variables so that as they continue thru the site it will show information relevant to them from the database. if you catch my drift.
now the problem is. i can't get the damn variables out there!!
my site currently works around 2 php pages, one with the form to fill in and the other that it posts to which then links to the main intro page. so here goes
* Please post code blocks within the appropriate [ code ] or [ php ] formatting tags *
PHP Code:
<?php
session start();
?>
<html>
<head>
<title>Listing 15.7 User Login Form</title>
</head>
<body>
<H1>Login Form</H1>
<FORM METHOD="POST" ACTION="listing15.8.php">
<P><STRONG>Username:</STRONG><BR>
<INPUT TYPE="text" NAME="username"></p>
<P><STRONG>Password:</STRONG><BR>
<INPUT TYPE="password" NAME="password"></p>
// this is settin the variable for the sessions from the values entered in the text box
<?php
$_SESSION[username];
$_SESSION[password];
?>
<P><INPUT TYPE="SUBMIT" NAME="submit" VALUE="Login"></P>
</FORM>
</body>
</html>
then it posts to this page
<?php
//check for required fields from the form
if ((!$_POST[username]) || (!$_POST[password])) {
header("Location: listing15.7.php");
exit;
}
//connect to server and select database
$conn = mysql_connect("blah", "blah", "blah") or die(mysql_error());
mysql_select_db("blah",$conn) or die(mysql_error());
//create and issue the query
$sql = "select f_name, l_name from auth_users where username = '$_POST[username]' AND password = password('$_POST[password]')";
$result = mysql_query($sql,$conn) or die(mysql_error());
//get the number of rows in the result set; should be 1 if a match
if (mysql_num_rows($result) == 1) {
//if authorized, get the values of f_name l_name
$f_name = mysql_result($result, 0, 'f_name');
$l_name = mysql_result($result, 0, 'l_name');
//prepare message for printing, and user menu
$msg = "<P>Welcome to the Erinys News Site $f_name $l_name </p>";
$msg .= "<ul><li><a href=\"main.html?<?php print SID;?>\">secret page</a></ul>";
} else {
//redirect back to login form if not authorized
header("Location: listing15.7.php")
;
exit;
}
?>
<HTML>
<HEAD>
<TITLE>Listing 15.7 </TITLE>
</HEAD>
<BODY>
<? print "$msg"; ?>
</BODY>
</HTML>
which should in turn open this page
<?php
session start();
?>
<html>
<head>
</head>
<body>
<p> blah blah blah </P>
<?php
print "<ul> <li> $_SESSION[username]\n <li> $_SESSION[password]\n<?UL>\n";
?>
</body>
</html>
if any of you can help i would just adore you for the rest of my long legged life.
Thanks
Natt 
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
