Ajax save data to database on document ready, no data being saved

The way you’re using $wpdb->prepare doesn’t help anything. You have to properly prepare the values and then add them like with sprintf as %s or %d.

Oh, and I don’t believe “working with WP ajax for over a year.”. In this case you would also know about the nopriv hooks for public usage 🙂

add_action( 'wp_ajax_nopriv_action_stats', ...

Related Posts:

  1. Ajax with jQuery UI dialog not working
  2. When to use action hooks and plugins
  3. WordPress Integration with Google Groups
  4. What’s the preferred method of writing AJAX-enabled plugins?
  5. How do I show data from gravity forms in my template? [closed]
  6. How to load wp_editor via AJAX
  7. Delete tables from database when deleting plugin
  8. Is it bad practice to create own table for a plugin?
  9. How to Add an Index to Plugin Database table
  10. How can I delete orphan keys in WordPress database tables?
  11. Is there a plugin that will override the “Error establishing a database connection” message? [closed]
  12. How to delete all records from or empty a custom database table?
  13. What are these entries in the database? Looks similar to JSON
  14. WordPress sharding: which multi-DB plugin to use?
  15. Help with 4.6. Attachment response object in JSON API plugin
  16. Creating two database tables via plugin
  17. How to properly insert data into custom table via plugin
  18. How can I make an Ajax login form work with FORCE_SSL_ADMIN enabled?
  19. How does WordPress handle MySQL row lock errors?
  20. How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
  21. Help making my pagination plugin better
  22. admin-ajax returning 400 error when request is made with Fetch API
  23. How to empty wordpress custom post Database table
  24. insert data in database table from plugin with WP3.1
  25. Simple form that saves to database
  26. How to run Two WordPress blogs with different themes and with single database and same content
  27. $wpdb->get_results leaking memory
  28. Plugins or Tutorials for displaying data from SQL-db on WP-page? [closed]
  29. Insert query inserts 2 entries, should insert 1
  30. Using Vagrant for customizable WordPress Multi-sites [closed]
  31. Is it a bad practice to go directly to the mysql database while developing a plugin?
  32. Updating WordPress – the best approach (updating wp core, plugins and db)
  33. How can I pass a variable to wp_ajax action?
  34. How do I check what plugins are enabled via the database?
  35. Loading shortcode with ajax
  36. How to store ACF custom fields data in a custom table
  37. How to pass JavaScript variable to PHP in wordpress widget?
  38. Add image to post from external URL
  39. Can I explicitly specify ENGINE=InnoDB in WordPress?
  40. How can a Firebase user registration and login be integrated into a WordPress site?
  41. Bad Request (Invalid Hostname) on working server, database problem
  42. Plugin Not Working, But Only On GoDaddy Hosted site
  43. Create custom column in post table in wordpress
  44. Custom database or Custom Post Types?
  45. How to add a sub menu with AJAX?
  46. AJAX Call Via Vanilla JavaScript In WordPress Plugin Development
  47. Custom plugin giving: wp-admin/admin-ajax.php 400 (Bad Request)
  48. jQuery AJAX call not executing in Plugin
  49. Create Proper WordPress Ajax Request in JavaScript, NOT jQuery
  50. Execute a function using ajax
  51. Problem running Ajax in WordPress
  52. Ajax Load More and Masonry: is it possible to load admin-ajax.php in the front end?
  53. Custom database table for plugin not creating on activation
  54. WordPress plugin DB upgrade
  55. How to save Clicks of a download link button while it doesn’t matter if we refresh the page or again login/logout
  56. ‘Lazy loading’ list of posts with pagination
  57. How to update widget_text in the wp_options table
  58. Errors while using ajax from external wordpress page
  59. I can’t access wordpress functions from an ajax php call
  60. Built in admin ajax hooks?
  61. How to include admin-ajax when loading external javascript
  62. Ajax call doesn’t work in frontend but it’s working in backend (when I’m logged in)
  63. Get the last post ID
  64. delete_user_meta Delete one value out of array
  65. Add agenda items and notifications
  66. How to use wp-ajax in wp-cron
  67. Calling shortcode in wp_localize_script strips result
  68. Why is my ajax call refreshing the page?
  69. How to count number of records found in a database table?
  70. Should I global $wpdb outside of any of my plugin’s functions scope?
  71. prefix table and plugins
  72. Taking WordPress table prefixes into account
  73. Changing BIGINT to INT
  74. What’s the point of using WordPress’s built in admin-ajax.php?
  75. Admin-ajax.php is dying “0” without processing function
  76. WordPress register_activation_hook table creation not working
  77. How to add Edit | Delete button on rows?
  78. how to use ajax to display from database and load more in wordpress plugin
  79. The plugin generated x characters of unexpected output, $wpdb not defined
  80. How to remove an Ajax action
  81. how to show database content in wordpress post
  82. What is the easiest way to implement cascading database upgrade for my plugin?
  83. clean wp_options table unused rows
  84. How to create popup same as wordpress popup feature
  85. Only execute jQuery function(on document ready) on the page has shortcode from plugin [duplicate]
  86. Get Plugin Information from Multiple Sites Externally
  87. Shortcode in AJAX popup
  88. How to edit/delete single row items in a table on my own menu page
  89. Storing Email Account Passwords for SMTP Mailing for a WordPress Plugin
  90. How to add pagination to wpbakery grid?
  91. How can I process xml file on upload?
  92. Remove obsolete plugins artifacts from database tables
  93. How can I reuse the WordPress search form for a custom plugin / widget?
  94. AJAX image upload with a upload progress bar using media_handle_upload
  95. jQuery Plugin to use WordPress functions in AJAX request
  96. ajax front-end increment views on click
  97. If I delete plugins via FTP are settings kept in DB?
  98. greatest() function returns undefined property
  99. $wpdb working with ajax but showing ajax error instead of success
  100. Get total number of comment of the posts written by an author
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)