Hello,
I need some sessions help. I have a login page that looks up a user and starts a session. That works OK. That page sends to a page that displays users from MySQL. The first time the page views the session data displays OK. In this case it's $userid. After clicking any of the table display links (next, previous, etc) the session information is lost and I get an undefined variable error. Hopefully the problem is simple. Code is below.
Thanks
<?php
session_start();
include "./common_db.inc";
global $action;
echo $userid;
$user_tablename = "user2";
function list_records() {
global $default_dbname, $user_tablename;
global $default_sort_order, $default_order_by, $records_per_page;
global $sort_order, $order_by, $cur_page;
global $PHP_SELF;
global $who;
$link_id = db_connect($default_dbname);
if(!$link_id) error_message(sql_error());
$query = "SELECT count(*) FROM $user_tablename";
$result = mysql_query($query);
if(!$result) error_message(sql_error());
$query_data = mysql_fetch_row($result);
$total_num_user = $query_data[0];
if(!$total_num_user) error_message('No User Found!');
$page_num = $cur_page + 1;
$total_num_page = $last_page_num
= ceil($total_num_user/$records_per_page);
html_header();
?>
<table border=1 width=750>
<tr>
<td><H3><?php echo $total_num_user;?> users found. Displaying the page
<? echo $page_num;?> out of <? echo $last_page_num;?>.</H3>
</td></tr>
<?php
if(empty($order_by)) {
$order_by_str = "ORDER BY $default_order_by";
$order_by = $default_order_by;
}
else $order_by_str = "ORDER BY $order_by";
if(empty($sort_order)) {
$sort_order_str = $org_sort_order = $default_sort_order;
$sort_order = 'DESC';
}
else {
$sort_order_str = $org_sort_order = $sort_order;
if($sort_order == 'DESC') $sort_order = 'ASC';
else $sort_order = 'DESC';
}
if(empty($cur_page)) {
$cur_page = 0;
}
$limit_str = "LIMIT ". $cur_page * $records_per_page .
", $records_per_page";
$query = "SELECT usernumber, userid, username FROM $user_tablename
$order_by_str $sort_order_str $limit_str";
$result = mysql_query($query);
if(!$result) error_message(sql_error());
?>
<DIV align="center">
<TABLE BORDER="1" width="550" CELLPADDING="2">
<TR>
<TH NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=usernumber"; ?>">
User Number
</A>
</TH>
<TH NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=userid"; ?>">
User ID
</A>
</TH>
<TH NOWRAP>
<A HREF="<?php echo "$PHP_SELF?action=list_records&sort_order=$sort_order&order_by=username"; ?>">
User Name
</A>
</TH>
<TH NOWRAP>Action</TH>
</TR>
<?php
while($query_data = mysql_fetch_array($result)) {
$usernumber = $query_data["usernumber"];
$userid = $query_data["userid"];
$username = $query_data["username"];
echo "<TR>\n";
echo "<TD class=c1 ALIGN=\"CENTER\">$usernumber</TD>\n";
echo "<TD class=c2 ALIGN=\"CENTER\">$userid</TD>\n";
echo "<TD ALIGN=\"CENTER\">$username</TD>\n";
echo "<TD ALIGN=\"CENTER\">
<A HREF=\"javascript:open_window('$PHP_SELF?action=view_record&
userid=$userid');\">View Record</A></TD>\n";
echo "</TR>\n";
}
?>
</TABLE>
</DIV>
<?php
echo "<BR>\n";
echo "<STRONG><CENTER>";
if($page_num > 1) {
$prev_page = $cur_page - 1;
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=0\">[Top]</A>";
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$prev_page\">[Prev]</A> ";
}
if($page_num < $total_num_page) {
$next_page = $cur_page + 1;
$last_page = $total_num_page - 1;
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$next_page\">[Next]</A> ";
echo "<A HREF=\"$PHP_SELF?action=list_records&sort_order=$org_sort_order&order_by=$order_by&cur_page=$last_page\">[Bottom]</A>";
}
echo "</STRONG>";
echo "</td></tr>";
echo "</table>";
html_footer();
}
