Zend_Paginator / Doctrine 2

Posted by Kevin on Stack Overflow See other posts from Stack Overflow or by Kevin
Published on 2011-03-02T15:23:49Z Indexed on 2011/03/02 15:24 UTC
Read the original article Hit count: 191

Filed under:

zend-framework

|

doctrine2

I'm using Doctrine 2 with my Zend Framework application and a typical query result could yield a million (or more) search results.

I want to use Zend_Paginator in line with this result set. However, I don't want to return all the results as an array and use the Array adapter as this would be inefficient, instead I would like to supply the paginator the total amount of rows then and array of results based on limit/offset amounts.

Is this doable using the Array adapter or would I need to create my own pagination adapter?

© Stack Overflow or respective owner

Related posts about zend-framework

Zend framework Zend_Controller_Action_HelperBroker::addPath does not work

as seen on Stack Overflow - Search for 'Stack Overflow'
I get this message regardless of the path used and even if I place the class file in the default directory location. Zend_Controller_Action_HelperBroker::addPath('./Plugins/Helpers','Helper'); Sorry, An error has occured: Application Error:exception 'Zend_Loader_PluginLoader_Exception' with message… >>> More
Problem setting up Zend Framework to run with Netbeans

as seen on Server Fault - Search for 'Server Fault'
I am trying to get Zend Framework working with netbeans, but every time there is the error "php.exe"' is not recognized as an internal or external command, operable program or batch file. I am using WAMP server 2.0 it is installed in e:\wamp My Zend framework is inside e:\wamp\www\ZendFramework-1… >>> More
How do I use PHPUnit with Zend Framework?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to know how to write PHPUnit tests with Zend_Test and in general with PHP. >>> More
Code to plug into a Zend Framework project

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, Im currently working on a website in the Zend Framework and finding it very useful indeed. I want both a blog and a forum in this website and wondered if there are any open-source projects of this nature that I would be able to simply copy and paste into my modular project. I was… >>> More
Displaying locale percentage number with Zend Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know how to display a percentage format based on the locale using the zend framework? I've tried this below and it doesn't work for some reason: $xx = Zend_Locale::getTranslation(null, 'PercentNumber'); // This outputs: "#,##0%" for locale 'en_us' $percentage = Zend_Locale_Format::getNumber(133… >>> More

Related posts about doctrine2

Testing a Doctrine2 Entity with assertEquals results in fatal out-of-memory error

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a PHPUnit test that's using a Doctrine2 custom repository and Doctrine Fixtures. I wanted to test that a query gave me back an expected entity from my fixture. But when I try $this->assertEquals($expectedEntity, $result);, I get Fatal error: out of memory. I'm guessing it is recursing into… >>> More
How to debug MySQL/Doctrine2 Queries?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using MySQL with Zend Framework & Doctrine 2. I think even if you don't use Doctrine 2, you will be familiar with errors like SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for… >>> More
Not finding field in polymorphic association with Doctrine2

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a polymorphic association (Class Table Inheritance) and I need use DQL to query entities of a specific child class wich can be done using "x INSTANCE OF Entity" in WHERE clause. Now I need to put conditions specific for that child class but I get this error: "Class Person has no association… >>> More
Doctrine2 ArrayCollection

as seen on Stack Overflow - Search for 'Stack Overflow'
Ok, I have a User entity as follows <?php class User { /** * @var integer * @Id * @Column(type="integer") * @GeneratedValue */ protected $id; /** * @var \Application\Entity\Url[] * @OneToMany(targetEntity="Url", mappedBy="user", cascade={"persist"… >>> More
Doctrine2 update both sides of association

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using this to update both sides of an association but want to know if there is a more efficient way to do this. In this case, it is a self-referencing OneToMany parent/child association: public function setParent(Node $parent, $inverse = true) { $this->parent = $parent; if($inverse) … >>> More