Really need helps regarding Pagination with Sort

Posted on 16th Feb 2014 07:03 pm by admin

I need someone helps regarding pagination problem...i actually want to make my page limited to let say 50

so it will look like this

page1=0-50
page2=51-100

Then i want to sort let say based on the name of a person by giving <a href> and ORDER i can do the sort, but the problem occurs when i want to sort records on page 2, everything got messed up

Can anyone help me..below is the code:

<?php

$var2 =$_GET['title'] ;
$var3 =$_GET['field'] ;
$var4 =$_GET['country'] ;

$orderby = $_GET['orderby'];
if(empty($_GET['orderby'])){
$orderby="firstname";}

$sort=$_GET['sort'];
if(empty($_GET['sort'])){
$sort="DESC";}

if($sort=="DESC"){
$sort="ASC";}else
if($sort=="ASC"){
$sort="DESC";}

$trimmed2 = trim($var2); //trim whitespace from the stored variable
$trimmed3 = trim($var3);
$trimmed4 = trim($var4);

$table = "members";

$field_to_search2 = "title";
$field_to_search3 = "field";
$field_to_search4 = "country";

$query = "SELECT COUNT(*)FROM $table WHERE $field_to_search2 LIKE '%$trimmed2%'AND $field_to_search3 LIKE '%$trimmed3%' AND $field_to_search LIKE '%$trimmed%' AND $field_to_search4 LIKE '%$trimmed4%' ORDER BY $orderby $sort";

$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrow = $r[0];

$rowsperpage = 100;
$totalpages = ceil($numrow / $rowsperpage);

if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

$currentpage = (int) $_GET['currentpage'];

} else {
$currentpage = 1;
}
if ($currentpage > $totalpages) {

$currentpage = $totalpages;
}
if ($currentpage < 1) {

$currentpage = 1;
}
$offset = ($currentpage - 1) * $rowsperpage;

$query5 = "SELECT * FROM $table WHERE $field_to_search2 LIKE '%$trimmed2%'AND $field_to_search3 LIKE '%$trimmed3%' AND $field_to_search LIKE '%$trimmed%' AND $field_to_search4 LIKE '%$trimmed4%' AND $field_to_search5 LIKE '%$trimmed5%' ORDER BY $orderby $sort";

$result5 = mysql_query($query5);
$count5 = mysql_num_rows($result5);

$query = "SELECT * FROM $table WHERE $field_to_search2 LIKE '%$trimmed2%'AND $field_to_search3 LIKE '%$trimmed3%' AND $field_to_search4 LIKE '%$trimmed4%'ORDER BY $orderby $sort LIMIT $offset, $rowsperpage";

$result = mysql_query($query) or trigger_error("SQL", E_USER_ERROR);

$count = mysql_num_rows($result);

$info = mysql_fetch_array($result);

$numresults=mysql_query($query);

$numrows=mysql_num_rows($numresults);
$mypage=$_SERVER['PHP_SELF'];

if ($numrows == 0 )

{

echo "<center>Search "." returned zero results</center>";

}

if (empty($s))

{

$s=0;

}

// get results

$result = mysql_query($query) or die("Couldn't execute query");

if($numrows > 1 ){$return = "results";}

else{ $return = "result"; }

echo "<center><table><tr><td><a href=page.php?title=$var2&field=$varx3&q=$var&country=$var4&campus=$var5&orderby=firstname&sort=$sort&search2=Find class=sort>Name</a></td><td width = 70 bgcolor=brown><a href=page.php?title=$var2&field=$var3&country=$var4&orderby=gender&sort=$sort&search2=Find class=sort>gender</a></td></tr></table></center>";

$count = $s + 1 ;

while ($r= mysql_fetch_array($result))

{

$gender = $r["gender"];
$firstname1 = $r["firstname"];

$field = $r["field"];
$country = $r["country"];

$count++ ;

echo "<center><table><tr><td>$firstname</td><td>$gender</td><td>$country</td></tr></table>";

}
$range = 5;

echo"<center>";
if ($currentpage > 1) {

$var2 =$_GET['title'] ;
$var3 =$_GET['field'] ;
$var4 =$_GET['country'] ;

echo " <a href='{$_SERVER['PHP_SELF']}?title=$var2&field=$var3&country=$var4&search2=Find&currentpage=1'>First</a> |";
$prevpage = $currentpage - 1;
echo " <a href='{$_SERVER['PHP_SELF']}?title=$var2&field=$var3&country=$var4&search2=Find&currentpage=$prevpage'>Previous</a> | ";
}

for ($x = ($currentpage - $range); $x < ($currentpage + $range); $x++) {

if (($x > 0) && ($x <= $totalpages)) {

if ($x == $currentpage) {

echo " [$x] ";

} else {

echo " <a href='{$_SERVER['PHP_SELF']}?title=$var2&field=$var3&country=$var4&search2=Find+resume&currentpage=$x'>$x</a> ";
}
}
}

if ($currentpage < $totalpages) {

$nextpage = $currentpage + 1;

echo "| <a href='{$_SERVER['PHP_SELF']}?title=$var2&field=$var3&country=$var4&search2=Find&currentpage=$nextpage'>Next</a> | ";

echo "<a href='{$_SERVER['PHP_SELF']}?title=$var2&field=$var3&country=$var4search2=Find&currentpage=$totalpages'>Last</a>";
}
echo"</center>";

?>

Thanks

No comments posted yet

Your Answer:

323

Other forums

xApp Analytics in BI 7.0
Dear all,

I am trying to implement xApp Analytics in BI 7.0. After I installed the analyt

email form (cannot find the problem)
Hello there. I've been having trouble with an email form. Can't find the problem really. I've tested

How to replace search button with link?
hi to everbody.
i have a search submit form and button like this :

<form id="f

Downloading file (Headers)
I'm trying to make users download a file, but they must wait 60 seconds before it begins.

But

SQl num_rows problem
when i try to count rows from an SQL select i get an warning

Code: [Select]$countviews = mysq

Save User Inputs while javascript reloading!
hi..
i have written a PHP code in which i reload the page when user selects a value in dropdown..

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

PHP Directory Listing Not working
Hey Guys,

I need help, I tried a ton of directory listing scripts and they all don't work. Al

noob question
i traying to do a php form with auto replay for both(me and the user who send me a mail),

a u

Indyaspeak

Really need helps regarding Pagination with Sort

Your Answer:

Other forums

Follow Us