WordPress.org

Ready to get started?Download WordPress

Forums

Data Not Inserted into Database upon submitting form (2 posts)

  1. Travis Tubbs
    Member
    Posted 6 years ago #

    Well, I figured I'd give things a shot and attempt to create my first WordPress plugin. I've been successful in creating the Admin menus, creating a new Database table (when it doesn't exist), and reading data from the Database.

    I am now attempting to add data to the database, but it seems no matter how many times I submit the data, nothing is added to the database.

    Here is the code that I'm using:

    $sql = "INSERT INTO " . $wpdb->prefix . "table_name
                      (table_row_name, table_row_2, table_row_3) VALUES (
                      '" . $wpdb->escape($_POST['table_row_name']) . "',
                      '" . $wpdb->escape($_POST['table_row_2']) . "',
                      '" . $wpdb->escape($_POST['table_row_3']) . "'
                      )";
            $wpdb->query($sql);

    As stated in the WordPress documentation about working with databases, I have included the following lines of code beforehand:

    include_once(ABSPATH . 'wp-config.php');
    include_once(ABSPATH . 'wp-includes/wp-db.php');

    I am definitely missing something here, but I am lost as to what. I've ensured that the SQL statement is complete with the values that are passed from the form (echoed the $sql variable on the "results" page). I don't get any errors, but am completely lost as to what is going on. Any pointers?

  2. mostfamiliar
    Member
    Posted 5 years ago #

    Did you ever find a solution? I'm experiencing a similar problem.

Topic Closed

This topic has been closed to new replies.

About this Topic