### 准备
专辑列表数据 SQL 文件
> data/album-fixtures.sql
~~~
INSERT INTO "album" ("artist", "title")
VALUES
("David Bowie", "The Next Day (Deluxe Version)"),
("Bastille", "Bad Blood"),
("Bruno Mars", "Unorthodox Jukebox"),
("Emeli Sandé", "Our Version of Events (Special Edition)"),
("Bon Jovi", "What About Now (Deluxe Version)"),
("Justin Timberlake", "The 20/20 Experience (Deluxe Version)"),
("Bastille", "Bad Blood (The Extended Cut)"),
("P!nk", "The Truth About Love"),
("Sound City - Real to Reel", "Sound City - Real to Reel"),
("Jake Bugg", "Jake Bugg"),
("Various Artists", "The Trevor Nelson Collection"),
("David Bowie", "The Next Day"),
("Mumford & Sons", "Babel"),
("The Lumineers", "The Lumineers"),
("Various Artists", "Get Ur Freak On - R&B Anthems"),
("The 1975", "Music For Cars EP"),
("Various Artists", "Saturday Night Club Classics - Ministry of Sound"),
("Hurts", "Exile (Deluxe)"),
("Various Artists", "Mixmag - The Greatest Dance Tracks of All Time"),
("Ben Howard", "Every Kingdom"),
("Stereophonics", "Graffiti On the Train"),
("The Script", "#3"),
("Stornoway", "Tales from Terra Firma"),
("David Bowie", "Hunky Dory (Remastered)"),
("Worship Central", "Let It Be Known (Live)"),
("Ellie Goulding", "Halcyon"),
("Various Artists", "Dermot O'Leary Presents the Saturday Sessions 2013"),
("Stereophonics", "Graffiti On the Train (Deluxe Version)"),
("Dido", "Girl Who Got Away (Deluxe)"),
("Hurts", "Exile"),
("Bruno Mars", "Doo-Wops & Hooligans"),
("Calvin Harris", "18 Months"),
("Olly Murs", "Right Place Right Time"),
("Alt-J (?)", "An Awesome Wave"),
("One Direction", "Take Me Home"),
("Various Artists", "Pop Stars"),
("Various Artists", "Now That's What I Call Music! 83"),
("John Grant", "Pale Green Ghosts"),
("Paloma Faith", "Fall to Grace"),
("Laura Mvula", "Sing To the Moon (Deluxe)"),
("Duke Dumont", "Need U (100%) [feat. A*M*E] - EP"),
("Watsky", "Cardboard Castles"),
("Blondie", "Blondie: Greatest Hits"),
("Foals", "Holy Fire"),
("Maroon 5", "Overexposed"),
("Bastille", "Pompeii (Remixes) - EP"),
("Imagine Dragons", "Hear Me - EP"),
("Various Artists", "100 Hits: 80s Classics"),
("Various Artists", "Les Misérables (Highlights From the Motion Picture Soundtrack)"),
("Mumford & Sons", "Sigh No More"),
("Frank Ocean", "Channel ORANGE"),
("Bon Jovi", "What About Now"),
("Various Artists", "BRIT Awards 2013"),
("Taylor Swift", "Red"),
("Fleetwood Mac", "Fleetwood Mac: Greatest Hits"),
("David Guetta", "Nothing But the Beat Ultimate"),
("Various Artists", "Clubbers Guide 2013 (Mixed By Danny Howard) - Ministry of Sound"),
("David Bowie", "Best of Bowie"),
("Laura Mvula", "Sing To the Moon"),
("ADELE", "21"),
("Of Monsters and Men", "My Head Is an Animal"),
("Rihanna", "Unapologetic"),
("Various Artists", "BBC Radio 1's Live Lounge - 2012"),
("Avicii & Nicky Romero", "I Could Be the One (Avicii vs. Nicky Romero)"),
("The Streets", "A Grand Don't Come for Free"),
("Tim McGraw", "Two Lanes of Freedom"),
("Foo Fighters", "Foo Fighters: Greatest Hits"),
("Various Artists", "Now That's What I Call Running!"),
("Swedish House Mafia", "Until Now"),
("The xx", "Coexist"),
("Five", "Five: Greatest Hits"),
("Jimi Hendrix", "People, Hell & Angels"),
("Biffy Clyro", "Opposites (Deluxe)"),
("The Smiths", "The Sound of the Smiths"),
("The Saturdays", "What About Us - EP"),
("Fleetwood Mac", "Rumours"),
("Various Artists", "The Big Reunion"),
("Various Artists", "Anthems 90s - Ministry of Sound"),
("The Vaccines", "Come of Age"),
("Nicole Scherzinger", "Boomerang (Remixes) - EP"),
("Bob Marley", "Legend (Bonus Track Version)"),
("Josh Groban", "All That Echoes"),
("Blue", "Best of Blue"),
("Ed Sheeran", "+"),
("Olly Murs", "In Case You Didn't Know (Deluxe Edition)"),
("Macklemore & Ryan Lewis", "The Heist (Deluxe Edition)"),
("Various Artists", "Defected Presents Most Rated Miami 2013"),
("Gorgon City", "Real EP"),
("Mumford & Sons", "Babel (Deluxe Version)"),
("Various Artists", "The Music of Nashville: Season 1, Vol. 1 (Original Soundtrack)"),
("Various Artists", "The Twilight Saga: Breaking Dawn, Pt. 2 (Original Motion Picture Soundtrack)"),
("Various Artists", "Mum - The Ultimate Mothers Day Collection"),
("One Direction", "Up All Night"),
("Bon Jovi", "Bon Jovi Greatest Hits"),
("Agnetha Fältskog", "A"),
("Fun.", "Some Nights"),
("Justin Bieber", "Believe Acoustic"),
("Atoms for Peace", "Amok"),
("Justin Timberlake", "Justified"),
("Passenger", "All the Little Lights"),
("Kodaline", "The High Hopes EP"),
("Lana Del Rey", "Born to Die"),
("JAY Z & Kanye West", "Watch the Throne (Deluxe Version)"),
("Biffy Clyro", "Opposites"),
("Various Artists", "Return of the 90s"),
("Gabrielle Aplin", "Please Don't Say You Love Me - EP"),
("Various Artists", "100 Hits - Driving Rock"),
("Jimi Hendrix", "Experience Hendrix - The Best of Jimi Hendrix"),
("Various Artists", "The Workout Mix 2013"),
("The 1975", "Sex"),
("Chase & Status", "No More Idols"),
("Rihanna", "Unapologetic (Deluxe Version)"),
("The Killers", "Battle Born"),
("Olly Murs", "Right Place Right Time (Deluxe Edition)"),
("A$AP Rocky", "LONG.LIVE.A$AP (Deluxe Version)"),
("Various Artists", "Cooking Songs"),
("Haim", "Forever - EP"),
("Lianne La Havas", "Is Your Love Big Enough?"),
("Michael Bublé", "To Be Loved"),
("Daughter", "If You Leave"),
("The xx", "xx"),
("Eminem", "Curtain Call"),
("Kendrick Lamar", "good kid, m.A.A.d city (Deluxe)"),
("Disclosure", "The Face - EP"),
("Palma Violets", "180"),
("Cody Simpson", "Paradise"),
("Ed Sheeran", "+ (Deluxe Version)"),
("Michael Bublé", "Crazy Love (Hollywood Edition)"),
("Bon Jovi", "Bon Jovi Greatest Hits - The Ultimate Collection"),
("Rita Ora", "Ora"),
("g33k", "Spabby"),
("Various Artists", "Annie Mac Presents 2012"),
("David Bowie", "The Platinum Collection"),
("Bridgit Mendler", "Ready or Not (Remixes) - EP"),
("Dido", "Girl Who Got Away"),
("Various Artists", "Now That's What I Call Disney"),
("The 1975", "Facedown - EP"),
("Kodaline", "The Kodaline - EP"),
("Various Artists", "100 Hits: Super 70s"),
("Fred V & Grafix", "Goggles - EP"),
("Biffy Clyro", "Only Revolutions (Deluxe Version)"),
("Train", "California 37"),
("Ben Howard", "Every Kingdom (Deluxe Edition)"),
("Various Artists", "Motown Anthems"),
("Courteeners", "ANNA"),
("Johnny Marr", "The Messenger"),
("Rodriguez", "Searching for Sugar Man"),
("Jessie Ware", "Devotion"),
("Bruno Mars", "Unorthodox Jukebox"),
("Various Artists", "Call the Midwife (Music From the TV Series)"
);
~~~
使用 SQLite 命令行导入数据
~~~
sqlite3 data/zftutorial.db < data/album-fixtures.sql
~~~
### 安装依赖包
~~~
composer require zendframework/zend-paginator
~~~
### 设置服务管理器
> config/autoload/paginator.global.php
~~~
<?php
use Zend\Paginator\ConfigProvider;
return [
'service_manager' => (new ConfigProvider())->getDependencyConfig(),
];
~~~
### 修改模型数据表
> module/Album/src/Model/AlbumTable.php
~~~
namespace Album\Model;
use RuntimeException;
use Zend\Db\ResultSet\ResultSet;
use Zend\Db\Sql\Select;
use Zend\Db\TableGateway\TableGatewayInterface;
use Zend\Paginator\Adapter\DbSelect;
use Zend\Paginator\Paginator;
class AlbumTable
{
/* ... */
public function fetchAll($paginated = false)
{
if ($paginated) {
return $this->fetchPaginatedResults();
}
return $this->tableGateway->select();
}
private function fetchPaginatedResults()
{
// Create a new Select object for the table:
$select = new Select($this->tableGateway->getTable());
// Create a new result set based on the Album entity:
$resultSetPrototype = new ResultSet();
$resultSetPrototype->setArrayObjectPrototype(new Album());
// Create a new pagination adapter object:
$paginatorAdapter = new DbSelect(
// our configured select object:
$select,
// the adapter to run it against:
$this->tableGateway->getAdapter(),
// the result set to hydrate:
$resultSetPrototype
);
$paginator = new Paginator($paginatorAdapter);
return $paginator;
}
/* ... */
}
~~~
### 修改控制器
> module/Album/src/Controller/AlbumController.php
~~~
/* ... */
public function indexAction()
{
// Grab the paginator from the AlbumTable:
$paginator = $this->table->fetchAll(true);
// Set the current page to what has been passed in query string,
// or to 1 if none is set, or the page is invalid:
$page = (int) $this->params()->fromQuery('page', 1);
$page = ($page < 1) ? 1 : $page;
$paginator->setCurrentPageNumber($page);
// Set the number of items per page to 10:
$paginator->setItemCountPerPage(10);
return new ViewModel(['paginator' => $paginator]);
}
/* ... */
~~~
### 更新视图脚本
> module/Album/view/album/album/index.phtml
~~~
<?php
$title = 'My albums';
$this->headTitle($title);
?>
<h1><?= $this->escapeHtml($title); ?></h1>
<p>
<a href="<?= $this->url('album', ['action' => 'add']) ?>">Add new album</a>
</p>
<table class="table">
<tr>
<th>Title</th>
<th>Artist</th>
<th> </th>
</tr>
<?php foreach ($this->paginator as $album) : // <-- change here! ?>
<tr>
<td><?= $this->escapeHtml($album->title) ?></td>
<td><?= $this->escapeHtml($album->artist) ?></td>
<td>
<a href="<?= $this->url('album', ['action' => 'edit', 'id' => $album->id]) ?>">Edit</a>
<a href="<?= $this->url('album', ['action' => 'delete', 'id' => $album->id]) ?>">Delete</a>
</td>
</tr>
<?php endforeach; ?>
</table>
<?php
// Add at the end of the file after the table:
?>
<?= $this->paginationControl(
// The paginator object:
$this->paginator,
// The scrolling style:
'sliding',
// The partial to use to render the control:
'partial/paginator',
// The route to link to when a user clicks a control link:
['route' => 'album']
) ?>
~~~
### 创建分页模板部件
> module/Application/view/partial/paginator.phtml
~~~
<?php if ($this->pageCount): ?>
<div>
<ul class="pagination">
<!-- Previous page link -->
<?php if (isset($this->previous)): ?>
<li>
<a href="<?= $this->url($this->route, [], ['query' => ['page' => $this->previous]]) ?>">
<<
</a>
</li>
<?php else: ?>
<li class="disabled">
<a href="#">
<<
</a>
</li>
<?php endif ?>
<!-- Numbered page links -->
<?php foreach ($this->pagesInRange as $page): ?>
<?php if ($page !== $this->current): ?>
<li>
<a href="<?= $this->url($this->route, [], ['query' => ['page' => $page]]) ?>">
<?= $page ?>
</a>
</li>
<?php else: ?>
<li class="active">
<a href="#"><?= $page ?></a>
</li>
<?php endif ?>
<?php endforeach ?>
<!-- Next page link -->
<?php if (isset($this->next)): ?>
<li>
<a href="<?= $this->url($this->route, [], ['query' => ['page' => $this->next]]) ?>">
>>
</a>
</li>
<?php else: ?>
<li class="disabled">
<a href="#">
>>
</a>
</li>
<?php endif ?>
</ul>
</div>
<?php endif ?>
~~~
