Use Custom Database with Custom Post Type

What I understand is you want to update records/table to another database from wordpress…. well you can achieve this in wordpress 3.1> using

$newwpdb = new wpdb("mysqluser","mysqlpassword","mysqldbname","mysqlhost");

Then using $newwpdb you can access table from new database and perform all operation on it like edit/delete update/insert… same as $wpdb do wordpress….

Hope that helps or you may post your code for more understanding….

Related Posts:

  1. Should I use custom post types or a custom database tables for plugin development?
  2. Where are wordpress custom types stored?
  3. Delete all posts of a custom post type—efficiently
  4. Custom Post Types, or completely custom?
  5. Custom Post Type with Input fields to seperate table on database.
  6. Right way of storing large number of custom post fields
  7. How to use custom database tables for custom post types?
  8. Custom Post Type or Custom Tables
  9. Custom post type or just use custom fields
  10. Create Pages from Database
  11. Custom Search | Wrong output & question
  12. How do I write this SQL statement for Posts written in last 24 hours?
  13. Save or update data when custom post published
  14. Custom post type Vs. data in own table
  15. Save custom post type in different table
  16. Using posts and postmeta table to store custom Address Book Plugin data
  17. How to use custom post type APIs, but use a different db table
  18. Developing WordPress on Kubernetes
  19. Recommended custom post type structure for TV Schedule site?
  20. WordPress post count not showing for custom post type author
  21. Where to store custom tagging data associated with a custom post type
  22. wpdb custom post_type problem
  23. Adding custom tables to WordPress
  24. WP All Import – Using Xpath to set a select value
  25. Sorting custom post type columns with external data and without meta values
  26. How to use custom taxonomies to reference complex relationships?
  27. Create a clone from one WordPress site to another in a few minutes
  28. Database to page routing API?
  29. Store CPT ‘Reviews’ average ratings to a WordPress DB table or to a DB custom table?
  30. How to change wp prefix for custom post type only?
  31. Is it possible to store Custom Post Type data in separate set of tables and still have wp_post class functionality?
  32. Add update or delete database records using custom post type
  33. How to import a custom MySQL DB table into a WordPress custom post type
  34. WP_Query orderby and tax_query
  35. Importing Data from a Non-WordPress database, into WP
  36. How to organise this data within WordPress
  37. Organize WordPress site, so it can maintain with huge database
  38. Save custom post type to external database
  39. Show data from one Custom Post Type in another Custom Post Type
  40. Specifying meta field’s column type in Database using add_post_meta
  41. Replace dynamically content in a custom database table when a custom post is created
  42. Running a song lyrics site on WordPress
  43. Save and user submitted data from a form and display them in the wp backend
  44. Dump custom post type database
  45. Should I use custom taxonomies or not?
  46. Designing a custom post type with a minimum number of meta fields
  47. Allow front end users to add data to a custom post type
  48. WordPress hook which triggers on post import
  49. Update all published posts at once
  50. Entity to store contact form entries?
  51. Ideas to connect external database table to wordpress posts as custom field source
  52. Database alteration: users who voted
  53. WordPress as a frontend website for iOS app [closed]
  54. Using custom post types WordPress network
  55. delete duplicate meta_value with same post_id
  56. custom post type: own database table structure and custom “new-post” interface
  57. Import External XML
  58. Say I have a tech blog, how best would I store technical specs for a phone, if i use custom post types
  59. How do you make relational post types in WordPress? [duplicate]
  60. 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?
  61. Does this archive template part look like its making too many calls to the db?
  62. Right way to store a large set of similar information on website? [duplicate]
  63. when looping through custom post data not appearing
  64. custom post types, custom fields and normalization
  65. Custom post type and custom taxonomy key lenght & query performance
  66. How select query is generated in a Custom Post Type?
  67. dynamic vue widget inside custom post
  68. Create 3 Levels of relations with WordPress
  69. Exporting Post type from one theme and importing it to another theme
  70. How to replicate data storage and querying using WordPress. Custom posts/fields or Custom db tables?
  71. custom data model – link and populate from admin backend
  72. How to store additional data that is related to core data
  73. Confused about where to store my data
  74. Event Manager: Events Deleted are still in DB as published but hidden in admin
  75. Changing an item in drop down after 5 latest posts per taxonomy
  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. CPT or Custom Table for Repository of Serial Numbers
  81. How to enable the user to add value through the admin panel?
  82. Use Tags to Query Associated Multiple Posts and Get The Average Of Custom Field Values
  83. Shared Custom post type between WP network sites
  84. Custom Post Types and Posts are mixed
  85. Pulling Content from Existing Database
  86. Displaying database table in backend of wordpress
  87. custom post type for custom talbe
  88. Check in function on custom page
  89. Most efficient way of deleting post
  90. Problem with menu categories doubling up when updating database?
  91. Inserting into WP DB
  92. Save number of Facebook likes to database
  93. WordPress and Unity high scores table
  94. Checking for published posts in a certain post type
  95. Switched server & domain name, now custom post types won’t save
  96. custom post types containing a collection of items
  97. WordPress Admin Page Slow. Customer Post Type is the slowest
  98. Why WordPress does not Use Separate Table for Post Types (When Registring)?
  99. Remote database access on another wordpress site’s custom post type
  100. What would be the optimal CPT / Taxonomy design for the following entities structure

Leave a Comment