WP - connecting your table with data to records?

Question

Knowledge base

Hello everyone.
I have the following situation. I want to make a knowledge base for the game based on WP.

Here is a screenshot of what it looks like in practice. I have a table from a database that has a set of all this data that I need to display. It was planned to do through custom AFC fields (for example) and put all these pages through a SQL query, attaching a request to create a record page as well.

AFC or simple work with custom fields did not suit me. So, how the record of one of my subjects will look like this:


And this is only half of the fields made. What will happen if there are thousands of these items in the database? For every 1000 items, I will have approximately 30.000 - 50.000 entries in the database.

At the moment I want to insert my table like Weapon. sql to the database. And from the template of this record, call data from this table, somehow linking this table with the record. Pages of entries in manual, such a larger number, too, no one will do. this will be done by query. Just add a request to create a record to each subject through INPUT. BUT each page should know that it needs to make a choice directly of this or that subject, which, I repeat, will be many.

Maybe there is some kind of plugin... Paid or free, it doesn't matter, which can work with custom tables and display similar results. Create pages this way. Or if there is no plugin, then how do you see the solution to such a problem. Tell.

Answer 1

So write your own logic for working with a custom table. Store all the necessary data there, including the posta id, by which you will receive data on the front.
To do this, there is such a handy thing as wpdb
In general, there is a plugin for acf that transfers its data to a separate table, but there the price is 100 bucks a year.

Answer 2

Understood, please tell me, if it's not difficult for you, what is the name of this plugin. I would like to read it in more detail. I believe that this could greatly speed up my work and the convenience of working with a similar site.
And if anyone has any other tips on how to do this, please write.