Friday, March 23, 2012

How can I paginate data from different database's table in cakephp?

I have two database users and magento. magento is reside at remote
machine in LAN. and users is reside at my local machine.

connection between them and fetching data from that magento database
is working fine but I want to do pagination on magento's table data.
simple displaying it is done, but for pagination we require model
name, and how can i have model of other database??

// in controller action
$this->Vendor->changeDataSource('vsdatabase');
if($this->changeDbSource('vsdatabase'))
{
$magento_data = $this->Vendor->query("SELECT * from
admin_user");
$this->set('products',$magento_data);
}

and changeDataSource($newdb) is defined in model file
and changeDbSource($database='default') in controller

so how can I solve my problem with pagination? I have completed
fetching data without pagination. or any other option to do this?
Thanks,

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: