Re: [fw-general] Question about zend pagination

2008-11-19 Thread Matthew Ratzloff
Your route doesn't have a :page parameter like the example shows. -Matt On Wed, Nov 19, 2008 at 7:39 AM, vladimirn <[EMAIL PROTECTED]> wrote: > > Matt, thanks for posting this link and quote rom documents. > I've already read that before i posted in here :) > How to use that in my example? > > Ma

Re: [fw-general] Question about zend pagination

2008-11-19 Thread vladimirn
Matt, thanks for posting this link and quote rom documents. I've already read that before i posted in here :) How to use that in my example? Matthew Ratzloff wrote: > > From the documentation: > The following is an example route you might use in an INI configuration > file: > > routes.example.r

Re: [fw-general] Question about zend pagination

2008-11-18 Thread Matthew Ratzloff
>From the documentation: The following is an example route you might use in an INI configuration file: routes.example.route = articles/:articleName/:page routes.example.defaults.controller = articles routes.example.defaults.action = view routes.example.defaults.page = 1 routes.example.reqs.article

Re: [fw-general] Question about zend pagination

2008-11-18 Thread vladimirn
I have this in my route: $route = new Zend_Controller_Router_Route( 'display/:pid/:wid/:type', array( 'controller' => 'banners', 'action' => 'display' ) ); $router->addRoute('display', $route); Matthew Ratzloff wrote: > > Do you define a "page" parameter in your

Re: [fw-general] Question about zend pagination

2008-11-18 Thread Daniel Tangermann
In your link to the next or whatever resultpage site: Are you sure that param page is there? Try something like Zend_Debug::dump($this->_request->getParams()) You should see page = something In my paginator template I link to /baseUrl/module/controller/page/2 /baseUrl/module/controller/2 woul

Re: [fw-general] Question about zend pagination

2008-11-18 Thread Matthew Ratzloff
Do you define a "page" parameter in your route? -Matt On Tue, Nov 18, 2008 at 10:14 AM, vladimirn <[EMAIL PROTECTED]> wrote: > > Thank you Daniel, > This is my view script: > paginator)): ?> > > paginator as $banner): ?> > > " $banner['bannerurl'] > ? "> > > > > > > On the page i am getting

Re: [fw-general] Question about zend pagination

2008-11-18 Thread vladimirn
Thank you Daniel, This is my view script: paginator)): ?> paginator as $banner): ?> " On the page i am getting expected amount of results. Then in my controller: $db = Zend_Registry::get ( 'db' ); $select = $db->select () ->

Re: [fw-general] Question about zend pagination

2008-11-18 Thread Daniel Tangermann
I would love to, but you have to be a little more specific what is not working? Do you get an expected result without $paginator? Dou you see the expected amount of results on page 1? How does your link look like for the next page? The more information you provide, the better one can help you

Re: [fw-general] Question about zend pagination

2008-11-18 Thread vladimirn
Can anyone help on this please? :) -- View this message in context: http://www.nabble.com/Question-about-zend-pagination-tp20543032p20555822.html Sent from the Zend Framework mailing list archive at Nabble.com.

Re: [fw-general] Question about zend pagination

2008-11-17 Thread vladimirn
i cant provide a link it is on my localhost :( However, i cant get it working.. -- View this message in context: http://www.nabble.com/Question-about-zend-pagination-tp20543032p20547855.html Sent from the Zend Framework mailing list archive at Nabble.com.

Re: [fw-general] Question about zend pagination

2008-11-17 Thread Daniel Tangermann
Can you provide a link? I am not using Zend_View but a smarty solution. When you dump $paginator, do you have the correct results? So only the necessary amount of rows? Are you sure $page is filled? Kinda like: $page = 1; if($this->_getParam('page ')){ $page = $this->_g

Re: [fw-general] Question about zend pagination

2008-11-17 Thread vladimirn
Thank you for swift replay :) Now i went with this: $page = $this->_request->getParam('page') ; $db = Zend_Registry::get ( 'db' ); $select = $db->select () ->from ( 'banners', array ('bannerurl', 'height', 'width', '

Re: [fw-general] Question about zend pagination

2008-11-17 Thread Daniel Tangermann
$paginator = Zend_Paginator::factory($select); $select has to be an instance of Zend_Db_Select Build your query with Zend_Db_Select and it shoud work $select = $this->db->select() ->from(array('a' => 'banners '), array('*')) ->where('active = ?', 'y') ->where('progra

[Fwd: [fw-general] Question about zend pagination]

2008-11-17 Thread Daniel Tangermann
Try not to pass the total $result array. Let paginator execute the query. $paginator = Zend_Paginator::factory($select); $paginator->setItemCountPerPage(10); $paginator->setCurrentPageNumber($page); $paginator->setPageRange(10); $paginator->setDefaultScrollingSt

[fw-general] Question about zend pagination

2008-11-17 Thread vladimirn
I have a problem with zend pagination. In my controller i have this: $result = $db->fetchAll ( $sql ); $page = $this->_getParam ( 'page', 1 ); $paginator = Zend_Paginator::factory ( $result ); $paginator->setItemCountPerPage ( 2 );