Plugin Development: Storing and Manipulating Data That Fits JSON in Database

Just a pointer in the right direction:

You’ll want a Custom Post Type bread.

Then you’ll need a Custom Taxonomy for this CPT.

The rest will probably be post meta.

If the ingredients are just used like tags without a lot of data themselves you can make them a Custom Taxonomy as well. If they have separate URLs and content you’ll probably want to implement them as CPTs and reference them via the IDs in post meta of the bread CPT.

When you create those CPTs and Taxonomies you can create them as public=false. That way they do not have their own URLs, but can be used to manage the data in the backend.
Then you can use custom queries to build the JSON just the way you need it. Either the old fashioned way or using the REST API or just by outputting it inline in the page the angular app runs.

So basically you’re only using WordPress to handle the Backend UI and then just build a JSON the way you need it for frontend.

Related Posts:

  1. Programmatically creating posts based on external JSON feed (asynchronously)
  2. Post meta vs separate database tables
  3. Is it mandatory to use $wpdb->prefix in custom tables
  4. Update Option Stored in Multi-Dimensional Array
  5. Default table collation on plugin activation?
  6. Using a database view = evil incarnate?
  7. Writing a plugin that notify my friends of new post that mentions(@) them
  8. Getting wrong relationship value in $args in wp_Query?
  9. WordPress and multithreading
  10. Not sure the best way to save custom plugin data
  11. The ideal place for storing persistent PHP objects
  12. What is the correct way for plugins to create tables with special charset/collation considerations?
  13. What is the added “complexity” of custom tables?
  14. Plugin development with unit tests
  15. How is the data stored in the database?
  16. Formatting of curly brackets array from WP database to get more readable output
  17. How to modify post content before writing to database?
  18. How to: Rest endpoint returning empty object
  19. Actions or filters fired when data is saved in a custom table
  20. get all products of one category
  21. Hello dolly type plugin that allows people to add their own
  22. Sample — test — data for large WordPress install
  23. Custom Plugin Database relations
  24. Is there any reason only 1 (my) IP would be added to this table using $wpdn->insert?
  25. How to store data for posts/pages built with drag-n-drop builder?
  26. Database for development
  27. Is there a naming convention for database tables created by a plugin?
  28. Activation hook not creating table
  29. Is the usage of ON DELETE CASCADE wrong or not allowed on wordpress?
  30. Version upgrade: can my plugin filter the SQL statements issued during a database upgrade?
  31. Saving data from block editor to the database
  32. Generate dynamic page through data from another page
  33. What for the tables ending with the meta used in database of wordpress?
  34. Creating table with plugin is not working
  35. dbDelta() Error – Incorrect index name ” for query ALTER TABLE
  36. Get a custom table to an array
  37. Update/insert only a column of database table
  38. How to Create database table when Plugin installed/activated, and delete database when Plugin deleted
  39. Subscribe to author?
  40. I’m designing a plugin to create database indexes. Suggestions?
  41. WordPress database error for query INSERT INTO
  42. How to connect to AWS RDS external database (not for the core WordPress db)
  43. How should I store a log for my plugin
  44. How to create database table, add data, update and delete using wpdb via plugins?
  45. Using WPDB to output raw XML fails because of wp-blog-header.php
  46. Are there any scripts, classes, and/or functions built-in to WP for a plugin to export/import its saved data from wp_options?
  47. Strange issue saving custom field data for a WooCommerce order
  48. Why does wp_remote_post returns an empty body response on certain endpoints?
  49. How to perform a heavy and long process in cron jobs?
  50. What might be the reason of Couldn’t fetch mysqli_result on another domain?
  51. How do I debug an error that a plugin is causing?
  52. Save temporary registration data
  53. Update plugin settings option_name for big plugin update
  54. $wpdb->update Issue
  55. dbdelta failing with error: “WordPress database error Table ‘wp_2_myPlugin’ already exists
  56. WordPress database error: [Query was empty] – using $wpdb->prepare()
  57. How to write a shopping queue line plugin with a queue button?
  58. Showing results from json-string in WordPress search results page
  59. Error code when migrate
  60. GET request return value as error instead of success
  61. Why User_login key doesn’t work with wp_update_user()
  62. How to get inserted row IDs for bulk/batch insert with wpdb query?
  63. WordPress how do I echo SUM from a column of a MySQL table by user id AND type_operation
  64. ajax response strips multidimensional array and unable to decode
  65. WordPress Fatal error: Uncaught Error: Call to undefined function dbDelta()
  66. Use admin-post to submit form data to external database
  67. Save in my custom admin page and redirect to the saved object
  68. Relational / Associate tables using native WordPress functionality
  69. WordPress doesn’t create table on plugin activation
  70. Insert Data into Database
  71. Update database record in plugin
  72. How to store in the database directly the translation?
  73. How and when would I implement some code which would take data from one part of the Db and put it in another?
  74. pull data from wordpress database
  75. Ajax not working to insert, query and result data
  76. Why Worpdress doesn’t create table in database?
  77. Form and database, plugin development
  78. How to filter get_adjacent_post()?
  79. Associating special meaning with user id 0
  80. Developing a plugin, ran it through P3 Profiler, shows up slow, but I don’t know why
  81. What method should I use to store my plugin data (multi level menus with options on each item)
  82. How to add additional field in a table row after creating a table?
  83. WordPress plugin tables become corrupt
  84. Post data in wp-admin to external database
  85. Is it possible to make WordPress as a RESTful app?
  86. How can I get a plugin to hook ‘dbdelta_queries’ — a filter used during version update?
  87. Running one-off cron jobs when WP_DISABLE_CRON is true: can I hit /wp-cron.php?
  88. oneOf two possible objects in WP REST API?
  89. How to create a database table in WordPress using PHP
  90. Leveraging Core Functionality in Icon Upload Plugin [closed]
  91. Can I log the searches that are returning 404 in the DB?
  92. WordPress database error: [Table ‘bitnami_wordpress.questions’ doesn’t exist]
  93. Making a user platform reachable by a qr code on a pin-back-button [closed]
  94. multiple record insert creating many duplicate records
  95. Custom Plugin Breaks Other Plugin Functions
  96. Is there a way to use MySQL JSON functions in meta queries?
  97. Custom database table entry edit page
  98. Update Cache on Save Instead of Clearing It?
  99. Images stored from external API not loading
  100. Is there a way to force plugins to use Flyway migrations for database changes?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)