|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2010-09-07 05:44 UTC] aharvey@php.net
-Status: Open
+Status: Bogus
[2010-09-07 05:44 UTC] aharvey@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Dec 11 21:00:02 2025 UTC |
Description: ------------ I was working on a way to calculate the LIMIT and OFFSET for a blog in reverse but still with ORDER BY date_create DESC and I kept running into flaws until i did a print on the mysql_query string,.. in order to keep the urls correct on the page,.. $postoffset = (((14 / 10) - 1) * 10); // 4 var_dump($postoffset); // returns float(4) var_dump(intval($postoffset)); // returns int(3) 14/10 = 1.4 1.4-1 = 0.4 0.4*10 = 4 (this is happening on many different php version, so i almost wanted to put the php version select on "Irrelavant") Test script: --------------- <?php header("Content-Type: text/plain"); $limit = (int) 10; $count = (int) 14; // mysql_query("select count(*)..."); $pages = (int) ceil($count/$limit); $page = (int) 1; $offset = ((($count / $limit) - $page) * $limit); var_dump($offset); var_dump(intval($offset)); $offset = (((14 / 10) - 1) * 10); // 4 var_dump($offset); var_dump(intval($offset)); var_dump(ceil(((14 / 10) - 1) * 10)); var_dump(floor(((14 / 10) - 1) * 10)); var_dump(round(((14 / 10) - 1) * 10)); print "- step by step -\n"; $pages = $count / $limit; var_dump($pages); // 1.4 var_dump(intval($pages)); // 1 $_page = $pages - $page; var_dump($_page); // 0.4 var_dump(intval($_page)); // 0 $offset = $_page * $limit; var_dump($offset); // 4 var_dump(intval($offset)); // 3 incorrect $offset = 0.4 * 10; var_dump($offset); // 4 var_dump(intval($offset)); // 4 correct ?> Expected result: ---------------- float(4) int(4) float(4) int(4) float(4) float(4) float(4) - step by step - float(1.4) int(1) float(0.4) int(0) float(4) int(4) float(4) int(4) Actual result: -------------- float(4) int(3) float(4) int(3) float(4) float(3) float(4) - step by step - float(1.4) int(1) float(0.4) int(0) float(4) int(3) float(4) int(4)