Storing The Data Collected by Ninja Forms into Another (custom) Database [closed]

The data is stored in the wp_posts and wp_postmeta tables. You can see all the field values by doing this:

SELECT website from 

(SELECT m1.meta_value as user_firstname, m2.meta_value as user_lastname, m3.meta_value as website
 FROM dev_posts
 join dev_postmeta m1 on m1.post_id = ID and m1.meta_key = '_field_1'
 join dev_postmeta m2 on m2.post_id = ID and m2.meta_key = '_field_2'
 join dev_postmeta m3 on m3.post_id = ID and m3.meta_key = '_field_3'
 where post_type="nf_sub") as v1

WHERE user_firstname="John" AND user_lastname="Allen"

The “x” in “_field_x” is the field ID in Ninja Forms.

source: https://www.experts-exchange.com/questions/28910247/Where-is-Ninja-form-data-stored-in-the-WordPress-database.html

Once you get the content, you can store it in any table.

Related Posts:

  1. Simple form that saves to database
  2. Retrieving a Value from a wp-database
  3. WP plugins for building a database?
  4. Storing Form data in a different database
  5. Include plugin form in the home page
  6. Create user assessment and use results in sql query
  7. Creating fields in the database
  8. Allow users to enter and edit data in one-to-many configuration
  9. Form with response button after on table after submission
  10. Can’t save formdata in DB
  11. WP Plugins – Use includes to display page content
  12. Multiple instance of data in plugin custom database table on plugin activation
  13. WordPress and a secondary database?
  14. WordPress plugin creating database in localhost but not on real host
  15. Why this function not working for install database on plugin activation
  16. How to fetch form data and show it to my page?
  17. Plugin to create forms using HTML [closed]
  18. Submit custom form from post content and execute in plugin
  19. How to allow user to select User ID in Formidable Pro form? [closed]
  20. plugin code is pulling information from database in one instance and not in other. What is wrong?
  21. Char limit on custom blog-post form? [closed]
  22. “Master” WordPress Multisite – Database Sync
  23. Better ads plugin has 500.000 entries in wp_postmeta
  24. How to create multiple database tables on plugin activation?
  25. Can I create a table on my DB without creating a plugin?
  26. WordPress : Explain Plugins & Theme string value in database
  27. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  28. Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
  29. Creating a CSV with PHP inside the plugin directory
  30. AJAX fileupload – TypeError: not a function ajaxSubmit()
  31. Plugins in WP_Options but not Active
  32. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  33. Is there a way to embed a Google Docs form in a page without using plugins?
  34. Detailed form plugin, with ability to export to excel etc. OR edit PDF live? [closed]
  35. easy steps to make front end form without plugin
  36. How do i edit the plugin files in DataBase via phpMyAdmin?
  37. WordPress as a data-store?
  38. How to insert and call new data in wordpress website database through a plugin
  39. Gathering and logging data from a plugin: how to do it without race conditions?
  40. Form that generates an ID for the customer
  41. How to pass the API key to the client from the database? [closed]
  42. WPDB: Update table
  43. Issue running db create table query from static method
  44. Problem of encoding characters (apostrophes) in my posts publications
  45. Separate database for a wordpress plugin
  46. Is there a rule for wordpress plugins developers to not do any database changes upon update?
  47. Submit Form data to another page via Ajax (WordPress Way)
  48. How to keep variable `$post` to using in another file
  49. dbDelta not adding additional columns in plugin database update
  50. Editing a text file from plugin menu
  51. Updating options into the wp database performance
  52. Ajax Plugin Not Echoing Response
  53. Making my plugin create a page?
  54. Plugin that will output submitted form data for user? [closed]
  55. How to handle forms from sidebar widgets – Processing $_POST variables using get_field_name()
  56. Ajax save data to database on document ready, no data being saved
  57. Add some fileds to the wp_posts table
  58. How to edit a published post?
  59. How do I add the same contact form to multiple wordpress sites and capture the response in one place or database?
  60. Best/Correct way to add an option to a category
  61. Plugin has added weird data in wp_options, set to autoload
  62. Always get creating a new table with foreign key
  63. coding a WordPress AJAX Form using PHP to check if User is Logged Out and Show error
  64. How to do database for download stats?
  65. What is the WordPress approach to custom data?
  66. How to create plugin/ page that reads from database
  67. How retreive saved data from gravity forms in my template?
  68. DB Query not working in Plugin
  69. Assign all Post in Wp to a specific Category
  70. Creating a form and displaying entry data as a table
  71. External wpdb connections in different plugins on single page
  72. How can ι create my own (custom) WordPress table/list?
  73. Gravity Forms returns to odd position
  74. WordPress Multi-Step Product Search
  75. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  76. Where do plugin variables live in the db?
  77. Sell access to form [closed]
  78. WordPress plugin boilerplate table create
  79. File Uploader – Upload without adding to Media Library
  80. How to relate 3 wordpress components with each other (Create database relationships)
  81. Creating a search form and displaying results
  82. Custom form not showing in correct place on page
  83. add_meta_box creating default form field types
  84. WordPress plugin: efficient way to store large data
  85. How can I store data from custom fields to custom tables?
  86. Form Plugin for Api Requests which is used via Shortcode
  87. How to redirect to a page after the form is submitted
  88. Call another page in forms
  89. Echo out element to another page.
  90. Plugin: connect to external database without showing password
  91. How to access the WordPress DB from a plugin file
  92. How to Use the Filter “sidebar_login_widget_form_args”
  93. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  94. Select Form Element Not Saving from Plugin Options
  95. Is it save to replace with in WordPress search form
  96. Contact Form 7 Plugin emails not being received by some accounts
  97. Contact Form 7 “non-selectable” options in a drop down [closed]
  98. Is this plugin safe to run?
  99. Integrating Custom Database with WordPress
  100. Using AJAX to run SQL statement and populate dropdown
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)