Build complex databases using wordpress

Custom post types and custom taxonomies empower wordpress to levels that allow complex database management. While the basic administration will not show you much, you can build your front side according to specific queries and searches, and as such administer your data from the front side.

  • How to build custom post type and custom taxonomies
    • the best way to build a custom post type is via the register_post_type function, instantiated as a new action  the init action, delcared your the theme specific functions file   :  if you don't want to code, you can still use the custom post type ui plugin, which apart from the advantage of being easy to use, will also let you build a theme independant custom post type database. The interesting feature of that plugin, for beginners, is that it lists all features of custom post type and also shows you the generated code it uses to create the custom post type via register_post_type. Another interesting plugin for dealing with cusomt posts types and taxonomies is the GD Custom Post plugin, whose interface lists all albels associated with  a custom post type or taxonomy.
      But you will not have the same flexibility and safety as if you were coding yourself . This last remark  applies to the custom taxonomy plugin Ultimate Taxonomy Manager, that does a very good job at dealing with custom taxonomies, but we've experienced trouble with the global permalink structure when doing specific jobs on permalinks. Same recommendation as custom post type,; use the specific register_taxonomy function to create your taxonomy.
  • How to perform complex queries
    • the ability to perform queires on multiple tags and taxonomies will help you filter your database records on the fly. Use the Query Multiple Taxonomy is a plugin that  will build specific taxonomy search dropdowns or filter links. One particular feature is that the dropdown is filtered by results from the main query :  I reused this  within the code that lists all tags and terms, filtered by results from the main query.
    • on the backend site, the advanced post manager plugin gives you a full search capability via drag and  drop
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *