<div>
The data is stored in the wp_posts and wp_postmeta tables. You can see all the field values by doing this:
<pre><code class="code-10 nolinks" id="code-20-41398938-1"><span>SELECT website from </span>
<span></span>
<span>(SELECT m1.meta_value as user_firstname, m2.meta_value as user_lastname, m3.meta_value as website</span>
<span> FROM dev_posts</span>
<span> join dev_postmeta m1 on m1.post_id = ID and m1.meta_key = '_field_1'</span>
<span> join dev_postmeta m2 on m2.post_id = ID and m2.meta_key = '_field_2'</span>
<span> join dev_postmeta m3 on m3.post_id = ID and m3.meta_key = '_field_3'</span>
<span> where post_type = 'nf_sub') as v1</span>
<span></span>
<span>WHERE user_firstname = 'John' AND user_lastname = 'Allen'</span>
</code></pre>
<br />
The &quot;x&quot; in &quot;_field_x&quot; is the field ID in Ninja Forms.
</div>


<div>
Thank you William for laying that out! &nbsp;Did that come from any Ninja documentation you could point me to? &nbsp;<br />
<br />
Ninja makes it so easy to create a form but then they seem to go silent on how to get back the data you put into the form. &nbsp;Do they expect us to write code like you've provided, or is there a simpler interface somewhere?<br />
<br />
Thanks again for your help.<br />
Steve
</div>


<div>
<div class="content wysiwyg-content">
I have a Ninja form with textbox fields for user_firstname, user_lastname, &nbsp;and website. When someone submits the form, where does the data go in the WordPress database? &nbsp;Suppose, for example, I want to know the website for a given user_firstname and user_lastname. So I want something like:<br />
<br />
sql = &quot;SELECT 'website' from ??? WHERE user_firstname = 'John' AND user_lastname = 'Allen'&quot;;<br />
<br />
What is the table I need to access?<br />
<br />
Thanks.
</div>
</div>


I have a Ninja form with textbox fields for user_firstname, user_lastname,  and website. When someone submits the form, where does the data go in the WordPress database?  Suppose, for example, I want to know the website for a given user_firstname and user_lastname. So I want something like:

sql = "SELECT 'website' from ??? WHERE user_firstname = 'John' AND user_lastname = 'Allen'";

What is the table I need to access?

Thanks.

Where is Ninja form data stored in the WordPress database?

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.