- \n
- Install the plugin Shortcodes Actions and Filters<\/a>. This plugin provides a page in your WP administration area that allows you to create shortcodes and provide it with PHP code to execute.<\/li>\n
- Have a look at the FAQ on Accessing Form Data via PHP<\/a> for some information on the API.<\/li>\n<\/ol>\n
To create your own short code with your own code:<\/strong><\/p>\n
- \n
- Go to your WP Admin, Tools<\/strong> -> Shortcodes Actions and Filters<\/strong><\/li>\n
- Add New<\/strong><\/li>\n
- Give it a name it the top box (like “myshortcode”). Name it whatever you want (but no spaces in the name)<\/li>\n
- Check “Active” and “Shortcode”<\/li>\n
- Copy the template code<\/strong> below, and paste into the code section<\/li>\n
- Click Save<\/strong>, just to get it saved<\/li>\n
- Replace “\/\/ Add your stuff here!” with your code (see below)<\/li>\n
- Save<\/strong> it.<\/li>\n
- The best way to test is to create a new draft unpublished post<\/strong>, put your shortcode in there minimally with a form name [myshortcode form=”myform”]<\/strong> then preview the post to see what is displays.<\/li>\n
- Use the shortcode on any pages\/posts you like. Use : show<\/strong><\/a>, hide<\/strong><\/a>, limit<\/strong><\/a>, orderby<\/strong><\/a>, search<\/strong><\/a>, and filter<\/strong><\/a> just as you would for other shortcodes.<\/li>\n<\/ol>\n
<\/p>\n
![\"\"\/](\"http:\/\/cfdbplugin.com\/wp-content\/uploads\/2016\/01\/newshortcode.png\" "\\"myshortcode1\\"")
<\/a><\/p>\nTemplate code<\/strong>: copy this code and paste in this code:<\/p>\n
require_once(ABSPATH . 'wp-content\/plugins\/contact-form-7-to-database-extension\/CFDBFormIterator.php');\r\n$exp = new CFDBFormIterator();\r\n$exp->export($atts['form'], $atts);\r\nwhile ($row = $exp->nextRow()) {\r\n\u00a0\/\/ Add your stuff here!\r\n}<\/pre>\n<\/p>\n
“Add your stuff here!<\/strong>” Delete this line and replace with PHP code that outputs the HTML you want to see for one entry. Use PHP “echo” to output text, reference form values using $row[‘field-name’]<\/strong> where field-name is the name of the field or column. Let’s look at a real user’s example:<\/p>\n
Example<\/strong>: One user was trying to use [cfdb-html] but it didn’t quite give him what he wanted. For one of his fields, “url”, he only wanted it to output an HTML link for that url but only if it was not blank. Unfortunately, [cfdb-html] outputs each form submission exactly the same, so it would make empty links for empty url fields. More generally speaking, [cfdb-html] can’t change its output based on what data is (or is not) in the form submission.<\/p>\n
So he created his own shortcode named ‘bios’ like this:<\/p>\n
require_once(ABSPATH . 'wp-content\/plugins\/contact-form-7-to-database-extension\/CFDBFormIterator.php');\r\n$exp = new CFDBFormIterator();\r\n$exp->export($atts['form'], $atts);\r\nwhile ($row = $exp->nextRow()) {\r\n\u00a0\u00a0\u00a0 echo '<h2>' . $row['name'] . '<\/h2>';\r\n\u00a0\u00a0\u00a0 echo '<p>' . $row['bio'] . '<\/p>';\r\n\u00a0\u00a0\u00a0 if ($row['url'] != null) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 echo '<p><a href=\"' . $row['url'] . '\">Website<\/a><\/p>';\r\n\u00a0\u00a0\u00a0 }\r\n}<\/pre>\nNotice how the code outputs a new paragraph <p> with a link <a> ONLY for only those submissions that have a URL entry.<\/p>\n
Since he named his shortcode ‘bios<\/strong>‘, and his form name was “people<\/strong>“, he can use use the following shortcode on a page or post:<\/p>\n
[bios form=\"people\"]<\/pre>\n
<\/p>\n
Hard-coding ‘form’<\/strong>: But in this case, the shortcode is only for the “people” form since only that form has the ‘name’, ‘bio’ and ‘url’ columns. If he wanted to, he could hard-code the form name in the short code’s PHP code by changing:<\/p>\n
$exp->export($atts['form']<\/span>, $atts);<\/code><\/pre>\nto:<\/p>\n
$exp->export('people'<\/span>, $atts);<\/code><\/pre>\nthen on his page\/post, he could just use:<\/p>\n
[<\/code>bios<\/code><\/code><\/code><\/code>]<\/code><\/pre>\nAnd of course, if he wanted to just show only 10 submissions sorted by name, he could use:<\/p>\n
[<\/code>bios<\/code><\/code>limit=\"10\" orderby=\"name\"<\/code><\/code>]<\/code><\/pre>\n<\/p>\n
Warning about “extract”<\/strong>: OK, so you know PHP, you looked at the code above and said, “I don’t want to use the verbose $row[‘field-name’] syntax, I’m going to the PHP extract function<\/a> to make my fields into variables then I can use actual field names as variables and embed them into double-quoted strings.” Kind of like this:<\/p>\n
require_once(ABSPATH . 'wp-content\/plugins\/contact-form-7-to-database-extension\/CFDBFormIterator.php');\r\n$exp = new CFDBFormIterator();\r\n$exp->export($atts['form'], $atts);\r\nwhile ($row = $exp->nextRow()) {\r\n\u00a0\u00a0\u00a0 extract($row);\r\n\u00a0\u00a0\u00a0 echo \"<h2>$name<\/h2>\";\r\n\u00a0\u00a0\u00a0 echo \"<p>$bio<\/p>\";\r\n\u00a0\u00a0\u00a0 if ($url != null) {\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 echo \"<p><a href='$url'>Website<\/a><\/p>\";\r\n\u00a0\u00a0\u00a0\u00a0} \r\n}<\/pre>\nSeems a bit more concise, right? It is and it works in this example but only because the field names (“name”, “bio”, “url”) can be PHP variable names. When you create a form using Contact Form 7, it’s default\/generated form has fields names have a dash in them (like “your-name”, “text-157”, “textarea-553”). The PHP extract will not work right as coded above because you can’t have a PHP variable with a dash in it ($your-name not allowed!). So you either have to<\/p>\n
- \n
- Use the $row[‘your-name’] to refer to a value (and consequently can’t embed that in a PHP double-quoted string) or<\/li>\n
- You have to ensure all form field names are suitable to be PHP variable names, then you can use ‘extract’ as in the above example.<\/li>\n<\/ol>\n
<\/p>\n
About $atts<\/strong>: the $atts variable is an associative array of all the “attributes” of the shortcode.\u00a0 In this code, we are passing $atts to $exp->export(). That mean that all of this plugin’s standard short code options can be used. They are: show<\/strong><\/a>, hide<\/strong><\/a>, limit<\/strong><\/a>, orderby<\/strong><\/a>, search<\/strong><\/a>, and filter<\/strong><\/a>. Thus, you could write a short code like: [myshortcode form=”Contact form 1″ show=”col1,col2″ search=”Mike” limit=”10″]<\/strong>.<\/p>\n
Add your own attributes<\/strong>: you can add your own attributes simply by adding them to your shortcode call and referencing them in the PHP via $atts[‘attribute-name’]. For example, you might add an “email_user” field like this:<\/p>\n
[myshortcode form=”Contact form 1″ show=”col1,col2″ search=”Mike” limit=”10″ email_user=”true”<\/span>]<\/strong><\/p>\n
And have code like this:<\/p>\n
require_once(ABSPATH . 'wp-content\/plugins\/contact-form-7-to-database-extension\/CFDBFormIterator.php');\r\n$exp = new CFDBFormIterator();\r\n$exp->export($atts['form'], $atts);\r\nwhile ($row = $exp->nextRow()) {\r\n echo '<p>';\r\n foreach ($row as $name => $value) {\r\n \techo \"$name=$value<br\/>\";\r\n }\r\n if ($atts['email_user'] == 'true') {\r\n wp_mail($row['email'], 'Hello ' . $row['name'], 'How are you doing?');\r\n}\r\n\u00a0echo '<\/p>';\r\n}<\/pre>\n
- Add New<\/strong><\/li>\n
- Have a look at the FAQ on Accessing Form Data via PHP<\/a> for some information on the API.<\/li>\n<\/ol>\n