There is no license information available for the latest version (1.0.0) of this package.

A paged query class for Yii2 to deal with PHP7 changed in mysqlnd

Installs: 53 930

Dependents: 0

Suggesters: 0

Security: 0

Stars: 4

Watchers: 2

Forks: 2

Open Issues: 0


1.0.0 2016-10-04 14:42 UTC

This package is not auto-updated.

Last update: 2024-02-17 17:14:00 UTC


A paged query class for Yii2 to deal with PHP7 changes in mysqlnd

It will load your result set the same way as pagination works using OFFSET and LIMIT.

This extension is 99% for MySQL users.


Just include it in your composer:

php composer require "sammaye/yii2-pq":"~1.0.0"


$query = (new \sammaye\pq\Query)
	->orderBy(['id' => SORT_DESC]);
foreach($query->each() as $k => $v){

And it will return in batches of 100 up to 300.

As you can see there is not much to learn about this extension except how to include it.

Note: There is no active record part to this query currently due to the nature of PHP class inheritance and inclusion which means I would have to copy the ActiveQuery entirely.


I noticed that many of my cronjobs failed after an upgrade to PHP7. It was not long before I realised that there were two changes since PHP5.4:

Added to that, my own observations that unbuffered queries suck meant that I created this.