How to build a shortcode which can insert a query string into a DB table

Short codes are for generating HTML for the front end, and no front end functionality should write to the DB because:

  1. With enough traffic it will bring down your site.
  2. If you use caching or CDN for your content it will simply not work at all, if you expect it to work for all page loads.

Related Posts:

  1. How can I get the [video] shortcode to allow query string parameters?
  2. current_shortcode() – detect currently used shortcode
  3. Get shortcode name from within it’s callback function? [duplicate]
  4. Tinymce – How to hook before or after live shortcodes rendering?
  5. How to customize a shortcode using the customizer
  6. Stray closing paragraph tag when using shortcodes
  7. WordPress transients for a shortcode
  8. How to handle valueless attributes in shortcodes?
  9. The result of a shortcode appear BEFORE page content
  10. Getting the count of a shortcode that is nested
  11. How to render complicated shortcodes
  12. Getting attribute value from shortcode
  13. Get shortcode attributes outside shortcode function
  14. My shortcode is not working in Contact Form 7 Message Body
  15. Get Shortcode Attributes
  16. Shortcode doesn’t work with classes
  17. Get shortcode from the content and display it in other place (in sidebar, for example)
  18. sql query in shortcode not working
  19. Video size and border radius using a shortcode
  20. Adding shortcode to the main menu
  21. Inserting PHP inside do_shortcode
  22. wp_editor returns the shortcode and not render the output
  23. Prevent wordpress from rendering shortcode in post
  24. Embedding Instagram via shortcode doesn’t work as advertised in official docs
  25. Executing a shortcode from a “normal” text/hyperlink
  26. Can a shortcode return its own name?
  27. Two different inner shortcode under shortcodes or multiple nesting of inner shortcodes
  28. Use shortcodes in custom metabox using wp_editor?
  29. Can I wrap an unordered list inside a shortcode?
  30. How do I write this shortcode? [closed]
  31. Where to filter Shortcode string prior to execution
  32. WordPress shortcode for a section Template
  33. Media added with shortcodes not “linked” with post
  34. Specifying a single file from multi-file GIST (wordpress.com) [closed]
  35. Is it important to sanitize inputs in a shortcode that will be used in site that only I will post to?
  36. Shortcode default attributes over-riding non-default attributes
  37. Shortcode callback for add_action(‘wp_footer’)
  38. Get page content and execute shortcodes on a page
  39. Using shortcode to display array in array
  40. Add the last viewed post title to a contactform with shortcode [closed]
  41. Make a Shortcode load after Post/Page Content?
  42. Adding JS in header when using wp_enqueue_script in a shortcode
  43. Adding a template part as part of a shortcode
  44. Just display content between shortcode brackets
  45. How can i share codes on my blog?
  46. How to explode single string IF it’s used in shortcode
  47. How to dynamically add wordpress shortcodes
  48. Why does WP display the actual shortcode not the string that’s meant to replace it?
  49. Check if CTP category taxonomy is set in shortcode
  50. Getting Page Content Using Shortcode
  51. shortcode with conditional results if logged in
  52. Can I pass parameters to the add_shortcode() function?
  53. Hijack WordPress Shortcode attribute
  54. Turning variable into a value set in shortcode
  55. How to find specific shortcodes in a post or in a widget and pass them to a variable?
  56. how can I change my font color for Shortcode [closed]
  57. tax query shortcode
  58. Create a function to display HTML/data based on site admins role?
  59. AJAX and do_shortcode
  60. FontAwesome Shortcode isn’t working properly
  61. How can I extract a word from page/post URL using shortcodes
  62. Custom user registration shortcode – redirect header issue
  63. Call Shortcode on wp_footer
  64. Shortcode question…. javascript
  65. How to add a shortcode that creates an adjacent column of text in the content editor?
  66. Adding shortcode of “Random Content” Plugin in the post after the title
  67. Template not loading with get_template_part or locate_template
  68. Check if parent page has child page of certain slug
  69. Variable inside shortcode or shortcode inside shortcode
  70. From a shortcode I want to pass a value to display a different page
  71. Remove figcation from excerpt
  72. Shortcode select another dbbase
  73. How to use code in an editor block?
  74. return an array with a shortcode
  75. Hide password protected dynamic content in templates via shortcode
  76. Shortcode callback not called
  77. Geoip shortcodes in comments
  78. Shortcode not interpreted if parameter set
  79. Can we add a single caption to the gallery shortcode?
  80. Create shortcode to display specific post in relationship current date
  81. Add custom shortcodes to the Welcome Mail
  82. How to handle multiple nested shortcodes with different tags?
  83. Using shortcode to stop post content from displaying
  84. Shortcode Attribute contains clone of all shortcode attributes
  85. How to echo an array returned by a function
  86. Custom Login in Shortcode got error
  87. Creating custom shortcode
  88. What is short code for following?
  89. Created a shortcode, using it twice (but differently) on a page but its just outputting the same one twice
  90. Access Shortcode in ajax code?
  91. Automate post creation in wordpress
  92. Shortcode not working in custom post types
  93. Shortcode or placeholder for theme options page?
  94. How to print [embed] code in wordpress [duplicate]
  95. Shortcode append to the the_content()
  96. IFrame Shortcode plugin – issue
  97. How to call shortcode on button click
  98. How can you alter the name of attributes in a shortcode?
  99. Wrapping a function in html tag and return?
  100. 3 shortcodes 2 won’t render [closed]
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)