anuja12 Posted May 12, 2011 Share Posted May 12, 2011 My task is to take data from different databases in different server and to display them in a single web page.I am working in joomla and i am able to take data from the databases using separate queries for each database.But the problem is that i need to give sorting and pagination to this web page. how can i do this without making any performance issue since all the databases contains a lot of data. Or can i use a single sql query for this ?? Link to comment https://forums.phpfreaks.com/topic/236205-adding-sorting-and-pagination-to-data-from-different-db/ Share on other sites More sharing options...
adi123 Posted May 12, 2011 Share Posted May 12, 2011 theres a tutorial on this link for what you are trying to do: http://api.joomla.org/__filesource/fsource_Joomla-Framework_HTML_joomlahtmlpagination.php.html Link to comment https://forums.phpfreaks.com/topic/236205-adding-sorting-and-pagination-to-data-from-different-db/#findComment-1214744 Share on other sites More sharing options...
anuja12 Posted May 17, 2011 Author Share Posted May 17, 2011 theres a tutorial on this link for what you are trying to do: http://api.joomla.org/__filesource/fsource_Joomla-Framework_HTML_joomlahtmlpagination.php.html But here i am using 12 sql queries.I cant apply pagination and sorting to these queries directly.i need to apply them to the list made using the data from all those databases. And is there any method to get data from the databases using XML . Link to comment https://forums.phpfreaks.com/topic/236205-adding-sorting-and-pagination-to-data-from-different-db/#findComment-1216407 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.