php - Handling custom table data in WordPress -

php - Handling custom table data in WordPress -

i'm making plugin wordpress , requires custom tables of mine (or info in them, specific). these tables simple. contain id , varchar field. do not mention meta fields. using custom tables reason. problem is, need allow user edit info in these tables. insert, update , delete rows in tables. how handle in wordpress?

i can create own custom pages , create whole scheme editing, inserting , updating them that's workaround since none of native wordpress.

the thing came making them custom post types , having wordpress allow me utilize native adding, editing , deleting menu (the same 1 used in posts, pages, etc.). though new problems arise. need connect post ids rows in custom tables , careful when editing, updating , deleting create sure both posts , custom table info remain consistent each other. , that's whole new layer of complexity.

so wondering if there's elegant way handle these sorts of simple tables. if there isn't i'll find own workaround.

edit:

the plugin i'm making supposed turn wordpress site kind of advertisement posting site. , need custom tables provide details ads.

refer codex wp_list_table. can play custom table data. more can go through illustration plugin.

php mysql wordpress