[Resolved] want help in pagination (can,t pass variables )

Bhoomika

Hello friend

i have problem in pagination

my form and form hadler are two different pages. i m passin a 'title' variable through form to form handler . form is a search for books. the search returns perfact result in the first page as i m displaying 10 records per page. but as i click on the next page the title variable gets empty and all got mess up and no result or it show records page wise .

its a silli problem but its very big for me right now.

please help me .

in my php.ini register_globals configration is on.

thanx in advance.

Bhoomika

sameerni

namaste bhoomika,

1 try to print $title if you are getting that on first page. seems like you are getting that on the first page since first 10 results are being displayed.

2 if you are getting $title then try sending it with query string in the url on "Next" link.

Its difficult to tell what could be the problem without seeing code. Can you post both the pages here or on my address sameerni@netscape.net.

Bhoomika

thanks sameer for replying

here is my code

form.php

<Form action="pageauthor.php" method="post">
Title:<input type=text size="50" name="title" ><br><br>
<input type=submit value="Submit Search">
</form>

'$title' variable from form

titlesearch.php

<?Php
$connection=mysql_connect($hostname,$user,$pass) or die("Unable to connect");
$limit =10; // connecting to the databse

//$search=$HTTP_POST_VARS['title'];

//counting total result rows

$query ="select distinct bid from title, books where title.id=books.fktitleid";
$query .=" and (";
$titlet=trim($HTTP_POST_VARS['title']);
$keywords=split(" ",$titlet);
for($x=0;$x<sizeof($keywords); $x++)
{
trim($keywords[$x]);
if($x!=0)
{
$query .=" OR ";
}
$query .="(title.title like'%$keywords[$x]%' )";
}
$query.=")";

echo"$query";
$result_count=mysql_db_query($database,$query,$connection) or die("Error in query1:$query". mysql_error());
$totalrows=mysql_num_rows($result_count);
echo"totalrows :$totalrows";

//pagination code

if(empty($page))

$page = 1;

echo"<br>page :$page<br>";
$limitvalue = $page * $limit - ($limit);

//querying for limit $limitvalue, limit.

$query ="select distinct bid from title, books where title.id=books.fktitleid";
$query .=" and (";
$titlet=trim($search);
$keywords=split(" ",$titlet);
for($x=0;$x<sizeof($keywords); $x++)
{
trim($keywords[$x]);
if($x!=0)
{
$query .=" OR ";
}
$query .="(title.title like'%$keywords[$x]%' )";
}
$query.=")limit $limitvalue, $limit";

echo"$query";
$result=mysql_db_query($database,$query,$connection) or die("Error in query1:$query". mysql_error());
$count_result=mysql_num_rows($result);

// Display links at the top to indicate current page and number of pages displayed
$numofpages = ceil($totalrows / $limit);
echo"<br><p><b>$totalrows</b> result(s) for:";echo"$search </p>";
$from=$limit*$page-$limit+1;
$to=$from + $count_result-1;
// start 123 next>> table
?>

displaying result

<table align="center" width="90%" border="2" cellspacing="0" cellpadding="0">
<tr><td width="20%" bgcolor="#E7,E0,BE" align="left">
<?if($numofpages>1)
{echo"Showing:$from-$to"; ?>
</td><td width="70%" bgcolor="#E7,E0,BE"; align="right"><b>Go to page:</b> <?}?>

<?php
// display previous link if page is not 1
if($page != 1){

$pageprev = $page - 1;

echo("<a href='$PHP_SELF?page=$pageprev&search=$search'><< PREV</a> ");

}

// display page nos if not 1
for($i = 1; $i <= $numofpages; $i++){

if($numofpages>1){
if($i == $page)

echo(" ".$i." ");

else
echo(" <a href='$PHP_SELF?page=$i&search=$search'>$i</a> ");

}}

// display next page link if there is more than one
if(($totalrows - ($limit * $page)) > 0){

$pagenext = $page + 1;

echo("<a href='$PHP_SELF?page=$pagenext&search=$search'>NEXT >></a>");

}
// end 123 next>> table
?>
</td></tr>
</table>

<tr>
<th width="10%" align="center" style="background-color: #0000FF" >
<FONT FACE="verdana" color="#FFCD82" SIZE="-1">
Books</font>
</th>
<th width="80% height=18 align=right style="background-color: #0000FF" >
<FONT FACE="verdana" color="#FFFFF0" SIZE="-1">
Your Search returned <? echo"$totalrows";?> match(es)</font>
</th></tr>

<?php
while($row=mysql_fetch_array($result))
{
$qbid=$row['bid'];

$query ="select au_name from author, authorc where authorc.auid=author.id and authorc.bid='$qbid'";
$result2=mysql_db_query($database,$query,$connection) or die("Error in query2:$query". mysql_error());
?>

Bhoomika

suppose i make query on marketing and get 16 records
in the database

query is this
select distinct bid from title, books where title.id=books.fktitleid and ((title.title like'%marketing%' ))totalrows :16
page:1

my search page shows me the first page with all to correct records
and

as i click next or second page
query is this

select distinct bid from title, books where title.id=books.fktitleid and ((title.title like'%%' ))totalrows :27
page :2

i find difficulti in passing title variable value through all pages
as it becomes empty in second page.

Bhoomika

chinni_77

Bhoomika,

Please do not cross post.Did you read the rules and FAQ of this board before you made the post here??I would suggest you to delete the other thread.
Well, regarding your question this Thread.
might help you.

Bhoomika

oh !! sorry friend

but i donno how to delete the other theard

chinni_77

Click on the edit button at the bottom of your thread and then you can see a check box in-order to delete the thread.

sameerni

here, just a little change and it should work.

*************your code***************
displaying result

<table align="center" width="90%" border="2" cellspacing="0" cellpadding="0">
<tr><td width="20%" bgcolor="#E7,E0,BE" align="left">
<?if($numofpages>1)
{echo"Showing:$from-$to"; ?>
</td><td width="70%" bgcolor="#E7,E0,BE"; align="right"><b>Go to page:</b> <?}?>
<?php
// display previous link if page is not 1
if($page != 1){
$pageprev = $page - 1;
echo("<a href='$PHP_SELF?page=$pageprev&search=$search&title=$title'><< PREV</a> "); //MY CHANGE
}

*************end of your code***************

add that where ever you have NEXT of PREV

hope it works. :-)

sameer

sameerni

one thing i forgot to mention is that $title contains the value that you send using form. On you titlesearch.php page it is $titlet

so the statements become

********replace these statements********

// PREV link.
echo("<a href='$PHP_SELF?page=$pageprev&search=$search&title=$titlet'><< PREV</a> ");

// NEXT link
echo("<a href='$PHP_SELF?page=$pagenext&search=$search&title=$titlet'>NEXT >></a>");

since register_globals = On
you don't have to use $HTTP_POST_VARS[]

coz then here you need to change this statement

$titlet=trim($HTTP_POST_VARS['title']);

$titlet=trim($HTTP_GET_VARS['title']);

when you try to display results using PREV or NEXT

i would suggest you to simply use

$titlet=$title;

this should work.

Sameer

Bhoomika

thanx u very much sameer

its working its working

thanx again

🙂

Bhoomika

sameerni

hi bhoomika,

don't forget to close the thread if you not longer need it.
the option is at bottom of this page.
i think you only should be able to close this thread.

Regards.

Sameer.

Bhoomika

Once again

Thank You very much sameer

for kind help

Thanks again

Bye

good luck

cheers!!

Bhoomika