In order to use this code, you have to do a few things.
- You have to change the dbname, host, username and password.
- You can customize the table by changing, deleting or adding new fields.
- Go to your WP Admin Backend
- Click on Tools -> Theme File Editor
- Click on your desired Theme or don't if you want to use the active Theme
- Click on theme functions on the right side of the Site
- Go to the bottom of the code
- Paste the code you've adjusted to your needds
- Click on save
- Go to the Page where you want the table
- Add the shortcode [sqltable]