Unable to insert data into using custom plugin

In the table, all columns are set with NOT NULL consent.
that means they can not be empty at all and considered as required fields.

But in the insert query, You are saving only 3 records. 

$wpdb->insert( 
    $table_name, 
    array( 
        'holiday_name' => $holiday_name, 
        'date' => $date, 
        'state' => $state_form_select, 
    ) 
);

That’s the issue.

Either insert all required values in the table or add proper consent.

Related Posts:

  1. $wpdb->get_row() only returns a single row?
  2. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  3. How to use $wpdb to delete in a custom table
  4. Matching database content types to PHP types
  5. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  6. Saving custom form data into database
  7. Get data from database table by post_id to get data from second database table
  8. wp-content/db.php : where is this file?
  9. Delete/replace img tags in post content for auto published posts [closed]
  10. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  11. $wpdb->get_results() returns good result only in first foreach iteration
  12. $wpdb->insert – inserting multiple rows
  13. $wpdb prepared with search term
  14. WPDB->insert with special characters
  15. Is there a (better) way to access $wpdb results?
  16. $wpdb->prepare not working with update table prefix
  17. How to use prepare to query with variables
  18. Use $wpdb in wordpress theme files
  19. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  20. Problem in creating table through plugin code
  21. I want to update my postcontent with $wpdb
  22. How to save html and text in the database?
  23. XOR functionality for meta_query
  24. $wpdb->replace / Replace or update primary key
  25. Create an array with a string key from wpdb->get_results
  26. $wpdb – do you have to use foreach even if there will always only be one result?
  27. Replicating the WP_Query ‘s’ param with $wpdb
  28. Need help writing a $wpdb query
  29. get the number of queries made on a page(inside my plugin)
  30. Doing a loop with multiple DBs simultaneoulsy
  31. $wpdb->insert query changes to SHOW COLUMNS query Output
  32. How can I migrate mysql_fetch_array to $wbpdb?
  33. Fixing wpdb->get_results and wpdb->prepare?
  34. How does the WXR file differ from the WPDB?
  35. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  36. Modify the structure of data returned by $wpdb
  37. WPDB If primary key already exists, add +1 to integer field
  38. How to get an array of user roles with or without a specific capability?
  39. What is wrong with this wpdb update?
  40. Programmatically Creating Page using $wpdb and getting 404 error
  41. Return XML of Post Metadata
  42. Constructing a dynamic WPDB query with multiple LIKEs
  43. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  44. 301 Redirect Code
  45. Counting posts with argument without retrieving the posts
  46. $wpdb->insert inserting only f character in custom table
  47. AWS Bitnami WordPress – SELECT command denied to user
  48. WPDB Placeholders and second argument for prepared statements
  49. Why does wpdb->update delete other meta?
  50. Increment integer field in database when WHERE needs to be dynamic [closed]
  51. Getting variable from Database
  52. Create new database through static page code
  53. Custom $wpdb returns unexpected time based results
  54. $wpdb->prepare was called incorrectly when inserting multiple records
  55. How to protect a script execution on WordPress?
  56. WordPress “wpdb->update” – Append Text Value
  57. Need help converting get_user_meta [keys] into own array
  58. Can’t call WPDB inside RSS template
  59. Save sql file after doing insert wpdb
  60. Can I use wpdb to insert query results into a post?
  61. $wpdb->prepare error after WordPress update [duplicate]
  62. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  63. Query and get meta as object(stdClass) on wp postmeta table?
  64. How do I query a table?
  65. check that the data exists before sending it to wpdb
  66. Can’t find out why dbDelta dosen’t create my table
  67. How to pass an input value into wpdb->Prepare
  68. no result returns when using $wpdb->get_results with where clause
  69. SQL queries to another wordpress site
  70. PHP | left join avg query give me Array()
  71. update not working using wpdb
  72. get_posts() SQL Injection
  73. Check if Value Exists in Database, adding row details to variables and echoing result
  74. og:image functions.php
  75. wpdb replace returning 1 where delete and insert is expected
  76. update_post_meta not working in template_redirect action
  77. How to work with constraints on wordpress user metadata?
  78. $wpdb select returns empty array
  79. Show error messages to a user when database insert fails
  80. How to Update multiple rows using $wpdb->update
  81. Unable to use $wpdb in WordPress
  82. How to display specific data from custom database table in WordPress
  83. Get 3 row ID’s via ARRAY_A
  84. Getting record from three wpdb tables
  85. Missing argument 2 for wpdb::prepare() [duplicate]
  86. Why is an empty result an error? ( $wpdb->get_row )
  87. get_row returns empty when data exists
  88. wpdb insert working in one function, but not another
  89. How to set up prepared query using IN statement
  90. WPDB Prepared Delete
  91. wpdb select from using array as search parameters
  92. wpdb Cannot Access Associative Array Data in a Count Query
  93. Can’t get expected result from a wpdb query
  94. Can’t seem to get set_blog_id working, it just doesn’t reset the blog ID
  95. selecting row using wpdb which contain special symbols
  96. Query Problem in Clustom Plugin
  97. How does $wpdb->get_var work with offset?
  98. query_vars doesn’t return query string (trying to get data from $wpdb)
  99. WPDB prepare – like % – placeholders?
  100. $wpdb->prepare UPDATE process not work in functions.php