Saving custom form data into database

OK, so here is how you should to this proper way…

In your template file you put your form:

<form id="myForm" name="myform" action="<?php echo esc_attr( admin_url('admin-post.php') ); ?>" method="POST">
    <input type="hidden" name="action" value="save_my_custom_form" />
    <select id="brandSel" size="1">
        <option selected="selected" value="">-- Select Brand --</option>
        <option>Abba</option>
        <option>AG Hair</option>
    </select>

    <input type="submit" value="submit" />
</form>

And in functions.php file (or in your plugin) you’ll have to add admin_post_{action}:

function my_save_custom_form() {
    global $wpdb;

    $inputValue = $_POST['newValue'];
    $wpdb->insert(
        'catalog',
        array( 'brandSel' => $inputValue ),
        array( '%s' ),
    );

    wp_redirect( site_url("https://wordpress.stackexchange.com/") ); // <-- here goes address of site that user should be redirected after submitting that form
    die;
}

add_action( 'admin_post_nopriv_save_my_custom_form', 'my_save_custom_form' );
add_action( 'admin_post_save_my_custom_form', 'my_save_custom_form' );

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. what is the way to see the currently executing query in wordpress?
  3. Fetch array with $wpdb
  4. $wpdb->insert() and Values for Datetime Columns?
  5. $wpdb->last_error doesn’t show the query on error
  6. Theoretical Multi-Server WordPress Setup with Shared Users
  7. Speed optimization of $wpdb->get_results
  8. $wpdb is get_results escaped
  9. WordPress insert NOW() in TIMESTAMP column returns all zeros
  10. $wpdb prepare issue with mysql DATE_FORMAT
  11. How-To: wpdb Insert Record With Date
  12. How to pass NULL in where array for $wpdb->update
  13. Get random row from custom table
  14. store custom WP table names in a global variable
  15. wpdb prepare: passing varible number of fields as second argument
  16. I am not understandinhg $wpdb->prepare correctly
  17. Wpdb query for comment meta for current post
  18. How to update records using $wpdb?
  19. How to Modify this $wpdb query to accept an array of post statuses
  20. Using WPDB class
  21. WPDB Update using Conditional Arrays
  22. $wpdb->get_results returns empty but value exists
  23. WP Sql query multiple where clause
  24. Problem displaying inserted form
  25. What is _transient_random_seed for?
  26. Get published posts and pages?
  27. wpdb get_results() and prepare when to use prepare?
  28. Syntax for $wpdb->prepare when searching in two columns
  29. Foreach loop using $wpdb not results from rows
  30. $wpdb->insert is running multiple times on page load, but only called once
  31. How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?
  32. How to Instantiate wpdb Object in New File
  33. How do you build a wpdb query dynamically?
  34. Would this WPDB setup result in potential race conditions?
  35. How to update a row in a table in WordPress
  36. What’s the proper way to add users to my site in order to test things?
  37. WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
  38. Optimizing WordPress Queries – Removing Group By ID
  39. External DB Connection [closed]
  40. Codex: Database Description: meaning of Cardinality
  41. Code only works every other time its run
  42. Can’t pass variable in wordpress wpdb->get_results
  43. WordPress db prepare
  44. How do I count columns on a custom WPDB query?
  45. how to get db values without using an loop with wpdb->get_results()
  46. Custom SQL query ORDER BY term_order
  47. Trouble inserting string containing quotations marks with wpdb in save_post hook
  48. How to run wp_insert_post() & wpdb on the background?
  49. Trying to get variable from WP table and toggle its value
  50. Set MySQL variables in WPDB
  51. get_results query with accent
  52. How to prepare an array of values with $wpdb
  53. Is querying wpdb directly and skipping actions provided by WP’s core “wp_update_post” a good idea?
  54. $wpdb->insert() doesnt work anymore
  55. $wpdb query outputs php code instead of executing it
  56. wpdb query not working
  57. Where can I see MySQL hostname and port for wp-config.php
  58. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  59. Using “->” in a page to exceute $wpdb query gives error
  60. Exclude specific terms from all queries using posts_where or something similar
  61. $wpdb->get_results not returning an array
  62. query a newly created table using $wpdb
  63. Get all sticky posts from one user through user ID
  64. WPDB Query Question with Category Only
  65. wpdb result arrray inside an array
  66. $wpdb->num_rows doesn’t work
  67. How can I change my meta_query to SQL wpdb query?
  68. How capturate wpdb exceptions?
  69. Limit left join
  70. “This message was added in version X” showing a later version than current one
  71. Get records from Formidable Table using $wpdb->get_col
  72. Prepare WPDB with meta key and meta value
  73. How to get row value from wpdb
  74. I am using wpdb but it not working perfectly.but if I dont use form data its work
  75. wont add form details to database or send me mail
  76. Create a stored procedure on plugin activation
  77. Missing argument 2 for wpdb::prepare() [duplicate]
  78. wpdb->update update the entire table instead of one row
  79. WPDP related functions look to work but they don’t
  80. Custom database query to validate data
  81. Save customizer default values to DB on theme activation
  82. Plugin with connection to database – Single function
  83. Alter the main search query to search posts by coauthor user name
  84. Protect custom form from SQL injection
  85. why nl2br() is adding an extra ?
  86. How to add more custom fields in user meta table simultaneously
  87. wpdb->update error
  88. get unserialized array without using get_option()
  89. SQL Query to select post title & post ID from a particular category
  90. Create Table Failed Column Date DateType
  91. Using $wpdb to update current post
  92. Checking if meta_value exists for any user
  93. Jeditable Plugin working as it should – scope issue?
  94. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  95. DBDelta: “table doesn’t exist” for a table that was just created
  96. query using wpdb in wordpress gets me no result
  97. How do I change the datetime format from ( ‘y-m-d’ ) to ( ‘d m y’ ) [closed]
  98. Get count of rows based if column exists in two different tables
  99. Table wont load into WPDB
  100. WPDB prepare – like % – placeholders?

Leave a Comment

tech