php對mysql查詢結果進行分頁

jphp 9年前發布 | 1K 次閱讀 PHP

<?php
   function pageSplit($startPos, $rowsPerPage = '', $totalRows = '' )
        {

        $numPages = $totalRows / $rowsPerPage ;
        $tenthPages = $rowsPerPage * 10 ;
        If($startPos >= $tenthPages )
        {
            $back10Position = $startPos - $tenthPages ;
            $pageString .= '<a href="'.$PHP_SELF.'?startPos='.$back10Position .'&perPageDisplay='.$rowsPerPage.'" title="Previous 10 Pages"><font color="red"><< </font></a>  ';
        }

        if($startPos >= $rowsPerPage)
        {
            $backPosition = $startPos - $rowsPerPage;
            $pageString .= '<a href="'.$PHP_SELF.'?startPos='.$backPosition.'&perPageDisplay='.$rowsPerPage.'" title="Previous Page"><font color="blue">Back</a></font> ';
        }

        if($totalRows != '')
        {
                 $page = ceil($startPos / $rowsPerPage);
                 $pageCount = $page + $numPages;

                $PageNo = ceil($startPos / $rowsPerPage )  ;
                // echo ' Page No ' . $PageNo ;
                for($i = 1,$pgCnt=1; $page <= $pageCount; $i = $i + $rowsPerPage)
                {
                    if ( $PageNo == $pgCnt )
                    {
                        $pageString .= ' <a href="'.$PHP_SELF.'?startPos='.$i.'&perPageDisplay='.$rowsPerPage.'" title="Page '.$pgCnt.'""><font color="red"><b>'.$pgCnt.'</b></font></a> ';
                        $pgCnt++;
                    }
                    elseif ($i < $totalRows)
                    {
                        $pageString .= ' <a href="'.$PHP_SELF.'?startPos='.$i.'&perPageDisplay='.$rowsPerPage.'" title="Page '. $pgCnt.'"">'.$pgCnt.'</a> ';
                        $pgCnt++;
                    };

                    $page++;
                };
        }

        $nextPosition = $startPos + $rowsPerPage;

        if($totalRows == '')
        {
            $pageString .= '<a href="'.$PHP_SELF.'?startPos='.$nextPosition.'&perPageDisplay='.$rowsPerPage.'" title="Next Page"><font color="blue" >Next </font></a> ';
        }
        elseif($startPos < $totalRows )
        {
            If ( $nextPosition < $totalRows )
            {
                $pageString .= '<a href="'.$PHP_SELF.'?startPos='.$nextPosition.'&perPageDisplay='.$rowsPerPage.'" title="Next Page"><font color="blue" title="Next Page">Next </font></a>  ';
            }
        }

        if($startPos < $totalRows )
        {
            $next10Position = $startPos + $tenthPages ;

            If($next10Position < $totalRows )
            {
                $next10Position = $startPos + $tenthPages ;
                $pageString .= '<a href="'.$PHP_SELF.'?startPos='.$next10Position .'&perPageDisplay='.$rowsPerPage.'" title="Next 10 Pages"><font color="red"> >></font></a>';
            }
        }
            return $pageString;
    }

?></pre>

 本文由用戶 jphp 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
 轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!