title: How to split search results into pages?
body: <p>How to split the search results into pages? (like page 1, page 2, page 3...)</p>
  
  <p>When the user searches for products on my e-commerce website, I want results to be split into several pages showing around 20 products per page. The search results are the outcome of database query. </p>
  
  <p><strong>For example:</strong> If the user searches for Samsung mobiles so my query will be:</p>
  
  <p><code>SELECT * FROM PRODUCTS WHERE BRAND='SAMSUNG';</code></p>
  
  <p>Suppose the above query returns 55 results, how to show them into pages (1,2 and 3)?</p>
  
  <p>I am using <code>PHP</code>, <code>MySQL</code>, <code>Apache</code> on Windows machine.</p>