CFDB Plugin

Hi Michael

I have four forms on my site.
– Two in the public area for people looking for care homes: 1. An immediate vacancy 2. A future vacancy.
– Two in the private area: 1. Care home information 2. Listing a vacancy.

When a member of the public provides their details, I want to search the care home information database.

When a vacancy is listed, I want to search the public databases.

I’ve tried to set up your code above, without success. Where am I going wrong – or is there a better way to achieve this?

Thanks.

Brian

I’m stumped also. Help!

The search works great!

From the search, I would only like to show some of the columns in the table. I tried this code however it still shows all columns.

[cfdb-datatable form="Company Contact List" filter="Company~~/.*$_POST(Company).*/i&&ContactName~~/.*$_POST(ContactName).*/i" show="Company,ContactName,Email,Phone,Address,City,State,Zip,ServicesLocation" orderby="Company"]

Any thoughts?

Thanks

I have a field where users enter a date (not the current date). I would like to automatically show all entries whose entered date matches today’s date but I cannot get a call up of the current date to work in the filter. Is this easy to do and I’m just stupid?

I have a field where users enter a date (not today’s date). I would like to automatically show all entries whose entered date matches today’s date but I cannot get a call up of the current date to work in the filter. Is this easy to do and I’m just stupid?

Is this only works for [cfdb-datatable] ??? Can we have Search Form for [cfdb-html] too ???

@Michael Simpson

Super Cool Man… Thanks….

I have also posted few question points on http://cfdbplugin.com/?page_id=284 – from Maulik

I am trying to get this to work on my class website. I have my students submit work through Contact Form and then would like to be able to search the database by simply putting in either the Student Name or the Assignment Name to grade all the work at once. Below is the code the modifications I made to the referenced code from this page but it doesn’t work.

——————————————————————————-

Student Name:
Assignment:

[cfdb-datatable form="Submit: 2012-13 Per 1"
filter="your-name~~/.*$_POST(sname).*/i&&assignment-name~~/.*$_POST(work).*/i" show="Submitted,your-name,assignment-name,assignment-attch"]
——————————————————————————-

Here is the page I am refering to that doesn’t work. Please let me know how to fix this, it would REALLY HELP ME with grading my students work efficiently.
http://ganttech.com/studentwork/search/
What happens is the page simply refreshes without showing anything. Not sure what to do. PLEASE HELP!

I am trying to get this to work on my class website. I have my students submit work through Contact Form and then would like to be able to search the database by simply putting in either the Student Name or the Assignment Name to grade all the work at once. Below is the code the modifications I made to the referenced code from this page but it doesn’t work.

——————————————————————————-

Student Name:
Assignment:

[cfdb-datatable form="Submit: 2012-13 Per 7"
filter="your-name~~/.*$_POST(sname).*/i&&assignment-name~~/.*$_POST(work).*/i" show="Submitted,your-name,assignment-name,assignment-attch"]
——————————————————————————-
Here is the page I am referring to that doesn’t work. Please let me know how to fix this, it would REALLY HELP ME with grading my students work efficiently.
http://ganttech.com/studentwork/search/
What happens is the page simply refreshes without showing anything. Not sure what to do. PLEASE HELP!

@Michael Simpson
I didn’t even think about breaking it apart to verify each part. I did that, and for some reason it’s now working. Thanks, this will really help with my grading this year.

How can i add search box that can search all attribute

@Alipio
its like the search box in the [cfdb-datatable]

Hi – I need to pre-fill forms based on user entering their email address.
Is there an existing template I might modify?
Thanks in advance!
ER

How do I filter a submit_time in this example ?

[cfdb-table form="contact-form" filter="submit_time>/.*$_POST(sometime).*/i"]

This is not working.

@Ernest
Had to learn about regex here,because time filter will not work with it ,but this will work instead
[cfdb-table form="contact-form" filter="submit_time>$_POST(sometime)"]
Thanks for this usefull plugin Michael !

Hi Michael.
First, congratulations for CFDB plugin, it’s a great plugin, very usefull.

My need is the same above, but i need show the distinct values.

Example: Many people submit a form. I create a page for filter this submissions, using shortcode cfdb-html to show the name of those people into combo, like your post above. But, one person can submit more than one form, and I need show the name of people into combo without repeat. Is possible?

Using mysql_query, I know it’s possible (select distinct column-name).

And using shortcode? If not, you could add this feature for plugin, some like [cfdb-html distinct=field-name].

All the best. Thanks again for support.

Hello,

I need your expertise on a kind of difficult taks for me, but I’m sure its wouldnt be not at all hard for you.

I just installed the plugin for the purpose of creating a form that will have a required field and the required field needs to query a database. If the enduser does not enter in the correct information according to what I have in the database, then the validation should fail and the page should not redirect to another page.

Bascially, I have a form where I would for my clients to enter in their building name of where they work. I have created a database in myPHPadmin with a list of building names. If the enduser does not provide the correct name of a building, then the validation is suppose to fail. Otherwise, it should redirect them to another page.

I actually researched and found shortcode to redirect the page using contact form 7..but i need help in querying a databse to pass validation on a required field.

Any suggestions? Or is it possible to create a customized shortcode for this?

Thanks in advance for any help provided.

Hi Michael, thanks for the quick response. You are a very knowledgeable person.

I used your recommended code to validate a required field on my form. Can you take a look at it? For some reason, it is still allowing the enduser to pass validation by entering in a bogus building name, but that field should check the database to make sure a legitimate building name ihas been entered.

I want one field on my form to pass validation. To ensure our clients are using this particualr form only and not just the general public, we want the enduser to enter their building name that corresponds to a building name that I have setup in a database myPHPadmin. If they do not enter in a correct building name, then they should get an error message, sayiing ” please enter your building name”. Otherwise, the validation should pass to the next page if the correct building name was entered.

I dont know if I am doing this right, but here is the information and the code that I modified just a teeny bit.

The name of my form is “Show Me Deals Copy”
The form text field name is “Building”
In phpmyadmin , the Database is “Deals” and the table is “Building”

function is_already_submitted($formName, $fieldName, $fieldValue){
require_once(ABSPATH . ‘wp-content/plugins/contact-form-7-to-database-extension/CFDBFormIterator.php’);
$exp = new CFDBFormIterator();
$atts = array();
$atts[‘show’] = $fieldName;
$atts[‘filter’] = “$fieldName=$fieldValue”;
$exp->export($formName, $atts);
$found = false;
while ($row = $exp->nextRow()) {
$found = true;
}
return $found;
}

function my_validate_email($result, $tag) {
$formName = ‘show_me_deals_copy’; // Name of the form containing this field
$fieldName = ‘building’; // Set to your form’s unique field name
$name = $tag[‘name’];
if($name == $fieldName){
$valueToValidate = $_POST[$name];
if (is_already_submitted($formName, $fieldName, $valueToValidate)) {
$result[‘invalid’] = false;
$result[‘reason’][$name] = ‘Please enter your building name’; // error message
}
}
return $result;
}

add_filter(‘wpcf7_validate_text*’, ‘my_validate_email’, 10, 2);

Yes. My building field is required on my CF7, however, it still allows an enduser to put a bogus building name in that field. Any reason why it is not searching the database to query the building name …or any other suggestions to make that field sync or query the database I created in PHPHmyadmin for correct building names before passing validation?

here is the code that I am using:

function is_already_submitted($formName, $fieldName, $fieldValue){
require_once(ABSPATH . ‘wp-content/plugins/contact-form-7-to-database-extension/CFDBFormIterator.php’);
$exp = new CFDBFormIterator();
$atts = array();
$atts[‘show’] = $fieldName;
$atts[‘filter’] = “$fieldName=$fieldValue”;
$exp->export($formName, $atts);
$found = false;
while ($row = $exp->nextRow()) {
$found = true;
}
return $found;
}
function my_validate_email($result, $tag) {
$formName = ‘show_me_deals_copy’; // Name of the form containing this field
$fieldName = ‘building’; // Set to your form’s unique field name
$name = $tag[‘name’];
if($name == $fieldName){
$valueToValidate = $_POST[$name];
if (is_already_submitted($formName, $fieldName, $valueToValidate)) {
$result[‘invalid’] = false;
$result[‘reason’][$name] = ‘Please enter your building name’; // error message
}
}
return $result;
}
add_filter(‘wpcf7_validate_text*’, ‘my_validate_email’, 10, 2);