Please activate Contact Form plugin first.

Please update latest version for Contact Form plugin first.

get_results($sql,ARRAY_N); $arr_form_id = array(); if(!empty($data)){ foreach($data as $arrVal){ $arr_form_id[] = (int)$arrVal[0]; } } ?>

Developer Support

Display Enquiry Ban IP Actions & Filters

Display Enquiry

You can display all contact form submission data on front end side of website to place the short codes.

You can place these short codes in any page OR use to "do_shortcode" function to execute from php files.

Ex. do_shortcode( ‘[acf7db form_id='2']’ );

You can use below options in short codes:

Parameter Description Example
FORM ID

You can add form id to display the form data.

[acf7db form_id='2']

You need to add multiple form ids to display multiple form data.

[acf7db form_id='2,3']

Note:- If you don't pass id in it or keep empty than output will have all forms data.

SHOW

You need to add the columns names with form ids to display on front end side.

This will display only 1 column for form 2 data, and all columns for form 3 data.

[acf7db form_id='2,3' show='2.your-name']

You can also add multiple columns to display multiple form data.

This will display only 1 column for form 2 and form 3 data.

[acf7db form_id='2,3' show='2.your-name, 3.your-email']

HIDE

You can specify particular columns which you won't like to display.

It means that to display all columns except 1 column ("your-name") for form 2 data, and all columns for form 3 data.

[acf7db form_id='2,3' hide='2.your-name']

You can also add multiple columns to don't display multiple form data.

This will display all columns except 1 column ("your-name") for form 2 data, and all columns except 1 column ("your-email") for form 3 data.

[acf7db form_id='2,3' hide='2.your-name, 3.your-email']

SEARCH

You can search by keyword.

It will display all submitted data with value like "test@gmail.com".

[acf7db form_id='2,3' search='test@gmail.com']

DATE

You can search by date using date parameters.

It is required to pass "start-end date". If any one date will be mentioned then it doesn't work.

It's means that to display all submitted data with submit time in between "01/09/2017" and "01/10/2018" .

[acf7db form_id='2,3' start-date="01/09/2017" end-date="01/10/2018"]

Note:- This parameter will have effect if start date and end date both given with proper format. Both date should be in "dd/mm/yyyy" format.

ID

You can add id to the table tag of output data.

This will add id to the table.

[acf7db form_id='2,3' id='my-table-id']

Note:- This parameter will have effect only when format "Table" is given.

CLASS

You can add classes to the table tag of output data.

This will add classes to the table.

[acf7db form_id='2,3' class='form-table-class1 form-table-class2']

Note:- This parameter will have effect only when format "Table" is given.

STYLE

You can add style to the table tag of output data.

This will add style to the table.

[acf7db form_id='2,3' style='max-width=400px;']

Note:- This parameter will have effect only when format "Table" is given. Style will be added as inline style.

HEADER

You can add custom header which will be displayed as title for every table. Headers must be used with form id to to affect the output data.

This will display "Form Header Text 1" as title for form 2 data. Form 3 data title will be form name.

[acf7db form_id='2,3' header='2.Form Header Text 1']

You can add multiple columns which will be displayed for multiple form data.

This will display "Form Header Text 1" as title for form 2 data and "Form Header Text 2" as title for Form 3 data.

[acf7db form_id='2,3' header='2.Form Header Text 1, 3.Form Header Text 2']

Note:- This parameter will have effect only when format "Table" is given. If header is not passed than it will use form title.

DISPLAY

You can select the output type from following types :

This will output the short code as a table structure.

[acf7db form_id='2,3' display='table']

This will output the short code as a data count only.

[acf7db form_id='2,3' display='count']

Ban IP

You can use below short code to skip saving of IP address :

Skip Saving Of IP Address

[cf7-db-display-ip]

OR
do_shortcode( ‘[cf7-db-display-ip]’ );

Note
You need to add this code in function file to skip saving IP address.

Actions & Filters

Here a list of actions and filters added is given.

You can use below hooks as per your requirement at your own risk.

Actions

vsz_cf7_display_settings_btn

Parameters : $fid

You can change "Display Settings" using this action.

".get_highlighted_code($code).""; ?>

vsz_cf7_after_datesection_btn

Parameters : $fid

Using this action,you can add custom coding after date section in listing screen.

".get_highlighted_code($code).""; ?>

vsz_cf7_after_bulkaction_btn

Parameters : $fid

Using this action,you can add custom coding after bulk action section in listing screen.

".get_highlighted_code($code).""; ?>

vsz_cf7_admin_after_heading_field

Parameters : -

Using this action,you can display table header in edit column.

".get_highlighted_code($code).""; ?>

vsz_cf7_admin_after_body_field

Parameters : $fid, $row_id

Using this action, you can add custom coding before edit icon.

".get_highlighted_code($code).""; ?>

vsz_cf7_after_admin_form

Parameters : $fid

Using this action, you can add custom coding after whole form.

".get_highlighted_code($code).""; ?>

vsz_cf7_before_insert_db

Parameters : $contact_form

Using this action, you can customize form data before insert in data base.

".get_highlighted_code($code).""; ?>

vsz_cf7_after_insert_db

Parameters : $contact_form, $cf7_id, $data_id

Using this action, you can customize process after insert value in data base.

".get_highlighted_code($code).""; ?>

Filters

vsz_cf7_entry_order_by

Parameters : String

You can change the order of fields using this filter.

".get_highlighted_code($code).""; ?>

vsz_cf7_entry_per_page

Parameters : Integer (Default: 10)

You can change the number of entries per page using this filter.

".get_highlighted_code($code).""; ?>

vsz_display_character_count

Parameters : Integer (Default: 30)

This filter defines how many characters will be displayed in listing screen. You can change the number of characters displayed using this filter.

".get_highlighted_code($code).""; ?>

vsz_cf7_not_editable_fields

Parameters : Array

You can change non editable fields list using this filter.

".get_highlighted_code($code).""; ?>

vsz_cf7_entry_actions

Parameters : Array

You can add/remove any option for "Bulk Action" in listing screen.

".get_highlighted_code($code).""; ?>

vsz_cf7_import_date_format

Parameters : -

You can change the date format to import functionality with this filter.

".get_highlighted_code($code).""; ?>

vsz_cf7_unwanted_form_data_submission

Parameters : Array

You can exclude contact form ids using this filter and those form entries won't be inserted in advanced contact form database.

".get_highlighted_code($code).""; ?>

vsz_cf7_modify_form_before_insert_data

Parameters : $contact_form

You can change the entry data before it saved to database.

".get_highlighted_code($code).""; ?>

vsz_cf7_posted_data

Parameters : $posted_data

This filter provided to the users to modify the data.Below is the process that can be performed

1) Add new data to the CF7 Form
2) Can modify the existing form submitted data
3) Can unset or remove the existing form data of CF7

".get_highlighted_code($code).""; ?>

vsz_cf7_no_save_fields

Parameters : Array

You can exclude contact form ids using this filter and those form field's entry won't be inserted in advanced contact form database.

".get_highlighted_code($code).""; ?>

cf7d_entry_value

Parameters : Value,Key

You can modify specific field value using this filter.

".get_highlighted_code($code).""; ?>

vsz_cf7_admin_fields

Parameters : Fields, fid

You can modify fields displaying in listing screen using this filter.

".get_highlighted_code($code)."";
						?>

vsz_cf7_get_current_action

Parameters : $current_action

If you have added additional option in "Bulk Actions", then you need to do custom coding for that additional option over here.

".get_highlighted_code($code).""; ?>