sessions in pagination when search the db

coder_learner

I have a search box named $query and few option lists named $selection, $sortField, and $sortType in a form.
when I type something in $query and made my selections, I press submit button.
Then I have a mysql query to find 'like' $query and it will display records in a pagination style.
My problem is that it displays records on page 1 but when clicked next button or page 2, all my variables are blank.
I see that the variables don't pass to next page. So I included session_start and session_register but still my variables won't pass. Any help will be appriciated.

ON THE VERY TOP OF MY PAGE:

<? session_start(); // to keep variables saved
// header("Cache-control: private"); is used to hit BACK button without refresh in MS 6
header("Cache-control: private"); ?>

AFTER SUBMIT BUTTON:

// Get the user's input from the form
$query = $_POST['query'];

// Register session key with the value
$_SESSION['query'] = $query;

IN THE MYSQL CONNECTION SECTION I HAVE:

$selection = $selection;
$sortField = $sortField;
$sortType = $sortType;

$sql = "select * from products WHERE $selection like \"%$query%\" order by $sortField $sortType LIMIT $limitvalue, $user_view_limit";
$result = mysql_query($sql) or die;// ("Error in query: $query. " . mysql_error());

/ the query to get the total number without the limit /
$sqlcount = "select count(*) from products where $selection like \"%$query%\"";

AND IN PAGINATION SECTION I HAVE:

<?
/ if theres more than one page needed, print out the page #s
In this example, products.php is the page that the link will be printed out with.
To use a different page, simply change this value in your function call /
if ($user_view_limit < $totalrows) {
make_user_page_nums($totalrows, $print_query, "$PHP_SELF");
}

/ THE ACTUAL make_user_page_nums FUNCTION /
/ ----------------------------------------/

function make_user_page_nums($totalrows, $print_query, $page_name) {

//if (isset($HTTP_GET_VARS['id'])) $id = $HTTP_GET_VARS['id'];
//if (isset($HTTP_POST_VARS['id'])) $id = $HTTP_POST_VARS['id'];
//if (isset($HTTP_POST_VARS['title'])) $title = $HTTP_POST_VARS['title'];
//if (isset($HTTP_POST_VARS['title'])) $title = $HTTP_POST_VARS['title'];

// global $print_query;
global $user_view_limit;
global $page;
global $limitvalue;

echo "";
echo "Pages: ";
echo "";

/ PREV LINK: print a Prev link, if the page number is not 1 /
if($page != 1) {
$pageprev = $page - 1;
echo "";
echo "<a href=\"".$page_name.$print_query."page=".$pageprev."\"><Prev</a> ";
echo "";
}

/ get the total number of pages that are needed /
$numofpages = $totalrows/$user_view_limit;

/ loop through the page numbers and print them out /
for($i= 0; $i < $numofpages; $i++) {
/ if the page number in the loop is not the same as the page we're on, make it a link /
$real_page = $i + 1;
if ($real_page!=$page){
echo "";
echo " <a href=\"".$page_name.$print_query."page=".$real_page."\">".$real_page."</a> ";
echo "";

/ otherwise, if the loop page number is the same as the page we're on, do not make it
a link, but rather just print it out /
} else {
echo "";
echo "".$real_page."";
echo "";
}
}

/ NEXT LINK -
If the totalrows - $user_view_limit $page is > 0 (meaning there is a remainder), print the Next button. /
if(($totalrows-($user_view_limit$page)) > 0){
$pagenext = $page + 1;
echo "";
echo " <a href=\"".$page_name.$print_query."page=".$pagenext."\">Next ></a> ";
echo "";
}

}

/ END OF PAGE NUMBERING SNIPPET CODE /
/ ----------------------------------------/
?>

please give me any hints or tips or watever on how to get my sesseions to page 2
Thanks!
I build this code through http://www.phpfreaks.com/tutorials/43/1.php

tekky

you may need to actually use the function

session_register(), not just assign $_SESSION['vars']
before the variables become available sitewide

coder_learner

I thought $_SESSION entries are automatically registered and I didn't have to use session_register()

tekky

Originally posted by coder_learner
I thought $_SESSION entries are automatically registered and I didn't have to use session_register()

you are write, (just got back from lunch sorta so I read up on it)

if using $_SESSION[] you MUST call session_start(); and session vars will be registered DESPITE register_globals being off, BUT using session_register() will NOT work with register globals off....

so you are doing it the right way 🙂

coder_learner

thanks dude....
ok here's what I found now! when I include the following code, I realized that the sessions are passing to 2nd page but the mysql query won't work nor page numbers print on screen

<?
if(isset($SESSION['query']))
{
print("query SESSION is set");
print($SESSION['query']);
}
else
{
print("query SESSION is not set");
}

?>
let me keep on trying...😕

tekky

hmm why do you have or die; //("die message her");

I would suggest making that back into or die("message here");

so you still see the error message if it dies there...
also, when you say query isnt working... how far in do you figure your code is processing on the reload for page 2?

coder_learner

<BODY>
<form action="<? echo $PHP_SELF; ?>" method="POST">

<input type="text" name="query" maxlength="255" size="45">
..
....
.....

IT DISPLAYS UP TO HERE

// includes
include("../conf.php");

// open database connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

/ BEGIN CODE SECTION /
/ ----------------------------------------/

/ per page limit - this can be included in a seperate file, as long as you
are sure to include that fle on the page you want the numbering on - otherwise
its fine to just code it here - for this example, we're using 16 items per page /
$user_view_limit = "10";

/ if there is no page # passed, assign $page the value of 1 /
if ((empty($page)) || ($page <= 0)){
$page = 1;
}

/ this code just figures out the limit for the sql statement that actually
gets that page's item data /
$limitvalue = $page*$user_view_limit-($user_view_limit);

/ the query to get actual results - your query would go here, but be sure to
include the LIMIT $limitvalue, $user_view_limit part at the end.
Our example is pulling articles from the "articles" table that have the category ID of 2 /
$qur = $SESSION['query'];
$sel = $SESSION['selection'];
$sorF = $SESSION['sortField'];
$sorT = $SESSION['sortType'];

$sql = "select * from products WHERE $sel like $qur order by $sorF $sorT LIMIT $limitvalue, $user_view_limit";
$result = mysql_query($sql) or die; ("Error in query: $query. " . mysql_error());

/ the query to get the total number without the limit /
$sqlcount = "select count(*) from products where $sel like $qur";

$print_query ="?";

$sql_countresult = mysql_query($sqlcount);
list($totalrows) = mysql_fetch_row($sql_countresult);

// if records present
if (mysql_num_rows($result) > 0)
{
// iterate through resultset
// print title with links to edit and delete scripts
while($row = mysql_fetch_object($result))
{
?>

<? echo $row->Id; ?>
<? echo $row->title; ?>

I've been trying this for days but can't figure it out. Although, I'm progressing bit by bit every day! :o