Displaying WP SQL data from an existing table | ww.wp.xz.cn

Resolved andys007
(@andys007)

3 years, 3 months ago

Hi I have a WP site where I have a table within the WordPress SQL DB which contains anglers catch details. I want to have some simple tabular reports of this data based on various selection criteria display as WP pages. I used to use an old plugin called WP Tables which is no longer supported and I can’t upgrade to my site to PHP8.1, until I find an alternative. Will your plugin do this? I have installed it and cannot see how to do what I want. Thanks Andy

Viewing 3 replies - 1 through 3 (of 3 total)

Leeberty
(@aaronvincentlee)

3 years, 3 months ago

Hi @andys007 ,

Thanks for reaching out! Let me help you with this.

WP Data Access Data Tables allow users to create responsive data tables from local and remote databases.

For a step-by-step guide, please watch: https://wpdataaccess.com/docs/data-tables/creating-data-tables/

Here’s a live demo of a data table. See: https://wpdataaccess.com/responsive-data-table-demo/

Let us know if you have questions.

Thread Starter andys007
(@andys007)

3 years, 2 months ago

Brilliant this is just what is required.. Just one small question, is there an option to specify the number of lines per page?
Plugin Contributor Kim L
(@kimmyx)

3 years, 2 months ago
Hi @andys007,

Yep! In the Advanced Settings of your table, please include the following option:
```
{
"pageLength": 30
}
```
Please see this page to learn more about Advanced Settings: Advanced settings | WP Data Access

Hope this helps! Let us know if you have more questions.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Displaying WP SQL data from an existing table’ is closed to new replies.

Tags

sql

3 replies
3 participants
Last reply from: Kim L
Last activity: 3 years, 2 months ago
Status: resolved