Save custom post type to external database

I have been searching for an answer to this question for over a month now – i do not think wordpress is very good for any site that has a secure external DB or for anyone who does not want to store customer data in the main wordpress database, which is strange as that seems like a highly valued function.

At any rate i came across this code during my research that may help you – it is a global variable for a external DB… according to the author it is usable in the same way as $wpdb global variable is used.

If you want the author’s full blurb on it go here https://bavotasan.com/2011/access-another-database-in-wordpress/

The code is:
$newdb = new wpdb($DB_USER, $DB_PASSWORD, $DB_NAME, $DB_HOST);
$newdb->show_errors();

Hopefully it is of some use to you…

Related Posts:

  1. wpdb custom post_type problem
  2. Does this archive template part look like its making too many calls to the db?
  3. How to store additional data that is related to core data
  4. Shared Custom post type between WP network sites
  5. Should I use custom post types or a custom database tables for plugin development?
  6. Custom Post Types, or completely custom?
  7. Right way of storing large number of custom post fields
  8. How to use custom database tables for custom post types?
  9. Custom Post Type or Custom Tables
  10. Create Pages from Database
  11. Use Custom Database with Custom Post Type
  12. Custom Search | Wrong output & question
  13. Save or update data when custom post published
  14. Custom post type Vs. data in own table
  15. $wpdb returns no results with SELECT query on custom post type, works on default post type
  16. Save custom post type in different table
  17. Using posts and postmeta table to store custom Address Book Plugin data
  18. using custom taxonomies on non wp table?
  19. Developing WordPress on Kubernetes
  20. Recommended custom post type structure for TV Schedule site?
  21. How to best delete orphan wp_postmeta
  22. Where to store custom tagging data associated with a custom post type
  23. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  24. WP All Import – Using Xpath to set a select value
  25. Insert post metadata for all posts in CPT at once if metadata no existent
  26. Sorting custom post type columns with external data and without meta values
  27. Convert simple SQL Query to WordPress query
  28. Add meta value to custom post type on publish
  29. convert custom query to wp_query
  30. using $wpdb to get custom post type with term
  31. How to use custom taxonomies to reference complex relationships?
  32. Create a clone from one WordPress site to another in a few minutes
  33. Database to page routing API?
  34. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  35. How to change wp prefix for custom post type only?
  36. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  37. Add update or delete database records using custom post type
  38. How to import a custom MySQL DB table into a WordPress custom post type
  39. WP_Query orderby and tax_query
  40. How to organise this data within WordPress
  41. Organize WordPress site, so it can maintain with huge database
  42. Show data from one Custom Post Type in another Custom Post Type
  43. Specifying meta field’s column type in Database using add_post_meta
  44. Replace dynamically content in a custom database table when a custom post is created
  45. Running a song lyrics site on WordPress
  46. Save and user submitted data from a form and display them in the wp backend
  47. Should I use custom taxonomies or not?
  48. $wpdb->get_col and ORDER BY?
  49. Designing a custom post type with a minimum number of meta fields
  50. Allow front end users to add data to a custom post type
  51. WordPress hook which triggers on post import
  52. Update all published posts at once
  53. Entity to store contact form entries?
  54. Ideas to connect external database table to wordpress posts as custom field source
  55. Database alteration: users who voted
  56. WordPress as a frontend website for iOS app [closed]
  57. foreach loop inside the loop creating duplicates in output
  58. delete duplicate meta_value with same post_id
  59. custom post type: own database table structure and custom “new-post” interface
  60. Import External XML
  61. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  62. How do you make relational post types in WordPress? [duplicate]
  63. Having a repeating custom field in admin custom post type, what I’d go better with, for DB’s sake? ACF repeater or query a different post type?
  64. See if the email exists or not
  65. How to select custom posts thats are tagged with multiple taxonomies using wpdb
  66. Right way to store a large set of similar information on website? [duplicate]
  67. Filter in Custom post type to find the parent post
  68. Custom post type and custom taxonomy key lenght & query performance
  69. How select query is generated in a Custom Post Type?
  70. dynamic vue widget inside custom post
  71. Create 3 Levels of relations with WordPress
  72. Update 2 wordpress tables at once
  73. Event Manager: Events Deleted are still in DB as published but hidden in admin
  74. Changing an item in drop down after 5 latest posts per taxonomy
  75. How to use costum database table for custom post type
  76. Populate custom post type/custom fields from an external database
  77. Limit Number of Custom Post Type Dashboard
  78. Automatically convert standard posts with custom fields to custom post types
  79. In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
  80. Custom Post save causes 500 error
  81. How to enable the user to add value through the admin panel?
  82. Custom Post Types and Posts are mixed
  83. Pulling Content from Existing Database
  84. Query Distinct Taxonomies of Custom Post Type
  85. Displaying database table in backend of wordpress
  86. custom post type for custom talbe
  87. Adapting plugin for custom post type?
  88. Retrieve post data via WPDB class
  89. Check in function on custom page
  90. Most efficient way of deleting post
  91. Problem with menu categories doubling up when updating database?
  92. Saving custom metabox data with a twist
  93. Inserting into WP DB
  94. Save number of Facebook likes to database
  95. Switched server & domain name, now custom post types won’t save
  96. custom post types containing a collection of items
  97. Why WordPress does not Use Separate Table for Post Types (When Registring)?
  98. Remote database access on another wordpress site’s custom post type
  99. What would be the optimal CPT / Taxonomy design for the following entities structure
  100. Should I save user cookie consent in a custom post type or make a custom database table?