php pagination

[chinto09]

Hi
i m working on a song website where there is a search box on the top. User type their keyword in the search box and then results show if match found in the database for their requested songs. i want to show 20 records per page if the searched songs are more than 20.

Now 1st Page shows exactly the matched results stored in variable $title=$_Post['keyword']
My question how i can transfer the variable $title to each page so that pagination works for the remainng pages as well

Here is the code

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="text" name="keyword">
<input type="submit" name="submit" value="submit">
</form>

$title=$_POST['keyword'];

if ($_POST['keyword'] =="")
{
echo "you did not enter any value in the search box";
exit();
}

//connecting to database
$link=mysql_connect('localhost','root')or die ('Error Connecting to database ' .mysql_error());

//selecting database
mysql_select_db('songs_directory') or die ('Could not find any database ' . mysql_error());



//Numer of results to show per page
$rows_per_page = 20;
$page_num=1;

if (isset($POST['page']))
{
$page_num = $POST['page'];
}

$offset = ($page_num - 1 ) $rows_per_page;
$query="SELECT from songs
where title like '%$title%'
LIMIT $offset, $rows_per_page";

$result= mysql_query($query, $link) or die ('Could not execute query ' . mysql_error());

while ($row = mysql_fetch_array($result))
{
echo $row['title'];
echo "<br>";
}

$query="SELECT * from songs
where title like '%$title%'
";
$result = mysql_query($query, $link) or die ('Could not execute query 2');
$num_rows=mysql_num_rows($result);
$max_page = ceil($num_rows/$rows_per_page);


//creating links

$self=$_SERVER['PHP_SELF'];
$nav = '';

for ($page=1; $page <= $max_page; $page++)
{
if ($page == $page_num && $num_rows <= $rows_per_page)
{
}
elseif($page == $page_num)
{
$nav .= " $page ";
}
else
{
$nav .= " <a href=\"$self?page=$page\">$page</a> " ;
}

}

if ($page_num > 1)
{
$page = $page_num - 1;
$prev = " <a href=\"$self?page=$page\">[PREVIOUS]</a> ";
$first = " <a href=\"$self?page=$page\">[FIRST]</a> ";
}
else {
$prev = '&nbsp;';
$first ='&nbsp;';
}
if ($page_num < $max_page)
{
$page = $page_num + 1;
$next = " <a href=\"$self?page=$page\">[NEXT]</a> ";
$last = " <a href=\"$self?page=$max_page\">[LAST PAGE]</a> ";
}

else
{
$next = '&nbsp;';
$last = '&nbsp;';
}
echo $first. $prev . $nav. $next. $last;
[/COLOR]

[scross]

If I understand you correctly, you're asking how to hold the search information (what is being searched for) over multiple pages. The answer to this is fairly simple, you just place the search in the url, and obtain it using $GET. If you don't understand what I'm talking about I have written an article here that explains $GET and $_POST.

The first step of the change is as simple as adding "keyword=$title" (minus the quotes). So, for instance, the urls would change from:

$prev = " <a href=\"$self?page=$page\">[PREVIOUS]</a> ";
$first = " <a href=\"$self?page=$page\">[FIRST]</a> ";

to:

$prev = " <a href=\"$self?page=$page&amp;keyword=$title\">[PREVIOUS]</a> ";
$first = " <a href=\"$self?page=$page&amp;keyword=$title\">[FIRST]</a> ";

You might notice I used "&amp;" to seperate page=$page and keyword=$title. In the browser this simple resolves to an ampersand (&), which is what should be placed between GET variables in a url.

Now, the second step involves a choice. You can either check for the presence of $GET['keyword'] in addition to checking for $POST['keyword'], or you can change your form to use GET and then only have to check for $_GET['keyword']. Unless you have a specific reason, I'd recommend the latter. To do this, you change the form code from:

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="text" name="keyword">
<input type="submit" name="submit" value="submit">
</form>

to:

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="get">
<input type="text" name="keyword">
<input type="submit" name="submit" value="submit">
</form>

All you have to do then is replace all of the instances of $POST['keyword'] in the code with $GET['keyword'].

I hope this answers your question. If you have any questions please do ask...I remember the challenges I faced when learning PHP so I'm happy to help 🙂

[chinto09]

Thanx scross for your help.

I had no idea that it is so simple to do.

Thanx once again 🙂