$wpdb->insert() doesnt work anymore

examine below example and figure out what is wrong with your code. 

 global $wpdb;
if(isset($_POST['submit']))
{
    $table_name = $wpdb->prefix.'employee';
    $wpdb->insert(
                    $table_name,
                    array(
                            'first_name'=>$fname,
                            'last_name'=>$lname),
                    array( '%s','%s' )
                 );

use global $wpdb;

global $wpdb;
$table_name = $wpdb->prefix.'rdp_banners';
$wpdb->insert(
            $table_name,
            array(
                'banner_id'     => $banner_id,  
                'rdp_banner'    => $rdp_banner,     
                'banner_type'   => $banner_type,            
                'customer_id'   => $customer_id,            
                'status'        => $status,             
                'company_name'  => $company_name,
                'picture'       => $picture,
                'register_date' => $register_date,
                'start_date'    => $start_date,
                'end_date'      => $end_date,   
                'price'         => $price,
                'banner_link'   => $banner_link),
      array( '%d', '%d', '%d',  '%d',   '%d',   '%s',   '%s', '%s', '%s',   '%s',   '%s',   '%s')
     );

Related Posts:

  1. using $wpdb to insert a form into a post
  2. Programmatically Creating Page using $wpdb and getting 404 error
  3. How to run wp_insert_post() & wpdb on the background?
  4. duplicate entries in database while using save_post or wp_insert_post
  5. adding a log row log table, when the draft post publish
  6. $wpdb->get_row() only returns a single row?
  7. what is the way to see the currently executing query in wordpress?
  8. Fetch array with $wpdb
  9. $wpdb->insert() and Values for Datetime Columns?
  10. $wpdb->last_error doesn’t show the query on error
  11. Theoretical Multi-Server WordPress Setup with Shared Users
  12. Change post status based on meta value
  13. Delete/replace img tags in post content for auto published posts [closed]
  14. What does wp_update_post() do that the $wpdb class does not?
  15. wpdb-> not adding prefix to custom table
  16. WordPress insert NOW() in TIMESTAMP column returns all zeros
  17. $wpdb prepare issue with mysql DATE_FORMAT
  18. How-To: wpdb Insert Record With Date
  19. How to pass NULL in where array for $wpdb->update
  20. Get random row from custom table
  21. store custom WP table names in a global variable
  22. I am not understandinhg $wpdb->prepare correctly
  23. How to save html and text in the database?
  24. XOR functionality for meta_query
  25. Using WPDB class
  26. How can I migrate mysql_fetch_array to $wbpdb?
  27. $wpdb->get_results returns empty but value exists
  28. WP Sql query multiple where clause
  29. Problem displaying inserted form
  30. What is _transient_random_seed for?
  31. wpdb get_results() and prepare when to use prepare?
  32. Foreach loop using $wpdb not results from rows
  33. Return XML of Post Metadata
  34. How to get a value-only flat array from $wpdb->get_results when selecting a single column, without foreach()?
  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. Problem in inserting row to custom database table
  38. sanitize_text_field and apostrophe problem
  39. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  40. Code only works every other time its run
  41. wpdb updating record in wordpress with json adds extra array elements
  42. How to display a specific category using a custom Query?
  43. Can’t pass variable in wordpress wpdb->get_results
  44. AWS Bitnami WordPress – SELECT command denied to user
  45. WPDB Placeholders and second argument for prepared statements
  46. PHP Fatal Error – $wpdb a non-object?
  47. How do I count columns on a custom WPDB query?
  48. Custom SQL query ORDER BY term_order
  49. Trouble inserting string containing quotations marks with wpdb in save_post hook
  50. $wpdb->prepare was called incorrectly when inserting multiple records
  51. How to protect a script execution on WordPress?
  52. Trying to get variable from WP table and toggle its value
  53. Set MySQL variables in WPDB
  54. how to connect to another database in wordpress
  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. Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
  61. Exclude specific terms from all queries using posts_where or something similar
  62. $wpdb->get_results not returning an array
  63. Insert two row in wordpress database
  64. query a newly created table using $wpdb
  65. Get all sticky posts from one user through user ID
  66. WPDB Query Question with Category Only
  67. wpdb result arrray inside an array
  68. $wpdb->num_rows doesn’t work
  69. How can I change my meta_query to SQL wpdb query?
  70. How capturate wpdb exceptions?
  71. Limit left join
  72. “This message was added in version X” showing a later version than current one
  73. Get records from Formidable Table using $wpdb->get_col
  74. Prepare WPDB with meta key and meta value
  75. How to get row value from wpdb
  76. I am using wpdb but it not working perfectly.but if I dont use form data its work
  77. wont add form details to database or send me mail
  78. Create a stored procedure on plugin activation
  79. Call to a member function insert()
  80. Missing argument 2 for wpdb::prepare() [duplicate]
  81. wpdb->update update the entire table instead of one row
  82. WPDP related functions look to work but they don’t
  83. Custom database query to validate data
  84. Save customizer default values to DB on theme activation
  85. Plugin with connection to database – Single function
  86. Alter the main search query to search posts by coauthor user name
  87. Protect custom form from SQL injection
  88. why nl2br() is adding an extra ?
  89. How to add more custom fields in user meta table simultaneously
  90. wpdb->update error
  91. get unserialized array without using get_option()
  92. SQL Query to select post title & post ID from a particular category
  93. Create Table Failed Column Date DateType
  94. Using $wpdb to update current post
  95. Checking if meta_value exists for any user
  96. Can you create a new wpdb that connects to an SQL (not MYSQL) database? [duplicate]
  97. DBDelta: “table doesn’t exist” for a table that was just created
  98. query using wpdb in wordpress gets me no result
  99. $wpdb The query does not contain the correct number of placeholders
  100. $wpdb:insert, more arguements in $format array than in $data