I think Pods would be a GREAT plugin for your use, based on what you currently have.
I bet you could get it functioning in Pods probably within a few minutes to an hour, using your current tables.
Here’s the process:
- Go to Pods Admin > Components > Activate ‘Advanced Content Types’
- Go through each of your custom tables, create a new ‘Advanced Content Type’ at Pods Admin > Add New
- Add the fields for each custom table, you should be able to replicate the settings in most cases, per field
- Go to your WP DB and find the
wp_pods_{your_pod_name} table, delete it, and copy your old table and name it the new wp_pods_{your_pod_name}
- Go through your custom PHP code and rename all uses of your old table names to the new
wp_pods_{your_pod_name}
- Done! Your tables and PHP application are now running from WordPress and Pods 🙂
Thread Starter
tonaua
(@tonaua)
Thanks for you reply. I will give it a try. How about all the relations between the tables?
Relations between tables is something you could potentially add through a relationship field in Pods, which stores it’s related items inside of wp_podsrel
Yes, you should, Pods is an incredibly powerful tool!
Thread Starter
tonaua
(@tonaua)
Thanks Scott. It works great!! Count me in as a new fan.
@scott
This looks like a great plugin 🙂 i’m just trying to find out how to use it, and use it on a database with data.
I have a database with a magazine, i register articles, authors, category and a few other things. I have a table for the authors, one for the category/article type, one to collect it all, but i think i need one for the title, but not sure, be course there more articles with the same title.
I have relations to authors and category, and a third one i don’t know if i need, but maby i’ll need a new one.
I if understand it right, i need to use post type for my pods ?
I then just create pods for each table ?
I’m not sure about the deleting of wp_pods and renaming the old table ?
All the best
Carsten
@boblebad You should post a new topic for your questions, this one was old and unrelated.
I’ll reply to the new one once you’ve created it.
mods, please close this topic, thanks!