{"id":96,"date":"2011-02-17T13:02:17","date_gmt":"2011-02-17T18:02:17","guid":{"rendered":"http:\/\/cfdbplugin.com\/?page_id=96"},"modified":"2016-12-15T21:55:10","modified_gmt":"2016-12-16T02:55:10","slug":"cfdb-json","status":"publish","type":"page","link":"https:\/\/cfdbplugin.com\/?page_id=96","title":{"rendered":"[cfdb-json]"},"content":{"rendered":"

This documentation applies to version 2.6 and later<\/span><\/p>\n

Summary of Shortcode Options<\/strong><\/h1>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Option<\/strong><\/td>\nExample
\n<\/strong><\/td>\n		Description<\/strong><\/td>\n<\/tr>\n
form<\/strong><\/a><\/td>\n[cfdb-json form=\"myform\"<\/strong>]<\/code><\/td>\nRequired. Designates the form to display. All rows and columns are displayed by default<\/td>\n<\/tr>\n
role<\/strong><\/a><\/td>\n[cfdb-datatable form=\"myform\" role=\"Author\"<\/strong>]<\/code><\/td>\nMake short code only display output for user’s with minimum-required role. Choices are<\/p>\n
    \n
  • Administrator<\/li>\n
  • Editor<\/li>\n
  • Author<\/li>\n
  • Contributor<\/li>\n
  • Subscriber<\/li>\n
  • Anyone<\/li>\n<\/ul>\n

    WARNING<\/strong>: this setting is overridden by plugin setting in WP Admin page Contact -> Database Options -> Can See Submission when using shortcodes
    \n(since 2.4.1)\n<\/td>\n<\/tr>\n

show<\/strong><\/a><\/td>\n[cfdb-json form=\"myform\" show=\"col1,col2\"<\/strong>]<\/code><\/td>\nLimits columns to be shown to be those designated (comma-delimited list)<\/td>\n<\/tr>\n
hide<\/strong><\/a><\/td>\n[cfdb-json form=\"myform\" hide<\/span>=\"col1,col2\"<\/strong>]<\/code><\/td>\nDoes not show listed columns (comma-delimited list)<\/td>\n<\/tr>\n
limit<\/strong><\/a><\/td>\n[cfdb-json\u00a0form=\"myform\"\u00a0limit=\"10\"<\/strong>]<\/code><\/td>\nOne number: limit=”10″ means show first 10 rows. Is the same as limit=”0,10″
\nTwo Numbers: limit=”100,10″ means show 10 rows starting at row #100)<\/td>\n<\/tr>\n
random<\/strong><\/a><\/td>\n[cfdb-table form=\"myform\"\u00a0random=\"2\"<\/strong>]<\/code><\/td>\nDisplay 2 random rows from those that the short code finds. (Since 2.4)<\/td>\n<\/tr>\n
orderby<\/strong><\/a><\/td>\n[cfdb-json\u00a0form=\"myform\"\u00a0orderby=\"last-name,first-name\"<\/strong>]<\/code><\/td>\nSort rows by designated columns. Use “column-name desc” to sort in descending (reverse) order<\/td>\n<\/tr>\n
search<\/strong><\/a><\/td>\n[cfdb-json\u00a0form=\"myform\"\u00a0search<\/span>=\"Simpson\"<\/strong>]<\/code><\/td>\nSelect rows to display that have any cell with the search text in it (case insensitive). Intended to mimic behavior of the “Search” field in the DataTable<\/td>\n<\/tr>\n
filter<\/strong><\/a><\/td>\n[cfdb-json form=\"myform\" filter<\/span>=\"col1=Simpson\"<\/strong>]<\/code><\/td>\nSelect which rows to display based on filter expression. More powerful than “search”, it can filter on multiple columns with boolean and regular expressions. If both “search” and “filter” are specified, “search” is ignored.<\/td>\n<\/tr>\n
Options specific to this shortcode<\/em><\/td>\n<\/tr>\n
var<\/strong><\/a><\/td>\n[cfdb-json form=\"myform\" var<\/span>=\"myJsVar\"<\/strong>]<\/code><\/td>\nSets the Javascript variable name<\/td>\n<\/tr>\n
format<\/a><\/strong><\/td>\n[cfdb-json form=\"myform\"\u00a0format<\/span>=\"array\"<\/strong>]<\/code><\/td>\nCan be “map<\/strong>“, “array<\/strong>” or “arraynoheader<\/strong>“. Default is “map”<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Use [cfdb-json form=\"your-form\"]<\/code> with optional show<\/code>, hide<\/code> and filter<\/code> just like[cfdb-table]<\/code>.<\/p>\n

The [cfdb-json]<\/code> works much the same as the [cfdb-table]<\/code> tag but it outputs a <script><\/code> tag in the HTML in which it set a Javascript variable equal to a JSON representation of the data.<\/p>\n

<\/a>Use var<\/code> to indicate the name of the javascript variable you would like. For example:<\/span>
\n[cfdb-json var=\"mystuff\"]<\/code><\/p>\n

would result in an HTML script tag:<\/p>\n

<script type=\"text\/javascript\" language=\"JavaScript\">
\nvar mystuff = [the json data];
\n<\/code><\/script><\/p>\n

Use show<\/code>, hide<\/code>, filter<\/code> options work just as they do for all shortcodes.<\/p>\n

<\/a>JSON Formats<\/strong><\/p>\n

The “format<\/strong>” option provides these options:<\/p>\n

“map<\/strong>” is an array of maps (associative arrays).\u00a0Each row is a map of column-name -> value. Each “cell” is referenced byjsonVar[row-integer][col-name-string]<\/code>. For example, using\u00a0[cfdb-json var=\"mystuff\"]<\/code> you would be able to reference an example value in Javascript using:\u00a0mystuff[0][\"Submitted\"]<\/code> to refer to the first row, “Submitted” column.<\/p>\n

Example:
\n[
\n{\"Submitted\":\"December 10, 2010 10:30 am\",\"your-name\":\"Name1\",\"checkbox-311\":\"first\",\"text-940\":\"Field2\"},
\n{\"Submitted\":\"December 10, 2010 9:54 am\",\"your-name\":\"Alphred\",\"checkbox-311\":\"third\",\"text-940\":\"xxxx\"},
\n{\"Submitted\":\"November 16, 2010 12:54 pm\",\"your-name\":\"joe\",\"checkbox-311\":\"second\",\"text-940\":\"goodbye\"},
\n{\"Submitted\":\"November 16, 2010 12:54 pm\",\"your-name\":\"mike\",\"checkbox-311\":\"first\",\"text-940\":\"hello\"}
\n]<\/code>
\n“array<\/strong>” is a 2D array of the data, with the first row being the column headers.<\/p>\n

Example:
\n[
\n[\"Submitted\",\"your-name\",\"checkbox-311\",\"text-940\"],
\n[\"December 10, 2010 10:30 am\",\"Name1\",\"first\",\"Field2\"],
\n[\"December 10, 2010 9:54 am\",\"Alphred\",\"third\",\"xxxx\"],
\n[\"November 16, 2010 12:54 pm\",\"joe\",\"second\",\"goodbye\"],
\n[\"November 16, 2010 12:54 pm\",\"mike\",\"first\",\"hello\"]
\n]<\/code>
\n“arraynoheader<\/strong>” is the same as “array” but without the first header row. Is is a 2D array of just the data.<\/p>\n

 <\/p>\n

Example:
\n[
\n[\"December 10, 2010 10:30 am\",\"Name1\",\"first\",\"Field2\"],
\n[\"December 10, 2010 9:54 am\",\"Alphred\",\"third\",\"xxxx\"],
\n[\"November 16, 2010 12:54 pm\",\"joe\",\"second\",\"goodbye\"],
\n[\"November 16, 2010 12:54 pm\",\"mike\",\"first\",\"hello\"]
\n]<\/code><\/p>\n

How to make an AJAX call to get JSON<\/h4>\n

NOTE: the URLs below changed in version 1.8. The 1.8+ URLs are now shown below.<\/p>\n

The quick way to see what URL you need to make an AJAX, go to the Database admin page and export to type JSON. Then look at the URL in the browser. It will be of the following form (in this example our form name is “Form Name” so we have to use “Form+Name” in the URL:<\/p>\n

http:\/\/mywordpress.com\/wp-admin\/admin-ajax.php?action=cfdb-export&form=Form+Name&enc=JSON&format=map<\/code><\/p>\n

Issues<\/strong>: you will run into problems if you not logged in when making this AJAX call because WordPress will redirect you to the login form page. To get past that, you need to use the URL for the login page with a redirect_to<\/code> parameter that gives the URL that you would have wanted above. The problem is that you have to URL-encode the parameters in that URL.<\/p>\n

In other words, Example: (You will have to substitute EncodedFormName<\/code> below for the URLEncoded name of your form)<\/p>\n

http:\/\/mywordpress.com\/wp-admin\/admin-ajax.php?action=cfdb-export&form%3DEncodedFormName%26enc=JSON%26format%3DFarray <\/code><\/p>\n

NOTE: You can also append show<\/code>, hide<\/code>, search<\/code> and filter<\/code> to the URL<\/p>\n","protected":false},"excerpt":{"rendered":"

Summary of Shortcode Options Option Example Description form Required. Designates the form to display. All rows and columns are displayed by default role Make short code only display output for user’s with minimum-required role. Choices are Administrator Editor Author Contributor Subscriber Anyone WARNING: this setting is overridden by plugin setting in WP Admin page Contact […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1577,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"page-without-sidebar.php","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"class_list":["post-96","page","type-page","status-publish","hentry"],"jetpack_shortlink":"https:\/\/wp.me\/P1mptf-1y","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/96","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=96"}],"version-history":[{"count":47,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/96\/revisions"}],"predecessor-version":[{"id":1238,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/96\/revisions\/1238"}],"up":[{"embeddable":true,"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=\/wp\/v2\/pages\/1577"}],"wp:attachment":[{"href":"https:\/\/cfdbplugin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}