Session Issue: not showing names.

Sonic_Rage

I'm having a difficult time getting the sessions to work. I can have someone log in to the site, but it will not display their name. What am I doing wrong here?

Also, in the login function, the

$PHP_SELF

will not display in the source code.

Functions Page Code:

session_start(); // Does the session_start function go on the individual pages, or can it stay on the functions.php page?

if ($user && $passwd)
{
  // if the user has just tried to log in
  db_connect();
  $query = "select * from cpo_employees where user='$user' and passwd='$passwd'";
  $result = mysql_query($query);
  if (mysql_num_rows($result) >0 )
  {
    // if they are in the database register the user id
    $valid_user = $user;
    session_register("valid_user");
  }
}

function do_header($title)
 {
   echo"<HTML>\n"
         ."<HEAD><TITLE>$title</TITLE>\n";
   include('includes/meta.php');
   include('includes/styles.php');
   include('includes/scripts.php');
   echo"</HEAD>\n"
          ."<BODY>\n";
  echo"<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH=\"800\" BGCOLOR=\"#FFFFFF\">\n"
        ."<TR><TD WIDTH=150><P CLASS=\"heading\">".date('F jS Y')."</TD>"
        ."<TD WIDTH=500 ALIGN=\"center\"><P CLASS=\"heading\">$title</TD>"
        ."<TD ALIGN=right WIDTH=150><P CLASS=\"heading\">";

//Show Valid Users Name :: This part is not working!

  if (session_is_registered("valid_user"))
  {
  echo "<P class=\"heading\">Welcome $valid_user\n ";
   }
  else
  { 
   echo "<P class=\"heading\">Welcome\n ";
  }

  echo"</TD></TR></TABLE>\n"
 }


// The $PHP_SELF will not show in the view source, not printing to screen.

function login()
 {
   open_table('0','2','2','180','#FFFFFF');
   echo"<TR><TD BGCOLOR=black><P CLASS=heading>Login:</TD></TR>\n";

// ".$PHP_SELF." this isn't printing on screen

   echo"<FORM ACTION=\"".$PHP_SELF."\" METHOD=post>\n"
         ."<TR><TD><P>User Name: <INPUT TYPE=\"text\" Name=\"user\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
         ."<TR><TD><P>Password: &nbsp; <INPUT TYPE=\"password\" Name=\"passwd\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
         ."<TR><TD><P><INPUT style=\"cursor:hand;background:#ddffff; border-color:#0000ff; font-weight: bold; font-size:9pt; color:#000000\" TYPE=\"submit\" VALUE=\"Login\"></TD></TR>\n"
        ."</FORM>\n";
   close_table();
 }

Index Page Code:

<?
session_start();
do_header('home');

login();

do_footer();
?>

Thanks for the much needed help!!!😃

dalecosp

The variable is in the superglobal SERVER array:

echo $SERVER_['PHP_SELF'];

dalecosp

AAMOF, it's a good idea to do all coding in the RG=off style.

if ($user=="OK") {
     $SESSION['valid_user']=$user;

Try your script like that, and tell us your results?

HTH,

Sonic_Rage

Tried that with the $SERVER_['PHP_SELF'];, still doesn't show in the source code so that way I will know if it's working.

Also, the session thing still isn't working. :-(

Thanks though.

Sonic_Rage

I'm sorry, I'm a bit lost here, where does this piece of code go?

if ($user=="OK") {
     $SESSION['valid_user']=$user;

and where it says $user == OK, where does it check for 'OK'?

😕

dalecosp

That was an example.

We obviously need to talk a bit more about your problem.

For starters, to answer the question in your commented code (line 1), you need to do a session_start() on each page (in each script) where you intend to use session variables. It must be called prior to any output to the browser, including any whitespace. Note that this does not mean you can't do any logic prior to the call.

Secondly, this script you've shown, then, is just a function list---OK. Could we see an example of the script that calls the function as well?

Thirdly, about your environment. Is register globals on or off?

rklapwijk

Have you tested if sessions even work at all?

page1.php
----------

<?php
session_start();
$user = "testme";
session_register('user');
?>
<a href="page2.php">Check if a session has been set</a>

page2.php
----------
<?php
session_start();
if (IsSet($HTTP_SESSION_VARS["user"]) && $HTTP_SESSION_VARS["user"] != "") {
$user = $HTTP_SESSION_VARS["user"];
echo "Sessions work, user: $user";
}
else echo "Sorry, but sessons do not work";
?>

jassh

dude...

dunno if this info would help.. but...

i'm just taking a hunch here..
ur using PHP + MYSQL on apache with a windows platform..right???

if my psychic ability is correct (i always wanted to say that)
you havent actually configure the session folder thingy..

i encountered the same problem..
so i refer to the manual... then i found out why my session didnt work. (or better said, Exist)

i think you should open php.ini,
search for the session folder settings,
and set it to a valid folder..
cause if there's no session folder,
then php dunno where to place that weird long file name
where your session info is stored..
and owh.. dont worry if you see the folder fill with weird file,
eventually it will clean itself (if not cleaned by session_destory()😉

but if you have set up the folder, then i guess that was not the case.

hope that helps..
good luck though...

cheers...
-jassh

p/s: i normally have problem with ['PHP_SELF'],
so i normally use $_SERVER['SCRIPT_NAME']

Daveyz1983

Originally posted by Sonic_Rage
Tried that with the $SERVER_['PHP_SELF'];, still doesn't show in the source code so that way I will know if it's working.

Also, the session thing still isn't working. :-(

Thanks though.

try $_SERVER['PHP_SELF'] instead pal.

and for this part

if (session_is_registered("valid_user"))
{
echo "<P class=\"heading\">Welcome $valid_user\n ";
}
else
{
echo "<P class=\"heading\">Welcome\n ";
}

echo"</TD></TR></TABLE>\n"

change $valid_user to $_SESSION['valid_user']

Hope it helps.

Sonic_Rage

rklapwijk,

I tried your example and it did work, sessions are working on my server.

jassh,

I'm running on a Linux platform, sorry, your pyschic abilities need sharpening 😉

Daveyz1983,

That worked, it now shows the URL in the source code, thank you.

Again, this is how I have it set up, two pages to show you, the first will be the index.php page, then will be the functions.php page.

index.php:

<?
session_start(); //Start Session
require('functions.php');
do_header('Home Page');  // Place title name
do_menu();                        // Display Menu

/* Start Main Page Info */

open_table('0','2','2','384','#FFFFFF');
echo"<TR><TD BGCOLOR=black><P CLASS=heading>Featured Product</TD></TR>\n"
       ."<TR><TD><A HREF=\"products.php?&action=show&prod_id=13\">"
       ."<IMG SRC=\"images/featured-7145.jpg\" WIDTH=380 HEIGHT=218 BORDER=0 ALT=\"Click on Image to learn more!\">"
       ."</A></TD></TR>\n";
close_table();

do_footer();
?>

functions.php - This contains the login stuff and all.

<?
 session_start(); //Start Session

/* -------------------------------------- Database Config -------------------------------------------------------------- */

function db_connect()
{
   $result = @mysql_pconnect("localhost", "******", "******"); 
   if (!$result)
      return false;
   if (!@mysql_select_db("cpobase"))
      return false;
   return $result;
}

function db_result_to_array($result)
{
   $res_array = array();
   for ($count=0; $row = @mysql_fetch_array($result); $count++)
     $res_array[$count] = $row;
   return $res_array;
}


/* -------------------------------------- Validate Users -------------------------------------------------------------- */

if ($user && $passwd)
{
  // if the user has just tried to log in
  db_connect();
  $query = "select * from cpo_employees where user='$user' and passwd='$passwd'";
  $result = mysql_query($query);
  if (mysql_num_rows($result) >0 )
  {
    // if they are in the database register the user id
    $valid_user = $user;
    session_register("valid_user");
  }
}

function login()
 {
   open_table('0','2','2','180','#FFFFFF');
   echo"<TR><TD BGCOLOR=black><P CLASS=heading>Login:</TD></TR>\n";
   echo"<FORM ACTION=\"";
   echo $_SERVER['PHP_SELF'];
   echo"\" METHOD=post>\n"
         ."<TR><TD><P>User Name: <INPUT TYPE=\"text\" Name=\"user\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
         ."<TR><TD><P>Password: &nbsp; <INPUT TYPE=\"password\" Name=\"passwd\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
         ."<TR><TD><P><INPUT TYPE=\"submit\" VALUE=\"Login\"></TD></TR>\n"
        ."</FORM>\n";
   close_table();
 }

/* -------------------------------------- Table Functions ------------------------------------------------------------- */

function open_table($border,$cellspacing,$cellpadding,$width,$bgcolor)
 {
   echo "<TABLE BORDER=\"$border\" CELLSPACING=\"$cellspacing\" CELLPADDING=\"$cellpadding\" WIDTH=\"$width\" BGCOLOR=\"$bgcolor\">\n";
 }

function close_table()
 {
   echo "</TABLE>\n";
 }

/* --------------------------------------------- Head Functions ------------------------------------------------------------- */

function do_header($title)
 {
   echo"<HTML>\n"
         ."<HEAD><TITLE>$title</TITLE>\n";
   include('includes/meta.php');
   include('includes/styles.php');
   include('includes/scripts.php');
   echo"</HEAD>\n"
          ."<BODY>\n";
  open_table_border('800');
  echo"<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=2 WIDTH=\"800\" BGCOLOR=\"#FFFFFF\">\n"
        ."<TR><TD COLSPAN=2><TABLE BORDER=0 CELLPADDING=1 CELLSPACING=0 WIDTH=\"800\" BGCOLOR=\"#000033\">\n"
        ."<TR><TD COLSPAN=3><IMG SRC=\"images/logo.jpg\" Height=80 Width=800 border=0></TD></TR>\n"
        ."<TR><TD WIDTH=150><P CLASS=\"heading\">".date('F jS Y')."</TD><TD WIDTH=500 ALIGN=\"center\"><P CLASS=\"heading\">$title</TD>"
        ."<TD ALIGN=right WIDTH=150><P CLASS=\"heading\">";

//Would like to have it welcome the user by name otherwise it will just say welcome. This part is not working, not showing name.
  if (session_is_registered("valid_user"))
  {
  echo "<P class=\"heading\">Welcome $valid_user\n ";
   }
  else
  { 
   echo "<P class=\"heading\">Welcome\n ";
  }
  echo"</TD></TR></TABLE></TD></TR>\n"
        ."<TR VALIGN=\"top\"><TD WIDTH=180>\n";

 }

/* --------------------------------------------- Menu Functions ------------------------------------------------------------- */

function do_menu() //Creates Menu
 {
   open_table('0','1','1','100%','#FFFFFF');
   echo"<TR><TD COLSPAN=2 BGCOLOR=black><P CLASS=heading>Menu</TD></TR>\n";
   $conn = db_connect();
   $query = "select * from cpo_pages WHERE active='1'";
   $result = @mysql_query($query);
   $num_results = mysql_num_rows($result);
   $i = 0; 
    while($row = mysql_fetch_array($result))
      { 
        echo"<TR VALIGN=top><TD><IMG SRC=\"images/diamond_icon.gif\" WIDTH=10 HEIGHT=10 BORDER=0></TD><TD><A CLASS=\"menu\" HREF=\"".$row[url]."\">".$row[title]."</A></TD></TR>\n";
      }
   close_table();
   echo"<br>";

//Now lets check if the user is vaild, if so, remove login box and show menu specific for that users level, also display their name.

  if (session_is_registered("valid_user"))
  {
   open_table('0','2','2','180','#FFFFFF');
   echo"<TR><TD BGCOLOR=black><P CLASS=heading>Welcome ".$_SESSION['valid_user']."</TD></TR>\n";

//Show menus based on user levels
   db_connect();
   $query = "select * from cpo_employees WHERE user ='$valid_user'";
   $result = @mysql_query($query);
   $num_results = mysql_num_rows($result);
    $i = 0; 
    while($row = mysql_fetch_array($result))
     { 
    if ($row[level] == admin)
     {
       echo"<TR><TD><P class=\"menu\">\n";
       echo"&#149; <a class=\"menu\" href=\"admin.php\">Administrative</a><br>\n";
       echo"&#149; <a class=\"menu\" href=\"profiles.php\">Update Profile</a><br>\n";
       echo"</TD></TR>\n";
      }
    else if($row[level] == sales)
    {
       echo"<TR><TD><P class=\"menu\">\n";
       echo"&#149; <a class=\"menu\" href=\"profiles.php\">Update Profile</a><br>\n";
       echo"</TD></TR>\n";
      }
    else
    {
       echo"<TR><TD><P class=\"menu\">\n";
       echo"&#149; <a class=\"menu\" href=\"profiles.php\">Update Profile</a><br>\n";
       echo"</TD></TR>\n";
      } 
     }
   close_table();
  }

//If not login yet, show login box
  else
   {
   login();
  }
 }
}

/* --------------------------------------------- Footer Functions ------------------------------------------------------------- */

function do_footer()
 {
  echo"</TD></TR>\n"
         ."<TR><TD COLSPAN=2 BGCOLOR=\"#000033\">\n"
         ."<P ALIGN=center class=\"heading\">&copy 1999-".date('Y')." CPO LTD, INC. All rights reserved.\n"
         ."</TD></TR>\n" 
         ."</TABLE>\n";
  close_table_border();
  echo"</BODY>\n"
         ."</HTML>\n";
 }
?>

Thanks for all your help guys, this is kinda driving me nutz. I recently changed servers to another hosting company and I'm not sure how much different they are set up from my old one.

Sonic_Rage

Ok, an update. I've seem to be able to resolve most of the issues. The only issue I have right now is this, when you login, it seems like you have to reload the page a second time for it to show.

So basically you login, click submit button, page refreshes. Doesn't show any change, so have to refresh again, now it shows.

Here is my login box code:

function login()
 {
   open_table('0','2','2','180','#FFFFFF');
   echo"<TR><TD BGCOLOR=black><P CLASS=heading>Login:</TD></TR>\n";
   echo"<FORM ACTION=\"".$_SERVER['PHP_SELF']."\" METHOD=POST>\n"
         ."<TR><TD><P>User Name: <INPUT TYPE=\"text\" Name=\"user\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
         ."<TR><TD><P>Password: &nbsp; <INPUT TYPE=\"password\" Name=\"passwd\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
         ."<TR><TD><P><INPUT style=\"cursor:hand;background:#ddffff; border-color:#0000ff; font-weight: bold; font-size:9pt; color:#000000\" TYPE=\"submit\" VALUE=\"Login\"></TD></TR>\n"
        ."</FORM>\n";
   close_table();
 }

Basically, I want them from whatever page they are viewing, to login in and it will return to that page with them logged in, but can't quite seem to get around having to refresh a second time.

Also, each page starts with a session_start function.

Daveyz1983

Hi Pal, try the following method, and see whether it works

for this function

function login()
{
open_table('0','2','2','180','#FFFFFF');
echo"<TR><TD BGCOLOR=black><P CLASS=heading>Login:</TD></TR>\n";
echo"<FORM ACTION=\"";
echo $_SERVER['PHP_SELF'];
echo"\" METHOD=post>\n"
."<TR><TD><P>User Name: <INPUT TYPE=\"text\" Name=\"user\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
."<TR><TD><P>Password:   <INPUT TYPE=\"password\" Name=\"passwd\" SIZE=10 MAXLENGTH=30></TD></TR>\n"
."<TR><TD><P><INPUT TYPE=\"submit\" VALUE=\"Login\"></TD></TR>\n"
."</FORM>\n";
close_table();
}

set the action as

<? echo $_SERVER['PHP_SELF'] . SID; ?>

to carry the session the the form(AKA self) to process the form as well. This might remove the need to refresh a second time before it shows.

Sonic_Rage

Hmmm, I tried that out, but it didn't work still. Still had to refresh the page a second time.

dalecosp

$_DOH!

Sorry, dude, late night....