title: How to display all rows / records from a database table with pagination?
body: <p>I have hundreds of records in a database table.</p>
  <h2>Code:</h2>
  <pre><code>$result = mysqli_query($con,&quot;SELECT * FROM booking_tbl&quot;);
                  
  echo &quot;&lt;table border='1'&gt;
          &lt;tr&gt;
          &lt;th&gt;Booking ID&lt;/th&gt;
          &lt;th&gt;Name&lt;/th&gt;
          &lt;/tr&gt;&quot;;
          
          while($row = mysqli_fetch_array($result)) {
            echo &quot;&lt;tr&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['booking_nmbr'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot;.$row['name_title'].&quot; &quot;.$row['sender'].&quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;/tr&gt;&quot;;
          }
  
          echo &quot;&lt;/table&gt;&quot;;
  
          mysqli_close($con);
  </code></pre>
  <p>It show all the records from the table <code>booking_tbl</code>.</p>
  <p>But <strong>I want to break the results 25 per page.</strong> How can I do that?</p>