decimal point

[Manat]

If I have a value and I want the value after decimal point how would I do that?

3.2
how do i put 2 in a value?

This is what I want to do with it.

I have 8 pages, with 5 rows of data per page, suppose the 8th page has only 3 rows of data.

I want to be able to say, 1-10, 10-20 and eventually 80-83

If I have a $number of rows / $limit
I get how many pages, but if the result is 3.2, i'd know like that.

How to get it?

Thanks
mk

[dcav]

To find number of pages:

$numberOfPages = ceil($nrows / $resultsPerPage);

[Manat]

Hi,

I already know how many pages there are.
But I need to know how many rows or results in the current page.

Thanks
MK

[dcav]

oh sorry I misunderstood what you were asking...
Here is what I do:

$displayStart = $startPos + 1;
$displayEnd = ($thisPage != $numberOfPages) ? ($startPos + $resultsPP) : ($startPos + $resultsPP - (($startPos + $resultsPP) - $nrows));

Math logic...

[Manat]

Hi,

What is startPos and $resultsPP

$startPos is just Page 1?

Thanks alot
MK

[dcav]

in my code, $startPos equals to where to query first. This is a different value depending on which page i am at.
And $resultsPP in my code is REsults per page.

In your case, $resultsPP is your LIMIT

[Manat]

Hi,

i tried the code but $displayStart is always equal to 1 and $displayEnd is always equal to $limit.

This is the code I used:

$startPos =0;
$displayStart = $startPos + 1; 
$displayEnd = ($page != $numofpages) ? ($startPos + $limit) : ($startPos + $limit - (($startPos + $limit) - $totalrows)); 
echo "Info HERE ";
echo $displayStart;
echo $displayEnd;

[dcav]

$displayEnd = ($thisPage != $numberOfPages) ? ($startPos + $resultsPP) : ($startPos + $resultsPP - (($startPos + $resultsPP) - $nrows));

So what I am saying is:
example: current page = 3 , records 26 to 50 of 56
pseudo code:
if the current page is not the last page
then 25 + 25 is my displayEnd

example2: current page = 4, records 51 to 56 of 56
pseudo code:
if the current page is not the last page
then
// not here since it is the last page
else
50 + 25 - (50 + 25 - 56)
// Thinking about it, based on this algebra, you could just use $nrows for your last page :p

Good luck 🙂

[dcav]

i tried the code but $displayStart is always equal to 1 and $displayEnd is always equal to $limit.

Yes, I noticed that, I used the exact same code for my numbered pagination system and it works. The start position is always different depending on which page i am at.

I used $_GET on my URL to keep track which page i am at and use SESSION to keep my query.

[dcav]

ok, this is my whole code for pagination, maybe you can take a look at that. GOod luck

$connSearch = new SD_Connect($dbHost, $dbUser, $dbPass, $dbName, $query);
$connSearch->execQuery();
$nrows = $connSearch->numRows();
$numberOfPages = ceil($nrows / $resultsPP);
// $resultsPP = 25, i declared it beforehand
$thisPage = (!isset($_GET[page])) ? 1 : $_GET[page];
$startPos = ($thisPage - 1) * $resultsPP;
// As you can see $startPos is always different.
$displayStart = $startPos + 1;
//$displayEnd = ($thisPage != $numberOfPages) ? ($startPos + $resultsPP) : ($startPos + $resultsPP - (($startPos + $resultsPP) - $nrows));
// That was stupid, i changed it to this now.
$displayEnd = ($thisPage != $numberOfPages) ? ($startPos + $resultsPP) : $nrows;

print "Displaying records: $displayStart to $displayEnd of $nrows // Currently on page: $thisPage of $numberOfPages<br />";

function funcPagination($thisPage, $numberOfPages) {
echo "Page: ";
$prevPage = $thisPage - 1;
$nextPage = $thisPage + 1;

echo ($prevPage < 1) ? "previous " : "<a href=\"SearchResults.php?item=29000&page=$prevPage&lang=$pageLang\">previous </a>";
for ($i = 1; $i <= $numberOfPages; $i++)
{
	echo "<a href=\"SearchResults.php?item=29000&page=$i&lang=$pageLang\">$i</a> ";
}
echo ($nextPage > $numberOfPages) ? " next" : "<a href=\"SearchResults.php?item=29000&page=$nextPage&lang=$pageLang\"> next</a>";
}

funcPagination($thisPage, $numberOfPages);

[dcav]

If you want to see how it looks liks:

http://www.sugoidesign.com/cldwi/SearchPage.php?item=29000&lang=en

Just press "Submit" right away, you will see 195 records with a pagination system. The code above is my logic for doing this. Might not be the most optimal way, but it works flawlessly.

[Manat]

Thanks alot...

I took certain parts of your code and it works.
This is what I did

$lastPage = ceil($totalrows / $limit);
$num = ($page - 1) $limit;
$lastRecords = $totalrows - $num;
if($page == $lastPage)
{ echo $lastRecords;}
else
{
$rpage = $page;
$displayEnd = $rpage $limit;
$limit2 = $limit - 1;
$displayStart = $displayEnd - $limit2;
echo $displayStart; echo" of "; echo $displayEnd;
}

Works Great
Thanks alot for ur help!!!!