Unique Field – Prevent Contact form 7 Duplicate Submissions
function is_already_submitted($formPostId, $fieldName, $fieldValue) {
global $wpdb;
/*We make a select in the table where the contacts are recorded, checking if the email informed already exists on today's date */
$entry = $wpdb->get_results( "SELECT * FROM DB_PREFIX_db7_forms WHERE form_value LIKE '%$fieldValue%' AND form_post_id = '$formPostId'" );
// If the select query in the database is positive (the email exists on the current date), it returns the error in the form, in the email field, not sending
$found = false;
if (!empty($entry)) {
$found = true;
}
return $found;
}
function my_validate_email($result, $tag) {
$formPostId = 'FORM_ID'; // Change to name of the form containing this field
$fieldName = 'your-email'; // Change to your form's unique field name
$errorMessage = 'This email address is already registered'; // Change to your error message
$name = $tag['name'];
if ($name == $fieldName) {
if (is_already_submitted($formPostId, $fieldName, $_POST[$name])) {
$result->invalidate($tag, $errorMessage);
}
}
return $result;
}
add_filter('wpcf7_validate_email*', 'my_validate_email', 10, 2);