PHP function to achieve paging effect, php text paging and number paging

//Paging
/**
* $pageType paging type 1 is numeric paging 2 is text paging
* You can pass $pageTotal, $page, $total and other data as parameters, or use it as a global variable in paging (recommended)
*/
function paging($pageType)
{
global $pageTotal,$page,$total;
if($pageType == 1)
{
echo '';
echo'';
for($i=0; $i < $pageTotal; $i++){ if($page == ( $i+1)){echo ''.($i +1).'';
}
else
{
echo ''.($i+1).'';
}
}
echo'';
echo'

//Paging parameter packaging/*** $sql can obtain a sql statement of the total number of data * $size displays the number of items on each page

*/

function pageParam($sql,$size)

{

//Set all involved parameters to global variables

$pagesize = $size;
// Get the total number of data
$total = mysql_num_rows(queryDB($sql));

// Error handling, first determine whether it exists
if(isset($_GET['page']))
{
// A specific page
$page = $_GET['page'];
// Determine whether it is empty (0 is empty)/less than 0/whether it is a number
if(empty($page) || $page < 0 || !is_numeric ($page))
{
$page = 1;
}
else
{
$page = intval($page); //Rounding to prevent decimals from appearing
}

}
else
{
//Initialization Display page 1
$page = 1;
}

// Clear database
if($total == 0)
{
// Set to 1
$pageTotal = 1;
}
else
{
/ / The total number of pages in paging (further rounded up)
$pageTotal = ceil($total / $pagesize);
}

// The number of pages is greater than the total page number $total
if($page > $pageTotal)
 {
$page = $pageTotal;
}
// When the page starts from a certain record
$pagestart = ($page - 1) * $pagesize;
}



Copy code


Parameter explanation:
$pagestart is when the page starts from a certain record, $pagesize is the number of records displayed on each page

3. During use, call pageParam first, then call paging

*/

pageParam("select userid from user",2);

//Paging type 1 is numeric paging 2 is text paging

Copy code


4. The calling location is selected according to the specific situation, and the text is paginated:





//Paging type 1 is digital paging 2 is text paging