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. Where are wordpress custom types stored?
  7. Delete all posts of a custom post type—efficiently
  8. Custom Post Types, or completely custom?
  9. Get terms that contain posts that in turn belong to other terms?
  10. Custom Post Type with Input fields to seperate table on database.
  11. Right way of storing large number of custom post fields
  12. How to use custom database tables for custom post types?
  13. Custom Post Type or Custom Tables
  14. Custom post type or just use custom fields
  15. Create Pages from Database
  16. How to import a custom MySQL DB table into a WordPress custom post type
  17. Get terms that contain posts that in turn belong to other terms?
  18. WP_Query orderby and tax_query
  19. Importing Data from a Non-WordPress database, into WP
  20. How to organise this data within WordPress
  21. Organize WordPress site, so it can maintain with huge database
  22. $post not working working in AJAX plugin with custom post type
  23. Show data from one Custom Post Type in another Custom Post Type
  24. Specifying meta field’s column type in Database using add_post_meta
  25. Replace dynamically content in a custom database table when a custom post is created
  26. Running a song lyrics site on WordPress
  27. Save and user submitted data from a form and display them in the wp backend
  28. WPDB for post count on post
  29. Dump custom post type database
  30. Should I use custom taxonomies or not?
  31. $wpdb->get_col and ORDER BY?
  32. Designing a custom post type with a minimum number of meta fields
  33. Allow front end users to add data to a custom post type
  34. WordPress hook which triggers on post import
  35. Update all published posts at once
  36. Entity to store contact form entries?
  37. Ideas to connect external database table to wordpress posts as custom field source
  38. Database alteration: users who voted
  39. WordPress as a frontend website for iOS app [closed]
  40. foreach loop inside the loop creating duplicates in output
  41. Using custom post types WordPress network
  42. delete duplicate meta_value with same post_id
  43. custom post type: own database table structure and custom “new-post” interface
  44. $wpdb is queried but results don’t show
  45. Import External XML
  46. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  47. How do you make relational post types in WordPress? [duplicate]
  48. 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?
  49. See if the email exists or not
  50. How to select custom posts thats are tagged with multiple taxonomies using wpdb
  51. Right way to store a large set of similar information on website? [duplicate]
  52. when looping through custom post data not appearing
  53. Filter in Custom post type to find the parent post
  54. custom post types, custom fields and normalization
  55. Custom post type and custom taxonomy key lenght & query performance
  56. How select query is generated in a Custom Post Type?
  57. dynamic vue widget inside custom post
  58. Create 3 Levels of relations with WordPress
  59. Exporting Post type from one theme and importing it to another theme
  60. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  61. custom data model – link and populate from admin backend
  62. Confused about where to store my data
  63. Update 2 wordpress tables at once
  64. Event Manager: Events Deleted are still in DB as published but hidden in admin
  65. Changing an item in drop down after 5 latest posts per taxonomy
  66. How to use costum database table for custom post type
  67. Populate custom post type/custom fields from an external database
  68. Limit Number of Custom Post Type Dashboard
  69. Automatically convert standard posts with custom fields to custom post types
  70. In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?
  71. CPT or Custom Table for Repository of Serial Numbers
  72. Custom Post save causes 500 error
  73. How to enable the user to add value through the admin panel?
  74. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  75. Custom Post Types and Posts are mixed
  76. Pulling Content from Existing Database
  77. Query Distinct Taxonomies of Custom Post Type
  78. Displaying database table in backend of wordpress
  79. custom post type for custom talbe
  80. Adapting plugin for custom post type?
  81. Retrieve post data via WPDB class
  82. $wpdb returns no results with SELECT query on custom post type, works on default post type
  83. Check in function on custom page
  84. Most efficient way of deleting post
  85. Problem with menu categories doubling up when updating database?
  86. Saving custom metabox data with a twist
  87. Inserting into WP DB
  88. Save number of Facebook likes to database
  89. WordPress and Unity high scores table
  90. Checking for published posts in a certain post type
  91. Trying to display posts by authors in with specific user meta
  92. Switched server & domain name, now custom post types won’t save
  93. custom post types containing a collection of items
  94. WordPress Admin Page Slow. Customer Post Type is the slowest
  95. Create a WordPress Database query to find users who purchased specific product through WooCommerce [closed]
  96. Why WordPress does not Use Separate Table for Post Types (When Registring)?
  97. Remote database access on another wordpress site’s custom post type
  98. What would be the optimal CPT / Taxonomy design for the following entities structure
  99. Should I save user cookie consent in a custom post type or make a custom database table?
  100. Optimizing storage of Post Meta Entries
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)