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:
- Audio or playlist shortcode condition according to the amount of files on attachment page
- do_shortcode based on _thumbnail_id
- How to find the output of contact form 7 shortcode? [closed]
- How to set Contact Form 7 fields default value using shortcode attribute? [closed]
- WordPress Shortcode show database row
- Add the last viewed post title to a contactform with shortcode [closed]
- Code is providing a row of data but not formatting it as table
- How to reload the shortcode content when the database is changing
- call other shortcode in the email contactform7 send [closed]
- contact form 7 :create shortcode usable in email message [closed]
- contact form 7 database short codes [closed]
- Create shortcode for each form field in contact form 7
- my form does not insert any data in the database
- How to display total user count by specific role in WordPress as statistics?
- Shortcode select another dbbase
- Contact Form 7 shortcode is commented out, but I receive spam emails from it
- Working with Contact Form 7 pipes
- Use Shortcode on Custom Page
- WordPress Database Error using $wpdb->get_results()
- I’ve broken the short code for Contact Form 7!
- convert it into short code & explan how? [closed]
- Enqueue Scripts / Styles when shortcode is present
- Conditionally Loading JavaScript/CSS for Shortcodes
- What does extract( shortcode_atts( array( do?
- How do I escape a ‘]’ in a short code?
- Pass boolean value in shortcode
- Show shortcode without executing it
- How to use other shortcodes inside Contact form 7- forms? [closed]
- Shortcode always displaying at the top of the page
- Redirect function inside a Shortcode
- How to create a shortcode with 1 parameter (atts)
- how to show the syntax of a shortcode
- Custom shortcode being executed when saving page in wp-admin
- Change appearance of shortcode text inside editor
- current_shortcode() – detect currently used shortcode
- shortcodes output before content [duplicate]
- WordPress plugin shortcode not working
- Count & Display Database Queries
- How to add stylesheets only to pages with specific shortcode?
- Why might a plugin’s ‘do_shortcode’ not work in an AJAX request?
- Using get_option() in JavaScript
- Shortcode empty attribute
- How does a shortcode work?
- Shortcode outputs at the top of the_content
- the_excerpt and shortcodes
- Using wp_editor in shortcode
- Remove wpautop from shortcode content / remove whitespace in buffering
- Get current post id witout passing in shortcode
- Why are you using add_action for shortcode?
- How to get URL param to shortcode?
- How to add multiple buttons to TinyMCE?
- Check if post/page has gallery?
- Get first video from the post (both embed and video shortcodes)
- Get shortcode name from within it’s callback function? [duplicate]
- Wordspress add into my javascripts
- Making a Shortcode [NEXT] and [PREVIOUS] to place into specific posts for post navigation
- How do I create a Shortcode that returns text if domain is .com, not .co.uk
- Using preg_replace to separate gallery from the_content?
- Remove specific shortcode from get_the_content()
- How to display the site name in a WordPress page, or post
- Hide/show content starting in the middle of a paragraph
- Combining shortcode and get_template_part
- How can I put a wp_redirect into a shortcode?
- Escaping quotes from shortcode attributes
- Run visual composer code in php page
- short code output too early
- Shortcode in shortcode: How to append variable?
- Remove wptexturize from a shortcode?
- How can i put an array as variable in shortcode_atts?
- Autoembeds don’t work with paragraphs
- Table of Contents with a shortcode
- Create custom [sourcecode] shortcode, the right way?
- TED talks shortcode not working
- Allowing shortcodes inside attributes
- What is the best way to enable nested shortcodes?
- Tinymce – How to hook before or after live shortcodes rendering?
- How to customize a shortcode using the customizer
- Native “playlist” shortcode random playing… How?
- How to Output HTML tags in do_shortcode?
- List of all inbuilt WordPress shortcodes
- Nested Shortcode Detection
- Shortcode output always showing at top of page
- Organizing shortcodes. How to display all of them and their attributes?
- How to detect if a Shortcode is being called on a page?
- How to get current page title inside a page itself in a shortcode and in page content
- how to have the gallery shortcode output one single UL list instead of several DL?
- Implement If-ElseIf-Else-EndIf with short codes
- Short code to display a loop
- Using shortcode in Post title
- using html as shortcode attribute
- shortcode outputs first before the page content [duplicate]
- How to add ‘class’ attribute into shortcode [audio]?
- Make shortcode work with nested double quotes
- Get all posts containing a shortcode
- How to display the names of users from a specific group with a shortcode?
- WordPress adds br in between my shortcode
- Stray closing paragraph tag when using shortcodes
- How to display html in a shortcode
- Can I strip HTML tags in the “Compare Revisions” screen?
- Custom form, shortcode, and submit handler