title: PHP Pagination with MySQLi
body: <p>I'm building my own CMS. I have an administration system made and I can insert posts in the database with it, showing posts isn't a problem, but I have no idea on how to do the pagination.</p>
  
  <p>And this is my query:</p>
  
  <pre><code>SELECT * FROM `posts` WHERE `status` != 'draft'
  </code></pre>