start_session() help please

fjm · #1 May 21st, 2007, 11:12 PM

Hi all, I am new to php and am having trouble with a script. I *think* the problem is with start_session or register_session. Here are the two scripts that I am using.

Expand|Select|Wrap|Line Numbers

 <?

include("inc/config.php");

$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!");

$query = "SELECT * FROM clients WHERE name = '$name' AND password = PASSWORD('$password')";

$result = mysql_db_query($database, $query, $connection);

if (mysql_num_rows($result) == 1)

    {

    session_start();
 
    session_register("client_id");

    session_register("client_name");

    session_register("client_email");

    session_register("client_ref");

    session_register("client_title");

    list($clientid, $name, $pass, $email, $ref, $title) = mysql_fetch_row($result);

    $client_id = $clientid;

    $client_name = $name;

    $client_email = $email;

    $client_ref = $ref;

    $client_title = $title;
 
    header("Location: menu.php");

    mysql_free_result ($result);    
 
    mysql_close($connection);

    }

else
 
    {

    mysql_free_result ($result);    

    mysql_close($connection);
 
    header("Location: index.htm");

    exit;

    }

?>

and this one.

Expand|Select|Wrap|Line Numbers

 <?

session_start();

if(!session_is_registered("client_id"))

{

header("Location: index.htm");

exit;

}

?>

<html>

<link rel="stylesheet" href="inc/style.css" type="text/css">
 
<body bgcolor="#FFFFFF">

<img src="inc/title.gif" width="308" height="82">

<?

if ($client_name !== 'admin')

{

?>

<h2>Hello <b> 

  <? echo $client_name ?>

  </b> </h2>

  Here are your invoices:
 
<?

include "inc/dbconnect.php";

include ("inc/date.php");

$result = mysql_query("SELECT * FROM invoices WHERE clientid = '$client_id' ORDER BY $param",$db);

if (!$param) {

$result = mysql_query("SELECT * FROM invoices WHERE clientid = '$client_id' ORDER BY id",$db);

}

echo "<p><table border=1 cellspacing=0 cellpadding=2 bordercolor=#eeeeee width=400>";

echo "<tr align=top><td><b><a href='menu.php?param=id'>Invoice number</a></b></td><td><b><a href='menu.php?param=date'>Date</a></b></td><td><b><a href='menu.php?param=total'>Total</a></b></td><td><b><a href='menu.php?param=status'>Status</a></b></td><td>&nbsp;</td></tr>";
 
while ($row = mysql_fetch_array($result))

{

    $id = $row["id"];

    $date = $row["date"];

    $dateshow = fixDate($date);

    $total = $row["total"];

    $status = $row["status"];
 
if ($alternate == "1") { 

    $color = "#ffffff"; 

    $alternate = "2"; 

    } 

    else { 

    $color = "#efefef"; 

    $alternate = "1"; 

    } 
 
echo "<tr valign=top bgcolor=$color><td>$id</td><td>$dateshow</td><td>$total</td><td>$status</td><td>[ <a href='invoice.php?id=$id'>view</a> ]</td></tr>";

}

echo "</table>";
 
}

elseif ($client_name == 'admin')

{
 
echo "<h2>admin options</h2>";
 
include "inc/dbconnect.php";

include ("inc/date.php");

$result = mysql_query("SELECT * FROM invoices ORDER BY $param",$db);

if (!$param) {

$result = mysql_query("SELECT * FROM invoices ORDER BY id",$db);

}

echo "<p><table border=1 cellspacing=0 cellpadding=2 bordercolor=#eeeeee width=600>";

echo "<tr align=top><td><b><a href='menu.php?param=id'>Invoice number</a></b></td><td><b><a href='menu.php?param=clientid'>Client</a></b></td><td><b><a href='menu.php?param=date'>Date</a></b></td><td><b><a href='menu.php?param=total'>Total</a></b></td><td><b><a href='menu.php?param=status'>Status</a></b></td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>";
 
while ($row = mysql_fetch_array($result))

{

    $id = $row["id"];

    $clientid = $row["clientid"];

    $clientfind = mysql_query("SELECT title FROM clients WHERE clientid = '$clientid'",$db);

    $clienttitle = mysql_result($clientfind,0);

    $date = $row["date"];

    $dateshow = fixDate($date);

    $total = $row["total"];

    $status = $row["status"];
 
if ($alternate == "1") { 

    $color = "#ffffff"; 

    $alternate = "2"; 

    } 

    else { 

    $color = "#efefef"; 

    $alternate = "1"; 

    } 
 
echo "<tr valign=top bgcolor=$color><td>$id</td><td>$clienttitle</td><td>$dateshow</td><td>$total</td><td>$status</td>";

if ($status == 'pending') {

echo "<td>[ <a href='admin_invoice.php?id=$id'>view / change status</a> ]</td>";

}

else {

echo "<td>[ <a href='admin_invoice.php?id=$id'>view</a> ]</td>";

}

echo "<td>[ <a href='notifyclient.php?id=$id'>notify client</a> ]</td><td>[ <a href='edit_invoice.php?id=$id'>edit</a> ]</td><td>[ <a href='delete_invoice.php?id=$id' onClick=\"return confirm('Are you sure?')\">delete</a> ]</td></tr>";

}

echo "</table>";
 
echo "<p><a href='edit_invoice.php'>add an invoice</a> | <a href='clients.php'>manage client profiles</a>";
 
}

?>
 
<p><a href="logout.php">Logout</a></p>
 
<?

include "inc/footer.inc";

?>
 
</body>

 </html>

I can't seem to log into the "admin" area. I know that this issue has to do with the session because in the second script where we have:

Expand|Select|Wrap|Line Numbers

 <?

if ($client_name !== 'admin')

{

?>

<h2>Hello <b> 

  <? echo $client_name ?>

  </b> </h2>

  Here are your invoices:
 
<?

and after I log in under the admin account, I am not seeing the word "admin" echoed. Does something jump out at anyone? Thanks for looking. Frank

ak1dnar · #2 May 22nd, 2007, 04:23 AM

Please Refer to this link you may find out some solution.
http://au3.php.net/session_register

fjm · #3 May 22nd, 2007, 04:32 AM

Its Greek to me... Thanks anyway

EDIT: Actually.. I turned register_globals on and the script worked. What do I need to change in the script to allow the script to function while turning register_globals back off? Thanks again

ak1dnar · #4 May 22nd, 2007, 04:42 AM

If i need to use session in my application I'll make it like this.

[PHP]<?php
//First_page.php
session_start();
$TO_SESS_CLIENT = 'AJAXRAND';
$_SESSION['CLIENT_NAME'] = $TO_SESS_CLIENT;
?>
<a href="2.php">GO</a>[/PHP]

[PHP]<?php
//Second_page.php
session_start();
$FROM_SESS_CLIENT= $_SESSION['CLIENT_NAME'];
if($FROM_SESS_CLIENT == 'AJAXRAND'){
echo 'Hi, '.$FROM_SESS_CLIENT;
}
?>[/PHP]

fjm · #5 May 22nd, 2007, 04:45 AM

Ajax, thanks a million man.. I think I am seeing that session_register() is depreciated.. Instead, php.net advises to use a global $_session. I am also seeing that in your example as well. Am I correct on this?

I have changed the session_register to $_session["var"]; but I am getting "undefined variable" errors. Here is what that part of the code I made changes to looks like:

Expand|Select|Wrap|Line Numbers

 if (mysql_num_rows($result) == 1)

    {

    session_start();

    $_session["client_id"];

    $_session["client_name"];

    $_session["client_email"];

    $_session["client_ref"];

    $_session["client_title"];

    list($clientid, $name, $pass, $email, $ref, $title) = mysql_fetch_row($result);

    $client_id = $clientid;

    $client_name = $name;

    $client_email = $email;

    $client_ref = $ref;

    $client_title = $title;

    header("Location: menu.php");
 
    mysql_free_result ($result);    

    mysql_close($connection);

    }

Thanks again

start_session() help please

Popular Articles

What is Bytes?