$wpdb->insert – inserting multiple rows

I guess the problem is a pretty simple one. You didn’t show the whole code, but I guess the problem is that you’re saving the insertion for some unknown reason as string into a var named $stat. Everytime you fill the var with a new query you’re overwriting your var. You should use $stat .= $wpdb->insert( ...etc... ) instead. to append to your string. Don’t forget to set the var to an empty string before the loop, so you can append: $stat="".

Another – imo better way – would be to use an array. Reason: You can easier debug the code. And pls read the comment i/t code.

$stats = array();
for( $i = 0; $i <= $urlCount; $i++ ) 
{
    $stats[] = array(
        'POSTID' => $post->ID,
        // are you really retrieving **ALL** your urls as "url1", "url2", etc. 
        // via some $_POST-ed form?
        'URL' =>   filter_var(
            $_POST["url{$i}"], 
            FILTER_VALIDATE_URL, 
            FILTER_FLAG_SCHEME_REQUIRED
        )
    );
}

foreach ( $stats as $stat )
    $wpdb->insert( 'WP_URLS', $stat );

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. $wpdb->last_error doesn’t show the query on error
  7. Saving custom form data into database
  8. Get data from database table by post_id to get data from second database table
  9. wp-content/db.php : where is this file?
  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 prepared with search term
  13. What does wp_update_post() do that the $wpdb class does not?
  14. wpdb-> not adding prefix to custom table
  15. Get random row from custom table
  16. store custom WP table names in a global variable
  17. I want to update my postcontent with $wpdb
  18. How to save html and text in the database?
  19. XOR functionality for meta_query
  20. $wpdb->replace / Replace or update primary key
  21. Create an array with a string key from wpdb->get_results
  22. Replicating the WP_Query ‘s’ param with $wpdb
  23. get the number of queries made on a page(inside my plugin)
  24. Doing a loop with multiple DBs simultaneoulsy
  25. How can I migrate mysql_fetch_array to $wbpdb?
  26. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  27. Modify the structure of data returned by $wpdb
  28. WPDB If primary key already exists, add +1 to integer field
  29. Foreach loop using $wpdb not results from rows
  30. How to get an array of user roles with or without a specific capability?
  31. Programmatically Creating Page using $wpdb and getting 404 error
  32. Return XML of Post Metadata
  33. Problem in inserting row to custom database table
  34. sanitize_text_field and apostrophe problem
  35. $wpdb->prepare with ON DUPLICATE KEY UPDATE
  36. 301 Redirect Code
  37. Code only works every other time its run
  38. wpdb updating record in wordpress with json adds extra array elements
  39. How to display a specific category using a custom Query?
  40. Can’t pass variable in wordpress wpdb->get_results
  41. $wpdb->insert inserting only f character in custom table
  42. AWS Bitnami WordPress – SELECT command denied to user
  43. WPDB Placeholders and second argument for prepared statements
  44. PHP Fatal Error – $wpdb a non-object?
  45. Why does wpdb->update delete other meta?
  46. Increment integer field in database when WHERE needs to be dynamic [closed]
  47. Getting variable from Database
  48. How do I count columns on a custom WPDB query?
  49. Custom $wpdb returns unexpected time based results
  50. Trouble inserting string containing quotations marks with wpdb in save_post hook
  51. $wpdb->prepare was called incorrectly when inserting multiple records
  52. How to protect a script execution on WordPress?
  53. how to connect to another database in wordpress
  54. wpdb query not working
  55. Where can I see MySQL hostname and port for wp-config.php
  56. Save sql file after doing insert wpdb
  57. Perform a function when a user clicks register button
  58. $wpdb->get_results not returning an array
  59. Can I use wpdb to insert query results into a post?
  60. WPDB Query Question with Category Only
  61. $wpdb->prepare error after WordPress update [duplicate]
  62. $wpdb->num_rows doesn’t work
  63. $wpdb->get_var next var?
  64. How can I change my meta_query to SQL wpdb query?
  65. How do I modify this wpdb query to include posts that have a post_status of publish and draft?
  66. Can’t find out why dbDelta dosen’t create my table
  67. How to pass an input value into wpdb->Prepare
  68. Check if Value Exists in Database, adding row details to variables and echoing result
  69. wpdb replace returning 1 where delete and insert is expected
  70. wpdb discards duplicate column names?
  71. update_post_meta not working in template_redirect action
  72. Get records from Formidable Table using $wpdb->get_col
  73. WPDB SQL query SELECT from category
  74. How to work with constraints on wordpress user metadata?
  75. How to Update multiple rows using $wpdb->update
  76. Unable to use $wpdb in WordPress
  77. How to display specific data from custom database table in WordPress
  78. Get 3 row ID’s via ARRAY_A
  79. Getting record from three wpdb tables
  80. Why is an empty result an error? ( $wpdb->get_row )
  81. get_row returns empty when data exists
  82. wpdb->update update the entire table instead of one row
  83. wpdb insert working in one function, but not another
  84. How to set up prepared query using IN statement
  85. Save customizer default values to DB on theme activation
  86. Plugin with connection to database – Single function
  87. Alter the main search query to search posts by coauthor user name
  88. WPDB Prepared Delete
  89. wpdb->update error
  90. wpdb select from using array as search parameters
  91. wpdb Cannot Access Associative Array Data in a Count Query
  92. Using $wpdb to update current post
  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. Table wont load into WPDB
  100. $wpdb->prepare UPDATE process not work in functions.php

Leave a Comment

error code: 523