$wpdb->insert is not working

It sounds like it would be simpler to go back and fix your initial try: saving an option to a WP-native table rather than creating your own. Try update_option – it creates an option if it doesn’t exist, or updates if it does. This will save you a lot of code and headaches in the future.

Related Posts:

  1. Get error messages when $wpdb->insert() returns false?
  2. Detecting errors generated by $wpdb->get_results()
  3. Does dbDelta delete columns as well?
  4. wpdb update add current timestamp not working
  5. How to fetch Data in WordPress using MySQLi or $wpdb
  6. WordPress Unit Testing – Cannot Create Tables
  7. How to define composite keys with dbDelta()
  8. Does wpdb add considerable overhead on queries with large result sets?
  9. Why does $wpdb return strings for mysql integer values?
  10. $wpdb->prepare() warning in WordPress 3.5
  11. Inserting data into custom tables
  12. Hook into $wpdb
  13. Display data from a non wordpress database on a page template
  14. How might I retrieve a featured post image from an external WP site and display it as a link back?
  15. Inserting Post Meta From SQL
  16. Why does dbDelta() not catch MysqlErrors?
  17. Connecting to external oracle database
  18. Can’t save ajax value to database
  19. What causes the “max_user_connections” warning on WordPress frontend?
  20. $wpdb variable throw this error Call to a member function get_results() on a non-object in
  21. Updating all rows of table with $wpdb
  22. Safe way to find last inserted id in a table?
  23. Is $wpdb->prepare escaping to much? How to use it properly?
  24. Database slowdown after update to 3.4.1
  25. Remove database entries where post_date > expiration date
  26. Get data from database using $WPDB
  27. How to use a different database to list and manage comments in the backend
  28. Getting all the users who have author privilege
  29. Multiple postmeta with same name for one post in wp_postmeta table
  30. WP Database Table to CSV file
  31. wpdb_prepare with multiple or condition
  32. In what part of the WordPress core does the users table and usermeta table get joined?
  33. Modify Database in Multi-Site wp_usermeta table
  34. Multiple wp_options tables to share content across installs
  35. Advanced SELECT query with condtional statements
  36. $wpdb doesn’t like to store arrays
  37. WordPress choose wrong database
  38. Redirecting to old domain after migration website
  39. Create table from array with prepare
  40. Does WordPress $wpdb functions wait when table is locked?
  41. How Can I Put Meta_Compare in the Database-Query?
  42. WordPress running SQL query to update database from form
  43. I’m not able to get access to $wpdb [duplicate]
  44. WPDB SQL query with prepare() returning variable, not db value
  45. $wpdb error (Call to a member function insert() on a non-object)
  46. Is it important to have integers inserted using %d rather than %s?
  47. Problem in using wpdb
  48. How to fetch records from database WordPress
  49. Best practice to limit results in get_row()?
  50. Best practice to import user base (subscribers) from one website to another?
  51. AJAX wp-mysql running too slow
  52. Clear Terms from Taxonomy for Specific Post IDs?
  53. Trouble running $wpdb->query() with last_insert_id
  54. Connecting to a different database
  55. Using $wpdb | checking entered email against existing emails in db
  56. Query Column of Specific ID from Database Table
  57. How to delete a particular row in a database table
  58. How to create more than one new wpdb object?
  59. Optimizing function that automatically creates internal links based on post title string
  60. Update multiple rows in one query
  61. How to connect and insert data in database of wordpress?
  62. Get results from wordpress data custom table
  63. Should I use an additional column in the DB?
  64. Outputting query results
  65. access JSON results from wordpress database with wpdb
  66. Getting value from database table depending on field value
  67. add_post_meta — not working
  68. Select From wpdb – Author/User Directory page
  69. wpdb->insert not inserting first variable
  70. How do I have a user upload a blog post and then retrieve that to display in a card on the site?
  71. $wpdb->insert not inserting all rows
  72. wpdb Insert unknown post data dynamic foreach loop
  73. How do I get database rows from a custom table using wpdb?
  74. SELECT rows between two datetimes when the range is dynamic [closed]
  75. Insert NULL value using prepare()
  76. Help with $wpdb on custom code
  77. “BS_” rows in postmeta table
  78. $wpdb->insert duplicating rows
  79. How to rerieve comments and their replies from DB
  80. Can I use a wpdb object to connect to a non-WordPress Oracle database [duplicate]
  81. Where is the HTML-handler part in the wpdb class?
  82. Help posting values to DB on submit using $wpdb->query
  83. WordPress Database Query works in phpMyAdmin but not in the code
  84. 2 $wpdb queries causing error Table ‘wp_postmeta’ is specified twice, both as a target for ‘UPDATE’
  85. Correct and secure way to access a custom SQL database in a custom PHP template file
  86. Using $wpdb to insert data into a table
  87. How To connect to the same WordPress database with different database user
  88. Accessing content from third party as native posts in WordPress
  89. Call to a member function insert()
  90. I have include wp-config, should I add global $wpdb also?
  91. Processing a lot of $wpdb isn’t insert all the data
  92. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  93. Pulling values from a sepcific row in table
  94. Creating Tables in WordPress Database
  95. Inserting into data into external DB using WPDB
  96. Insert Extra fields added in the front end registration form to DB
  97. How to use remote db tables in current config? [duplicate]
  98. $wpdb->insert not working for last select option
  99. $wpdb->prepare returns empty array
  100. Uploading to WordPress Database