WordPress.org

Ready to get started?Download WordPress

Forums

Insert data to the database from a form (5 posts)

  1. ri14cardo60
    Member
    Posted 3 years 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 3 years 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 3 years 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 3 years 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 3 years 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.

About this Topic