How to write one comment and publish on every post using database or plugin?

It would be safer to use [wp_insert_comment()][1] rather than manually through MySQL. WP often inserts data in multiple tables – using its core functions helps ensure that all of the data gets added in all of the right tables.

I’d suggest creating a query to pull all published posts. Then, set up a foreach loop that calls wp_insert_comment() on every post, thus inserting the comment on each one.

Related Posts:

  1. How to properly insert data into custom table via plugin
  2. How to display results from a data table with an encrypted user id?
  3. add_action for publish_post doesn’t work
  4. Cant create table on plugin activation
  5. Moving a few select DB tables to a new WP instance
  6. How does WordPress handle MySQL row lock errors?
  7. Simple form that saves to database
  8. Searching users with WP_List_Table plugin
  9. How to store ACF custom fields data in a custom table
  10. Can I explicitly specify ENGINE=InnoDB in WordPress?
  11. Bad Request (Invalid Hostname) on working server, database problem
  12. Changing BIGINT to INT
  13. How to edit/delete single row items in a table on my own menu page
  14. greatest() function returns undefined property
  15. Get total number of comment of the posts written by an author
  16. Make id column as AUTO INCREMENT on plugin activation
  17. How to get number of Affected rows from wordpress dbDelta() function
  18. How to determine what is generating large amount of database queries?
  19. Display data on Word Press site posts and pages from mysql table
  20. How to access data in wordpress database externally using php
  21. How to simultaneously access the same MySQL database in the main column and sidebar of WordPress?
  22. Help With MySQL to WPDB Query Conversion
  23. WpDataTables – View Image Directory
  24. How can I perform high-level database merging for WordPress within continues delivery?
  25. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  26. WordPress Backend HA (Automatic failover)
  27. Automatic switch to backup database on fail
  28. Migrating to WordPress Recipe Plugin and Some SQL Issues
  29. Multiple instance of data in plugin custom database table on plugin activation
  30. Better ads plugin has 500.000 entries in wp_postmeta
  31. Creating a CSV with PHP inside the plugin directory
  32. pagination on data fetched using SQL query
  33. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  34. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  35. Issue running db create table query from static method
  36. dbDelta not adding additional columns in plugin database update
  37. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  38. Always get creating a new table with foreign key
  39. How to do database for download stats?
  40. How to create plugin/ page that reads from database
  41. How can I fetch data from another website to my wordpress website with mysql database
  42. DB Query not working in Plugin
  43. External wpdb connections in different plugins on single page
  44. speed up pagination for huge database
  45. Comment “like” problem – “users who like this” avatar linking to current user profile instead of “liker’s” profile
  46. Way to send multiple values for column to MySQL?
  47. WordPress plugin: efficient way to store large data
  48. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  49. Is this plugin safe to run?
  50. Integrating Custom Database with WordPress
  51. Check against server time to display SQL entries – Radio Station DJ Rotator Plugin
  52. WordPress Cache delete on plugin uninstall
  53. Getting URL GET parameter with Code snippets and storing it in database?
  54. need to find duplicated meta value in custom filed and view the posts that have the same value
  55. Getting current user data with MySQL statement
  56. How to get the custom field value using SQL query
  57. What database state changes happen after a post is manually “updated” with no changes?
  58. WP Function does not trigger on Webhook API Call
  59. How to get database connection details without longing to cpanel in WordPress?
  60. Performing CRUD operations on front end in wordpress
  61. How to use WordPress header function and footer function and not load word press database
  62. Get Shortcode output to database for static post_content
  63. Store GravityForm data in phpmyadmin (mysql)
  64. WordPress database problem wp_posts, primary key
  65. 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?
  66. How can I store user preferences in WordPress and retreive them later?
  67. get/show Last ID
  68. HyperDB failover Delay
  69. Write mysql credentials in plugin
  70. How to save information related to post in database?
  71. MySql Query for WordPress
  72. how to search through plugin in wordpress cimy-user-extra-fields?
  73. How can I delete the options from DB when the plugin is deleted?
  74. PHP Creating a formula from mysql db values and db stored math operator
  75. Split Million WordPress Post’s Into Multiple Database Server
  76. Getting 504 Gateway Timeout Error on AWS Server! [closed]
  77. WordPress issue – data is not showing in wp-admin, but when searching through database, all the data is there
  78. plugin doesn’t retrieve data from database
  79. if plugin is active? check if plugin is enabled or not?
  80. Making plugin unique to not conflict with plugins with the same name
  81. Default Plugin Settings Not Writing to Database
  82. Custom Post Type Plugin not loading category template and loading 404 instead
  83. WP plugins for building a database?
  84. How to insert HTML/JavaScript form into WordPress page? [closed]
  85. How to check if a taxonomy not exists in a plugin
  86. wordpress add_action() issue in ajax call
  87. Send email with list of active plugins upon activation/deactivation
  88. Strange admin-ajax / CSS / $_SESSION issue
  89. How to create admin setting for this small plugin
  90. $wpdb->delete not working for me
  91. Post source link plugin – small modification
  92. How to securely controlling data without keeping it in postmeta?
  93. Block plugin update possibilities (but not by hiding notifications)
  94. Soflyy WP All Import Custom File Download Issue
  95. Displaying friend’s posts only
  96. MySQL database migration to WordPress
  97. Option value not getting updated until page refresh in WordPress
  98. Fatal error: Uncaught Error: Call to a member function fetch_array() on bool
  99. Use inline callable for hooks and filters
  100. Error in using ‘admin_enqueue_scripts’ action through a class