Skip to main content

PHP Pagination

The Pagination class is one that always gives me trouble when using someone else's code. I've created this class and hopefully have documented it enough for you to jump right into it.

All you'll need to do is add the following code to the class that you're using:
  • Instantiate the Pagination class
  • Add the $per_page variable and set it to how-many you want to display per pag.
    • i.e. $per_pag = 20;
  • Call the getStartAt() method to create the int from where the sql query will begin. This is the query that calls your items to be displayed to the page and really has nothing more to do with the rest of the pagination: $start_at = $this->_pagination_obj->getStartAt($per_page);
    • $sql = "SELECT vehicle, image FROM customer_rides WHERE approved = '1'";
    • $sql .= " AND brand = 'XX'";
    • $sql .= " LIMIT $start_at, $per_page";
  • At the end of the code, you'll need to call the createPageNumbers() method and pass the sql code to select the number of rows that are active in that table.
    • $sql = "SELECT id FROM customer_rides WHERE approved = '1' AND brand = 'XX'";
    • $this->_pagination_obj->createPageNumbers($sql);
The first class is the PaginationExample. Quite a significant amount of code has been deleted from the class and the method displayCustomerRides() so that the pagination can easily be followed.



And here's the pagination class itself:

Comments

Post a Comment

Popular posts from this blog

Beginner Java Exercise: Sentinel Values and Do-While Loops

In my previous post on while loops, we used a loop-continuation-condition to test the arguments. In this example, we'll loop at a sentinel-controlled loop. The sentinel value is a special input value that tests the condition within the while loop. To jump right to it, we'll test if an int variable is not equal to 0. The data != 0 within the while (data != 0) { ... } is the sentinel-controlled-condition. In the following example, we'll keep adding an integer to itself until the user enters 0. Once the user enters 0, the loop will break and the user will be displayed with the sum of all of the integers that he/she has entered. As you can see from the code above, the code is somewhat redundant. It asks the user to enter an integer twice: Once before the loop begins, and an x amount of times within the loop (until the user enters 0). A better approach would be through a do-while loop. In a do-while loop, you "do" something "while" the condition...
13 comments
Read more

Programming Language Concepts Test Questions/Answers

One of the easiest methods that I use to learn new topics is by creating notes on the subject and then by turning those notes into questions and answers. Remembering answers to questions just seems more natural. I was able to memorize 323 questions and answers in a matter of a couple of days. I wanted to start doing this for some topics that I find pretty interesting. To begin, here are some questions and answers to Programming Language Concepts (PLC). I'm reading your mind right now and the answer is yes, there will be more. 1. Name 3 reasons for studying PLC. - Better understanding of current programming languages - Advancement of computing - Increased capability to express ideas - Increased capability to learn new programming language. - Better understanding of which programming language to choose.  2. Name the 5 programming domains and languages best suited for each. - Scientific (Fortran, ALGOL 60) - Business (COBOL) - AI (Lisp, Scheme, Prolog) - Web (PHP, ...
12 comments
Read more

Laravel 6.x with React and react-router

This will get you started on getting your first React/Laravel application deployed to your server. We'll cover everything from installation to deployment. Start by reading the installation instructions on  https://laravel.com/docs/6.x#installing-laravel . We'll cover those details below. Setting Up Laravel Check that you have the latest version of PHP installed on your computer.  It must be >= 7.2.0. Open terminal to get the Laravel installation tool. Type in composer global require laravel/installer Type in laravel to verify installation. Navigate to a directory on your computer where you want to install your project on your terminal. Run the following command: laravel new project_name (replace project_name with your project name). Once complete, cd into your new project. Type the following command: php artisan serve. You'll get a message like the following if it's running successfully: Laravel development server started: http://127.0.0.1:8000 ...
53 comments
Read more