$pagesize = 2;
// 页码,默认 1
p a g e = i s s e t ( page = isset( page=isset(_GET[‘page’]) ? $_GET[‘page’] : 1;
// 开始行号
s t a r t R o w = m a x ( ( startRow = max(( startRow=max((page - 1), 0) * $pagesize;
// 执行查询语句
$sql = “select * from user”;
r e s u l t = m y s q l i q u e r y ( result = mysqli_query( result=mysqliquery(link, $sql);
// 总条数
c o u n t = m y s q l i n u m r o w s ( count = mysqli_num_rows( count=mysqlinumrows(result);
// 总页数
p a g e s = c e i l ( pages = ceil( pages=ceil(count / $pagesize);
// 构建查询分页 sql 语句,注意我这里用的 .=
也就是用上面的 sql 语句拼接下面的 sql 语句
KaTeX parse error: Expected '}', got 'EOF' at end of input: … id asc limit {startRow},{$pagesize}";
// 再次执行查询语句
r e s u l t = m y s q l i q u e r y ( result = mysqli_query( result=mysqliquery(link, $sql);
// 获取所有行数据
a r r s = m y s q l i f e t c h a l l ( arrs = mysqli_fetch_all( arrs=mysqlifetchall(result, MYSQLI_ASSOC);
// print_r($arrs);
?>