mysql - How to show result of sql query in a page?

I have a table in the same DB that I have a WordPress page and I want to show in the land page the count of total of rows and then I need an another page that show the information of this table , How can I do this?

And I want to be easy to add, for example that I can add the count or the information like presing edit page and in the add section there is something like "Total count" or "Total information". I see in add menú that I have some widgets like "Shortcode", "Categories", "Archives", "Latest comments", "Latest Posts" how can I add a custom widget here?

I have a table in the same DB that I have a WordPress page and I want to show in the land page the count of total of rows and then I need an another page that show the information of this table , How can I do this?

And I want to be easy to add, for example that I can add the count or the information like presing edit page and in the add section there is something like "Total count" or "Total information". I see in add menú that I have some widgets like "Shortcode", "Categories", "Archives", "Latest comments", "Latest Posts" how can I add a custom widget here?

• mysql
• sql
• mssql

Share Improve this question edited Feb 22, 2019 at 7:58 Patofet asked Feb 22, 2019 at 7:22 PatofetPatofet 122 bronze badges 2

• 2 Possible duplicate of How to execute SQL SELECT query and see the results? – Jacob Peattie Commented Feb 22, 2019 at 7:25
• I edit the question to add more information – Patofet Commented Feb 22, 2019 at 7:34

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

Solved! I follow this tutorial:

https://wordpress/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/writing-your-first-block-type/

https://wordpress/gutenberg/handbook/designers-developers/developers/tutorials/block-tutorial/creating-dynamic-blocks/

And complimented with this: https://gist.github/mattheu/7cf235b4f932de891bc21cb5f3ff3de6