Need A Form Field To Validate From A CSV File In Wordpress

Question

I have been hitting a roadblock here, I am a novice coder and a bit rusty as well. The below code works fully in a wordpress functions file but I really want to validate from a CSV file vs entering 2000 lines to validate against.

add_filter('frm_validate_field_entry', 'mobileform_custom_validation', 10, 3);
function mobileform_custom_validation($errors, $posted_field, $posted_value){
if($posted_field->id == 496){ //change 496 to the ID of the field to validate
if(!in_array($posted_value, array('001','002'))){ //change 001 and 002 to your allowed values
  //if it doesn't match up, add an error:
$errors['field'. $posted_field->id] = 'Please contact us.';
}
}
return $errors;
}

Or validate against a text file would work too.

Rob Mcg
– Rob Mcg

2018-01-31 07:35:56 +00:00
Commented Jan 31, 2018 at 7:35 — Rob Mcg
– Rob Mcg, Commented Jan 31, 2018 at 7:35

Bar-code · Accepted Answer · 2018-01-31 08:34:12Z

2

This line will get the first column of a csv file into an array:

$list = array_map(function ($line) { return str_getcsv($line)[0]; }, file('../path_to/your_csv_file.csv'));

Then you just have to use it in your test:

if(!in_array($posted_value, $list)){

Your code will then look like:

add_filter('frm_validate_field_entry', 'mobileform_custom_validation', 10, 3);
function mobileform_custom_validation($errors, $posted_field, $posted_value){
    if($posted_field->id == 496){
        $list = array_map(function ($line) { return str_getcsv($line)[0]; }, file('../path_to/your_csv_file.csv'));
        if(!in_array($posted_value, $list)){
            $errors['field'. $posted_field->id] = 'Please contact us.';
        }
    }
    return $errors;
}

But you have to set properly the path to your csv file by replacing

../path_to/your_csv_file.csv

By the real path of your CSV file. I can't do this part for you.

edited Jan 31, 2018 at 8:34

answered Jan 31, 2018 at 8:10

Bar-code

2771 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rob Mcg Over a year ago

I added in the second part, where exactly do I put the first part? If i place it in the functions file by itself it doesn't work?

Bar-code Over a year ago

I edited my answer to show you how the code should look like. You still have to change the path of the cvs file by yourself...

Collectives™ on Stack Overflow

Need A Form Field To Validate From A CSV File In Wordpress

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related