Welcome Guest, Not a member yet? Register   Sign In
Meet CodeIgniter MY_Model
#22

Added paginate() method. This one will allow you to paginate the results. You can do this by simply changing get_all() method with paginate() method. The paginate() method can receive up to three parameters:


- first paramater, which is optional (default is set to 10) is the number of rows per page;
- second parameter, which is optional (default is set to NULL), is the total of rows;
- the third parameter, which is also optional (default is set to 1) is the page you want to get.

If you only passed the first parameter, the page number will be retrieved from the URL (the last segment of the page). If you didn't pass the second parameter you will only be able to output the previous and next page, without links to all the pages.

Example:

PHP Code:
$total_posts $this->post_model->count(); // retrieve the total number of posts
$posts $this->post_model->paginate(10,$total_posts); // paginate with 10 rows per page
echo $this->post_model->all_pages// will output links to all pages like this model: "< 1 2 3 4 5 >". It will put a link if the page number is not the "current page"
echo $this->post_model->previous_page// will output link to the previous page like this model: "<". It will only put a link if there is a "previous page"
echo $this->post_model->next_page// will output link to the next page like this model: ">". It will only put a link if there is a "next page" 
Reply


Messages In This Thread
Meet CodeIgniter MY_Model - by Avenirer - 02-20-2015, 02:47 AM
RE: Meet CodeIgniter MY_Model - by Rufnex - 02-20-2015, 03:24 AM
RE: Meet CodeIgniter MY_Model - by spjonez - 02-20-2015, 05:55 AM
RE: Meet CodeIgniter MY_Model - by dmyers - 02-20-2015, 08:58 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-25-2015, 02:50 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-25-2015, 02:52 AM
RE: Meet CodeIgniter MY_Model - by spjonez - 02-25-2015, 05:57 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-25-2015, 06:28 AM
RE: Meet CodeIgniter MY_Model - by spjonez - 02-25-2015, 07:07 PM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-26-2015, 01:54 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-26-2015, 05:46 AM
RE: Meet CodeIgniter MY_Model - by spjonez - 02-26-2015, 06:55 PM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-26-2015, 11:51 PM
RE: Meet CodeIgniter MY_Model - by Avenirer - 02-27-2015, 12:35 AM
RE: Meet CodeIgniter MY_Model - by spjonez - 03-03-2015, 04:36 PM
RE: Meet CodeIgniter MY_Model - by Avenirer - 03-04-2015, 06:57 AM
RE: Meet CodeIgniter MY_Model - by mwhitney - 03-06-2015, 11:27 AM
RE: Meet CodeIgniter MY_Model - by spjonez - 03-09-2015, 05:41 AM
RE: Meet CodeIgniter MY_Model - by ivantcholakov - 03-09-2015, 12:52 PM
RE: Meet CodeIgniter MY_Model - by spjonez - 03-11-2015, 06:27 AM
RE: Meet CodeIgniter MY_Model - by san1020 - 03-12-2015, 05:14 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 03-16-2015, 03:14 AM
RE: Meet CodeIgniter MY_Model - by ircdirk - 03-25-2015, 06:52 AM
RE: Meet CodeIgniter MY_Model - by dgvirtual - 09-25-2016, 01:06 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 09-27-2016, 11:26 PM
RE: Meet CodeIgniter MY_Model - by dgvirtual - 09-28-2016, 12:00 AM
RE: Meet CodeIgniter MY_Model - by Avenirer - 09-28-2016, 12:17 AM



Theme © iAndrew 2016 - Forum software by © MyBB