Tutorial :Creating tables with WP plugin



Question:

I'm beginning to write wordpress plugins, and I've found a situation where I need to create tables to continue. Can someone point to a decent tutorial on modifying Wordpress's database?

Their usually excellent documentation seems lacking on this topic.


Solution:1

In WP, most plugins don't create new tables, but use the "wp_options" table, even when a new table would be "natural".

For example, the "WP acronyms" plugin. A table with 2 columns (acronym and definition) would be natural. But this plugin stores the acronyms in a single row of the "wp_options" table. When data is necessary, the content of this row is parsed and the fields are extracted (using a delimiter). You could consider using the same method.


Solution:2

The WordPress Codex has a good article on creating database tables with Plugins.

Like Benoit said, most of the times wp_options is sufficient, but that article is a good guide to getting started with a custom table if you need it. First though, I'd advise you to look and see if it can logically be done without creating a new table. Custom Post Types can handle most of the heavy lifting for most content-related functions. The bottom of the Custom Post Types Codex entry has several good tutorials for getting started.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »