Reference - Data handling - page

<?php

  $products = range ( 1, 47 );

?>

{products page=$pg ?? 1, rows=5}
  {$products}
{/products}

{pager 'products', window=1}

<?php

  $products = range ( 1, 47 );

?>

{products page=$p ?? 1, rows=10}{/products}

{pager 'products'}
  {if $href eq ''}
    <span>{$label}</span>
  {elseif $kind eq 'current'}
    <strong>{$label}</strong>
  {else}
    <a href="{$href}">{$label}</a>
  {/if}
{/pager}

<?php

  $items = [ [ 'n' => 1 ], [ 'n' => 2 ], [ 'n' => 3 ] ];
  $pg    = 'abc';

?>

{items page=0, rows=2}{$n} {/items}|{items page=-1, rows=2}{$n} {/items}|{items page=$pg, rows=2}{$n} {/items}|{items page=2, rows=2}{$n} {/items}

<?php

  $now = 'app now';
  $hit = 'app hit';

?>

{data 'pg'}[{"n":"a"},{"n":"b"},{"n":"c"}]{/data}{pg page=2, rows=2}{$n}{/pg}|{$now}|{$hit}

{data 'n'}
  [1,2,3,4,5]
{/data}
[{n page=2, rows=2, negative}
  {$n},
{/n}][{n rows=2, page=2, negative}
  {$n},
{/n}][{n start=2, end=3, negative}
  {$n},
{/n}][{n start=2, rows=2, negative}
  {$n},
{/n}][{n end=-1, rows=2, negative}
  {$n},
{/n}][{n rows=2, negative}
  {$n},
{/n}]

{data 'xs'}
  [1,2,3,4,5,6]
{/data}
[{xs page=2, rows=2, negative}{$xs}{/xs}]
[{xs start=2, end=4, negative}{$xs}{/xs}]
[{xs end=3, rows=2, negative}{$xs}{/xs}]

{data 'n'}
  [1,2,3,4,5,6]
{/data}
{n rows=2, page=3}
  {$n},
{/n}

<?php

  // The two paged tags are one entry of the option form: the second is a hit, which runs
  // no handling of its own rows. vary= keeps a run off an earlier run's copy.

  $items = [ [ 'n' => 1 ], [ 'n' => 2 ], [ 'n' => 3 ], [ 'n' => 4 ], [ 'n' => 5 ] ];
  $token = uniqid ( '', TRUE );

?>

{items page=2, rows=2, cache=60, vary=$token}{$n} {/items}|{items page=2, rows=2, cache=60, vary=$token}{$n} {/items}|{pager 'items'}{$kind}:{$page} {/pager}

<?php

  $products = range ( 1, 100 );
  $pg       = 6;

  $_GET ["q"] = "red shoe";

?>

{products page=$pg, rows=10}{/products}{pager 'products', window=1}[{$kind} {$page} {$label}]{/pager}

<?php

  $products = range ( 1, 100 );
  $pg       = 6;

  $_GET ["q"] = "red shoe";

?>

{products where='$products gt 70', page=2, rows=10}{/products}{pager}[{$kind} {$page}]{/pager}|{products page=2, rows=10, where='$products gt 95'}{$products} {/products}{pager window=0}[{$page}]{/pager}|{pager query='p'}{last@pager}{$href}{/last@pager}{/pager}

<?php

  $products = range ( 1, 100 );
  $pg       = 6;

  $_GET ["q"] = "red shoe";

?>

{products page=$pg, rows=5}{/products}{pager 'products', window=2}

<?php

  $products = range ( 1, 100 );
  $pg       = 6;

  $_GET ["q"] = "red shoe";

?>

[{products where='$products le 4', page=1, rows=5}{/products}{pager 'products'}]{pager 'products'}{$label}@else@one page{/pager}

<?php

  // A pager after a select that joins two tables sharing a column name - orders and
  // customers, both with customerNumber - counts its rows: the count ran the select list
  // as a derived table, which MySQL refuses with two columns of one name ("1060: Duplicate
  // column name 'customerNumber'"), and the page ended at the pager.

  $padSelect ['ordersPaged'] = [ 'db' => 'orders', 'key' => 'orderNumber' ];

?>

[{ordersPaged join='customers on customers.customerNumber = orders.customerNumber', where="customers.country = 'Norway'", order='orderNumber', page=1, rows=3}{$orderNumber} {$customerName}; {/ordersPaged}]
{pager 'ordersPaged', window=0}{$kind}:{$page} {/pager}

<?php

  // A pager counts the rows the select answers also when its fields= decides what a row is:
  // distinct countries, or one row of totals. The count over the table alone was taken
  // whenever distinct=, group=, having= and union= were not given, so 27 countries had the
  // 13 pages of the 122 customers, and the one row of totals a pager of 28 pages.

  $padSelect ['countriesPaged'] = [ 'db' => 'customers', 'key' => 'customerNumber' ];
  $padSelect ['paymentTotals']  = [ 'db' => 'payments',  'key' => 'checkNumber' ];

?>

[{countriesPaged fields='distinct country', order='country', page=1, rows=10}{$country}; {/countriesPaged}]
({pager 'countriesPaged', window=0}{$kind}:{$page} {/pager})
[{paymentTotals fields='count(*) as n', page=1, rows=10}{$n}{/paymentTotals}]
({pager 'paymentTotals', window=0}{$kind}:{$page} {/pager})