pagination php

[rwahdan]

Hi,

I have the below code that will calculate number of records in the table inside my DB. What i need to do now is to show 5 records each time and have number under that to show next records like 1 2 3 ...

Code: Select all

<?php
// You can place PHP like this

	$db = JFactory::getDBO(); 
	$query = "SELECT SQL_CALC_FOUND_ROWS * FROM tbl_userlogs";
	$db->setQuery( $query );
	$rows = $db->loadObjectList(); 

	$db->setQuery('SELECT FOUND_ROWS();');
	$count = $db->loadResult() ;

	echo $count;

?>

Thanks

[SharkyKZ]

Create a component. Stick with Joomla's MVC which already does what you need. See this guide https://docs.joomla.org/J3.x:Developing ... _Component

You can use a tool like https://ibrini.com/en/ or https://www.component-creator.com/en/ to easily create basic components.

[rwahdan]

Thanks,
there is no way to do through php coding? I don't know how to create components, I just need to include this in a module.

[SharkyKZ]

There is, that's the point. You can write as much custom code as you want. But Joomla already contains code to create paginated views in components. If it needs pagination, it should probably be a component, not a module.

If you really need a module, you can try this:

Code: Select all

use Joomla\CMS\Pagination\Pagination;
$pagination = new Pagination($total, $start, $limit);
echo $pagination->getListFooter();

But this will cause issues because the links will point to different pages inside current component (you can't link to a module).

[rwahdan]

There is, that's the point. You can write as much custom code as you want. But Joomla already contains code to create paginated views in components. If it needs pagination, it should probably be a component, not a module.

If you really need a module, you can try this:

Code: Select all

use Joomla\CMS\Pagination\Pagination;
$pagination = new Pagination($total, $start, $limit);
echo $pagination->getListFooter();

But this will cause issues because the links will point to different pages inside current component (you can't link to a module).

Thanks for the answer, now i guess i will have to make a component then...can you guide me what i will need to do to achieve my goal (tips not codes)?

[Per Yngve Berg]

https://docs.joomla.org/J3.x:Developing ... _Component