I'm working on a Zend Framework (1.7) project with a structure loosely based on the structure of the quickstart application - front controller, action controllers, views & models that use Zend_Db_Table to get to the database. One of my main models relies on some expensive joins to pull up its primary listing, so I'm looking into using Z...
Hi, is there a way, hot to apply paginator limit on select, which I send to findDependentRowset function? for example: $select = $row->select(); $select->order('item_name'); $row->findDependentRowset($table, null, $select) thank's ...
I am having a serious problem converting my 'select' statement into something that will work with the zend paginator... could someone have a crack at it, as I am having no luck... Here is my query: $query = "SELECT user_id, name, gender, city, province, country, image_id, one_liner, self_description, reputation FROM ...
I'm currently using ezSQL, which I believe to be a great SQL wrapper. I've been tasked with adding in pagination that we can just drop in. Zend has one, which seems like it should work, as it's loosely coupled with the rest of Zend. I'm returning an array with ezSQL, ala: $results = $db->get_results("SELECT * FROM table", ARRAY_A); ...
Hi, I am not sure if this is the most sensible way of doing this but I thought I would ask anyway. I have a 'wizard' that I am developing for users to review data that is stored in the database. Each part of the wizard is a simple Zend_Form allowing the users to review and edit the data. However one element of the wizard needs to be a...
Hello, I am about to use Zend_Paginator class in my project. I found examples of the class on the internet. One of them is $sql = 'SELECT * FROM table_name '; $result = $db->fetchAll($sql); $page=$this->_getParam('page',1); $paginator = Zend_Paginator::factory($result); $paginator->setItemCountPerPage(10)); $paginat...
I register the data to cache and I see the foliowing : zend_cache---Zend_Paginator_1_42242d5fa3c4e4b7758810c276163e8a but I can't read. $request = $this->getRequest(); $q = new Model(); $paginator = Zend_Paginator::factory($q->fetchAll()); $paginator->setCurrentPageNumber($request->getParam('p')); $paginator->setItemCountPerPage...
Is it possible to use the findParentRow() method from within a Zend_Paginator Object? I'm trying some code that works fine on an object returned by fetchAll from a DB resultset and works fine. With the Zend_Paginator object it doesnt work though. In my controller i have: public function downloadedAction() { $images = new Model_Appl...
Hello, I started using Zend_Paginator, it works everything fine but I noticed that there is one more query which slows the load time down. The additional query: SELECT COUNT(1) AS `zend_paginator_row_count` FROM `content` The normal query: SELECT `content`.`id`, `content`.`name` FROM `content` LIMIT 2 PHP: $adapter = new Zend_Pag...
Hi , Trying to grab the params after ?. I need them to add to the Zend_Paginator. ex: http://www.example.com/test/show?name=xxx&age=20&sex=m Building a paginator for search results. Is there any solution for that ? $router = new Zend_Controller_Router_Route_Regex( 'test/show\?(.*)', array( ...
Hello, Without sticking /1 onto a url is there away to change Zend_Paginator to approach a URL? Currently the user goes to /aaron/studio. Then the user should click through the paging and start accessing URLS such as : /aaron/studio/2 I have this rule: $router->addRoute('studios/page', new Zend_Controller_Router_Route(':id/studio/:p...
Hi, I have a working paginator. I combine Zend Paginator and jQuery to switch between pages. My problem is that the page links only have a range from 1 to 10 but it should be e.g. from 1 to 13. I can get to page 13 by clicking the forward button but the page link 13 is not displayed. Paginator setup: $paginator = new Zend_Paginator (...
I want to use Zend_Paginator but Zend_Paginator requires Zend_Db_Select as input parameter. My SQL query is some how a little complicated making it so difficult to implement with Zend_Db_Select. Can i use Zend_Paginator with plain SQL query? ...
Hi all I'm using Zf 1.10 on a project, and have been using Zend_Paginator together with Zend_DbTable queries quite successfully until this bit. The query requires a DISTINCT keyword to remove duplicate rows created by a join, but when I add it, the paginator incorrectly displays navigation for two pages of results when there is only in...