Creating tables with WP plugin


Creating tables with WP plugin



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.




Getting a list of all ID's on the site

1:



Wordpress Email subscribtion?
In WP, most plugins don't create new tables, but use the "wp_options" table, even when a new table would be "natural"..
tinymce wordpress copy and paste losing http:// prefix
For example, the "WP acronyms" plugin.


More than 1 widget in wordpress
A table with 2 columns (acronym and definition) would be natural.


add a page to sidebar
But this plugin stores the acronyms in a single row of the "wp_options" table.


Wordpress and buddypress advice
When data is necessary, the content of this row is parsed and the fields are extracted (using a delimiter).


Is there a Wordpress plugin which let the user register/login and see some new elements if he/she logs in?
You could consider using the same method..
Has anyone used Smart Image Resizer on subdomain sites?


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..



85 out of 100 based on 55 user ratings 955 reviews

@