[Resolved] Using session data

Hitoshi

Ok this one's easy... but i can't do it. lol

I have this login script that WORKS and I need to know how I use the data from the user that is logged in. How do I turn the session data into variables? and how do i select additional infomation for the session, such as user rank etc?

<?php  



$authorized = FALSE;   


if ( (isset($_SERVER['PHP_AUTH_USER']) AND isset($_SERVER['PHP_AUTH_PW'])) ) { 



define ('username', 'hitoshi_admin'); 

define ('password', '****'); 

define ('localhost', 'localhost'); 

define ('sitename', 'www.PSOrevolution.com'); 



$dbc = @mysql_connect (localhost, hitoshi_admin, ****) OR die ('Could not connect to MySQL: ' . mysql_error() ); 

mysql_select_db (hitoshi_web) OR die ('Could not select the database: ' . mysql_error() ); 


$query = "SELECT first_name FROM users WHERE username='{$_SERVER['PHP_AUTH_USER']}' and password=PASSWORD('{$_SERVER['PHP_AUTH_PW']}')"; 

$result = mysql_query ($query); 
    $row = @mysql_fetch_array ($result); 


if ($row)  

{  

$authorized = TRUE;  

$_SESSION['username'] =  $_SERVER['PHP_AUTH_USER'];
session_start(); 
session_register("var1", "var2"); 
$var1 = $username; 
$var2 = $username;  

    }
}

if (!$authorized) { 

header('WWW-Authenticate: Basic realm="Log in to experiance PSO Revolution, where two worlds collide!"'); 

header('HTTP/1.0 401 Unauthorized'); 
echo ' 
<html> 
<head> 
<title>Signup Form</title> 
</head> 
<body> 
<form name=form1 method=post action=register.php> 
<table width=100% border=0 cellpadding=4 cellspacing=0> 
<tr> 
<td width=24% align=left valign=top>First Name</td> 
<td width=76%><input name=first_name type=text id=first_name2></td> 
</tr> 
<tr> 
<td align=left valign=top>Last Name</td> 
<td><input name=last_name type=text id=last_name></td> 
</tr> 
<tr> 
<td align=left valign=top>Email Address</td> 
<td><input name=email_address type=text id=email_address></td> 
</tr> 
<tr> 
<td align=left valign=top>Desired Username</td> 
<td><input name=username type=text id=username></td> 
</tr> 
<tr> 
<td align=left valign=top>Information about you:</td> 
<td><textarea name=info id=info></textarea></td> </tr> 
<tr> 
<td align=left valign=top>&nbsp;</td> 
<td><input type=submit name=Submit value=Join Now!></td> 
</tr> 
</table> 
</form> 
</body> 
</html> 
'; 
exit;  

} 
?> 
<body bgcolor="00000" text="ffffff"> 
<center> 
<font face="arial" size="0"> 
Welcome, 
<?php 
echo "{$_SERVER['PHP_AUTH_USER']}"; 
?><br> 
Authenticated!<br> 
Please <a href="index.php">proceed.</a> 
</center>

stolzyboy

first of all, session_start();, has to be the first line in your page, secondly, you can set session variables with

$_SESSION['variableyouwant'] = "value"; //or diff variable

then you can see what the session variable's value is by doing

echo $_SESSION['variableyouwant'];

Hitoshi

I'm including a PHP header and footer. I want the data to be displayed in the footer. Do I put the session start at the top of the "footer.inc" file?

tekky

I'll add the comment that define() is used to setup CONSTANTS, not session variables also, and I believe session_register() is another method of assigning session variables

stolzyboy

Originally posted by Hitoshi
I'm including a PHP header and footer. I want the data to be displayed in the footer. Do I put the session start at the top of the "footer.inc" file?

NO, session_start(); has to be the first line in the whole document, before anything else, even includes

Hitoshi

Ok i have tried this over and over and nothing seems to be working... so I came up with a new idea..

This works fine

echo "{$_SERVER['PHP_AUTH_USER']}";

So why can't I use this to select the relevant data??

I tried to run a query like this :

<?php
session_start();

require_once ('mysql_connect.php');

$sql = 'SELECT HP FROM users WHERE username = {$_SERVER['PHP_AUTH_USER']}';  

$res = mysql_query($sql) or die("Query Error: ".mysql_error());  

$data = mysql_fetch_array($res) or die("Fetch Error: ".mysql_error());
$hp = $data[HP];  

?>

I keep getting errors... what is the correct way to put

{$_SERVER['PHP_AUTH_USER']}

into the the place of username to be used in the query to select the data??

stolzyboy

don't know where you are in need of session_start(); in your example, but do the code like this

<?php 
session_start(); 

require_once ('mysql_connect.php'); 

$sql = "SELECT HP FROM users WHERE username = '" . $_SERVER['PHP_AUTH_USER'] . "';";   

$res = mysql_query($sql) or die("Query Error: ".mysql_error());   

$data = mysql_fetch_array($res) or die("Fetch Error: ".mysql_error()); 
$hp = $data[HP];   

?>

Hitoshi

the session start was there becoz that was the top of the page.

I have done this as you just said.

<?php
session_start();

require_once ('mysql_connect.php');
$sql = "SELECT HP FROM users WHERE username = '" . $_SERVER['PHP_AUTH_USER'] . "';";    

$res = mysql_query($sql) or die("Query Error: ".mysql_error());    

$data = mysql_fetch_array($res) or die("Fetch Error: ".mysql_error());  

$hp = $data[HP];
?>

later i have some code which is supposed to display "HP" :

<?php
echo $HP;
?>

Have I done this wrong? is the echo done right?
Nothing appears. it's just blank where the HP should be

Hitoshi

ooops.
I just realised that i had hp, and later HP.
ok, this time i dont get a blank page i get this :

Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /home/hitoshi/public_html/index.php:2) in /home/hitoshi/public_html/index.php on line 3

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/hitoshi/public_html/index.php:2) in /home/hitoshi/public_html/index.php on line 3
Fetch Error:

This is the entire code for my page now...

<html>
<?php
session_start();

require_once ('mysql_connect.php');
$sql = "SELECT HP FROM users WHERE username = '" . $_SERVER['PHP_AUTH_USER'] . "';";    

$res = mysql_query($sql) or die("Query Error: ".mysql_error());    

$data = mysql_fetch_array($res) or die("Fetch Error: ".mysql_error());  

$hp = $data[HP];
?>
<?php
$page_title = 'PSO Revolution';
include ('./header.inc');
?>
<table width="100%" border="0">
<TR>

            <TD BGCOLOR=#FFFCDF
 width="100%" valign="top">
                <font face=arial color=#000000 size="1"><b>
<center><u>PSOrevolution.com<br>Where the two worlds of<br>Romance of The Three Kingdoms &<br> Phantasy Star Online<br>Collide</u><br><img src="wu.gif"><img src="wei.gif"><img src="shu.gif"></center>
<br>
<table>
<tr>
<td valign="top">
<iframe id="poem" src="poem.htm" width="200" height="20" scrolling="no" marginwidth="0" marginheight="0" hspace="0" vspace=0 frameborder="0"></iframe>
<br>
<iframe id="datamain" src="external.htm" width=150 height=150 marginwidth=0 marginheight=0 hspace=0 vspace=0 frameborder=0 scrolling=no></iframe><br><br><br>
<font face=arial color=#000000 size="1"><b><center>
--><a href="http://www.topsitelists.com/topsites.cgi?ID=248&user=psodirect&area=games"><img src="http://psorevolution.com/top100.gif" border="0"></a><--
<br>~Voting Gateway~<Br><br>

--><iframe id="counter" src="hit.htm" width="50" height="12" scrolling="no" marginwidth="0" marginheight="0" hspace="0" vspace=0 frameborder="0"></iframe><--<br>~Unique IP Hits~<Br><br>
--><?php 
echo "{$_SERVER['PHP_AUTH_USER']}"; ?><--<br>
-->
<?php
echo $hp;
?><--<br>
~Your Stats~<br>
</td>
<td valign="top">
----MAIN PAGE CONTENT---
</td>
</tr>
</table> 
</font>
</TR>
<?php
include ('templates/footer.inc');
?>
</html>

stolzyboy

<?
session_start();

those should be the first two lines of the whole document, you have <html> before it

Hitoshi

I'm not even logged in and im getting this :

Fetch Error:

Hitoshi

WAIT! IVE GOT IT!!
that's it! it works! 😐

but when no user is logged in.. it comes up with the error. how can i eliminate this? can i put somthing like : If (user=null) {
PAGE CONTENT
}

else {
(logged in)
}

how do i achieve this?

Hitoshi

This thread is solved. Thank you everyone for your help ^_