WordPress.org

1. ri14cardo60
   Member
   Posted 1 year ago #

   I currently know how to insert data into the database, using PHP MySQL. However, when I try to do it with $wpdb class, I just do not know how to go about it. What I am looking for, is an example code where it shows the form data and then the code necessary to implement that data into the database table. In my particular case I am using a form where I have:

   Name:
   Last Name:
   Address:
   Country:
   Email:
   Comments:

   That data, when is captured, I want to take it to my database table, named clients, using code $wpdb. I would truly appreciate an answer to this, hopefully giving example code.

   Thank you very much,

   Ricardo Cerda de Groote

2. westondeboer
   Member
   Posted 1 year ago #

   from http://codex.wordpress.org/Function_Reference/wpdb_Class#INSERT_rows

   <?php
   // if using a custom function, you need this
   global $wpdb
   
   $lastn = 'Last Name';
   $firstn = "First Name';
   $wpdb->insert( 'clients', array( 'last_name' => $lastn, 'first_name' => $firstn ), array( '%s', '%d' ) )
   
   ?>

3. ri14cardo60
   Member
   Posted 1 year ago #

   Ok, I can see that,

   but how do I connect a form, which will be in one of the pages, where the customer will enter the information ??. I mean, that at what moment does the database know I am inserting from the form.

   If you could, let me know more in detail..

   Thank you very much for your first reply,

   Ricardo

4. richalt2
   Member
   Posted 1 year ago #

   Hi Ricardo, it is quite unfortunate the Codex does not contain a real example of form posting, storing, and retrieving to redisplay the form!!
   I recently posted an outline of such as you wish to do, here:
   http://wordpress.org/support/topic/user-application-editing-form-store-retrieval-from-db

   I think the step you are missing is the form must post to some existing page URL, such as the page itself! Therefore the php code in the page must recognize the incoming post prior to starting to display anything. See if you can make sense of my example.
   You also have to deal with the question of user identity. How do you know who is submitting the form? My example asks for a WordPress login to do this. Hence the data can be retrieved by that specific user in the future, to be updated!

   Rich

5. mrmist
   Forum Janitor
   Posted 1 year ago #

   http://wordpress.org/extend/plugins/contact-form-7/

   If you roll your own form, just be sure to properly sanitize any form posted data before it hits the db.

Topic Closed

This topic has been closed to new replies.