How to get number of Affected rows from wordpress dbDelta() function

dbDelta() is for creating new tables or change the structure (not the data) of existing ones.

You need $wpdb->insert( $tablename, $zips ); when you want to insert data. Hence the name. 🙂

And this method returns the number of affected rows, exactly as you need it. If it returns false, look at $wpdb->last_error to see what exactly went wrong.

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. Searching users with WP_List_Table plugin
  3. How to write one comment and publish on every post using database or plugin?
  4. Display data on Word Press site posts and pages from mysql table
  5. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  6. WpDataTables – View Image Directory
  7. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  8. pagination on data fetched using SQL query
  9. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  10. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  11. How can I fetch data from another website to my wordpress website with mysql database
  12. speed up pagination for huge database
  13. Way to send multiple values for column to MySQL?
  14. How to display results from a data table with an encrypted user id?
  15. Check against server time to display SQL entries – Radio Station DJ Rotator Plugin
  16. add_action for publish_post doesn’t work
  17. WordPress Cache delete on plugin uninstall
  18. need to find duplicated meta value in custom filed and view the posts that have the same value
  19. Getting current user data with MySQL statement
  20. How to get the custom field value using SQL query
  21. WP Function does not trigger on Webhook API Call
  22. Cant create table on plugin activation
  23. How to get database connection details without longing to cpanel in WordPress?
  24. Moving a few select DB tables to a new WP instance
  25. How much PHP and MySQL or MariaDB knowledge should I know to start writing WordPress themes and plug-ins and whatever else a beginner can edit?
  26. get/show Last ID
  27. MySql Query for WordPress
  28. how to search through plugin in wordpress cimy-user-extra-fields?
  29. PHP Creating a formula from mysql db values and db stored math operator
  30. Split Million WordPress Post’s Into Multiple Database Server
  31. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  32. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  33. Should all plugins be encapsulated in a Class?
  34. PHP code on Visual Composer Plugin
  35. Bad Request (Invalid Hostname) on working server, database problem
  36. Thumb rating for wordpress – top user
  37. Errors while using ajax from external wordpress page
  38. Setting up widgets in wordpress with a unique ID for the after_title argument
  39. post expire after x days
  40. allow arabic letters when register new account
  41. How to get all events from ‘All in one Events calender’ plugin in JSON format?
  42. cURL error 60: SSL certificate problem: unable to get local issuer certificate
  43. Make specific products accessible only to a user role in WooCommerce
  44. How to determine what is generating large amount of database queries?
  45. Get post by ASC from custome field DATE picker
  46. Self deactivate plugins after an action occurs
  47. wp_redirect() not working in Insert PHP plugin in WordPress
  48. How to periodically scrape and cache strings from remote txt files. – My First Plugin
  49. How to sanitize uploaded file filename from a plugin?
  50. Using WP Category Lists Plugin to Dynamically Display Category (PHP)
  51. Using a custom plugin to capture input data via Ajax and PHP
  52. Set and access global variable
  53. How to get the element ID from new menu list that added with add_filter()?
  54. Preg Match All doesn’t Allow echo first character for WordPress Taxonomy Tags
  55. Replacing a plugin function with a custom renamed function doesn’t work
  56. How to output CMB2 select options from repeated groups select elements?
  57. How to deal with WordPress and Pocket API to automate content curation on my hosted wordpress blog? [closed]
  58. WP All Import – Execute Imports
  59. Enabling plugin failed because MySQL user do not have CREATE permissions
  60. Create Gallery using Custom Post Type and add sum gallery as sub gallery of Main Gallery
  61. Notify comment author upon reply
  62. WordPress get_avatar function not correct working
  63. add_action into another add_action not working
  64. Speeding SQL queries for a large database?
  65. How to show the number of website visitors in my theme
  66. Add User Role: Pre-saved in User-Meta [SOLVED]
  67. How to make a dynamic css class whose name changes every visit to confuse scraper
  68. How to create plugin/ page that reads from database
  69. Shortcode not working – quotes seems strange
  70. Using custom fields for image alt and title
  71. How to display registered customer list as dropdown in WooCommerce checkout?
  72. Error When Trying To Login [closed]
  73. Echo out element to another page.
  74. JOIN and SUM different statement results (Mailster Database)
  75. i need to make custom cron_schedule with custom interval time as a parameter into a custom payment gateway plugin wordpress
  76. Redirect unloggedin users
  77. Show prices with tax Inclusive in Minicart widget
  78. Custom fields not showing up in the user info (PaidMembershipsPro)
  79. Problem with checked box on wp car manager plugin
  80. Performing CRUD operations on front end in wordpress
  81. issue concerning ob_end_flush functions.php
  82. In a plugin, How to update a json file using ajax
  83. my hook or my function wont run in the cronjob
  84. How to echo a PHP Code After the Content
  85. Woocommerce list variations that are added already to cart in Single Product
  86. Show custom taxonomy in theme
  87. Passing ajax variable to more than one wordpress plugin function
  88. Social sharing plugin directing to blank page after post sharing
  89. using href when creating wordpress plugin calls empty page instead of php file
  90. Create Database Tables on Plugin Activation hook
  91. Media Playlist Plugin
  92. Saving custom form fields
  93. How to add php stylesheet to admin section instead of admin_head hook
  94. Replace Dash (-) and Underscore ( _ ) with Space
  95. How to add homepage Widget?
  96. WordPress create permalink structure for custom post type with userid
  97. wp_handle_upload – specified file failed upload test
  98. How to change all the urls of the WordPress site?
  99. How do I remove the filter from the orders and add custom status in Dokan?
  100. How to make a Template page to show the information of different things Shop and Product page?