Enumeration Contact form using database table’s numbe of rows [closed]

I found the answer. This works fine. 

function row_count_shortcode() {
global $wpdb;
$user_count = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->daviddgl_wp1.SaveContactForm7_6" )+1;
return "17ICLAA".sprintf('%03d',$user_count);
}
add_shortcode( 'row_count', 'row_count_shortcode' );

Related Posts:

  1. Audio or playlist shortcode condition according to the amount of files on attachment page
  2. do_shortcode based on _thumbnail_id
  3. How to find the output of contact form 7 shortcode? [closed]
  4. How to set Contact Form 7 fields default value using shortcode attribute? [closed]
  5. WordPress Shortcode show database row
  6. Add the last viewed post title to a contactform with shortcode [closed]
  7. Code is providing a row of data but not formatting it as table
  8. How to reload the shortcode content when the database is changing
  9. call other shortcode in the email contactform7 send [closed]
  10. contact form 7 :create shortcode usable in email message [closed]
  11. contact form 7 database short codes [closed]
  12. Create shortcode for each form field in contact form 7
  13. my form does not insert any data in the database
  14. How to display total user count by specific role in WordPress as statistics?
  15. Shortcode select another dbbase
  16. Contact Form 7 shortcode is commented out, but I receive spam emails from it
  17. Working with Contact Form 7 pipes
  18. Use Shortcode on Custom Page
  19. WordPress Database Error using $wpdb->get_results()
  20. I’ve broken the short code for Contact Form 7!
  21. Using wp_editor in shortcode
  22. Why are you using add_action for shortcode?
  23. How to get URL param to shortcode?
  24. How to display the names of users from a specific group with a shortcode?
  25. shortcode for logo image
  26. Stop strip_shortcodes() stripping content inside shortcodes
  27. Using audio shortcode for .mp3 URLs with a query string
  28. Get multiple shortcode attribute values
  29. How do i link gallery thumbnails to different url’s using the wp native gallery?
  30. How to display some selected user meta data on a specific page with a shortcode?
  31. Gallery shortcode menu order fix no longer working on WordPress 4.0
  32. How to save a shortcode in a Gutenberg custom block?
  33. Shortcode displays only default attribute values
  34. Can a shortcode function this way
  35. Dynamically create shortcodes using add_shortcode and a callback
  36. Passing attributes to shortcode dynamically
  37. Stop parsing shortcodes
  38. Gist shortcode is not working
  39. Display post metadata: “title, category, author, date” with shortcode
  40. shortcode javascript not working on custom template file inside theme folder
  41. Check if post has gallery images/media
  42. Stop auto formatting in shortcodes
  43. Get URL Param Plugin and Inserting Result in Widget Code
  44. How to add class or id to shortcode HTML elements?
  45. Change WordPress Shortcode added in to post
  46. Changing the title tag from a shortcode
  47. WordPress wpautop/shortcode generating invalid markup
  48. Detecting embeded video format
  49. While loop shortcode problem
  50. Remove ‘p’ tags around shortcodes and ‘img’
  51. How to prevent shortcode preview from breaking in tinymce editor?
  52. Execute Closing Shortcode After the_content
  53. Forcing max-width for image captions
  54. WordPress Short code with additional parameter
  55. Creating a short code with php inside
  56. Is it possible to modify the header with a content shortcode?
  57. Custom shortcode breaks my page
  58. Custom shortcode is causing a WSOD
  59. this simple shortcode doesn’t generate Collapse as supposed
  60. Shortcode outputting at top of content
  61. Will a shortcode placed inside a paragraph tag still be valid?
  62. Get attributes of nested shortcodes
  63. How to create a shortcode to let the user add the ID of a YouTube video?
  64. How do I define and register a shortcode function in a namespaced functions.php file?
  65. How to add shortcode to html widget
  66. Implementing a URL Shortener
  67. WordPress User ID as Shortcode
  68. Add div on EMED Tag
  69. Clean way of using ob_start() and ob_end_clean() in wordpress
  70. Theme Convert PHP code to shortcode
  71. find shortcode inside content of post
  72. WordPress Short code for List style
  73. Processing a login/register form before shortcodes are rendered?
  74. Adding a cover image to video shortcode
  75. Insert First Image into post (full-width)
  76. why the posts queried from sql is more than those showed on the page?
  77. Show content if user left comment / non-logged visitors?
  78. How to insert current user ID/entry ID into a shortcode?
  79. Need help with creating a simple shortcode
  80. Using a WP shortcode in Homepage
  81. i want to show a modal when user lands on home page very first time
  82. create shortcode that changes url endpoint
  83. Logout user if click on a custom page link
  84. Shortcode Attribute not defined
  85. Removing text + shortcode from all posts
  86. Is Post-Author-Id shortocde
  87. Load next post by ID on a single page
  88. User content database [closed]
  89. Add catagory attribute to custom shortcode
  90. Class variables in shortcodes
  91. Defining the output of a WordPress Att
  92. Remove width and height attributes from [gallery] output
  93. Custom WP theme not showing shortcodes
  94. Shortcode for sectors
  95. How to not show shortcode contents if cart is empty?
  96. Help with Shortcode Functionality
  97. Shortcode Site include in a other
  98. Shortcode with foreach
  99. How do write this type shortcode? [closed]
  100. Why does my shortcode query not working with search term