Validating an array with gform_validation

I am trying to use the gform_validation hook to check against an array of codes that we will be sending out to customers. I need to form to only accept the codes that we are using.

I was hoping it was as simple as using the gform_validation to check against an array like so:

add_filter('gform_validation', 'custom_validation');
function custom_validation($validation_result){

    //supposing we don't want input 1 to be a value of 86

	$code = array('aaa2', 'aaa3', 'aaa4');
    if($_POST['input_1'] == $code){

        // set the form validation to false
        $validation_result["is_valid"] = false;

        //finding Field with ID of 1 and marking it as failed validation
        foreach($validation_result["form"]["fields"] as &$field){

            //NOTE: replace 1 with the field you would like to validate
            if($field["id"] == "1"){
                $field["failed_validation"] = true;
                $field["validation_message"] = "Sorry, try again!";
                break;
            }
        }

    }

    return $validation_result;
}

Ideally I would love to be able to check a table within our database, but I am not quite sure how that would be handled. Any help would be appreciated

Yeah that is what I would prefer to do (check the database). I found out that I would be needing to check against about 1500 items, so the array wouldn't work anyway.

Just not sure how to do the database check within that hook.

When I use that code it only reads the first value in the array. I actually wrote that wrong too it should be != instead of == . So it has to be one of the items in the array. But the array doesn't seem to work.

Okay I was able to get it to obviously check the database table that I have. The odd thing is that it seems to ignore the table items I have and only allow other entries. So if I have "AAA1" in the database it won't let me enter that in the form.

If I use this code it doesn't allow any entries, not even the ones that are in the database. But if I change the != to == it only allows entries that aren't in the db...

add_filter('gform_validation', 'custom_validation');
function custom_validation($validation_result){

    //supposing we don't want input 1 to be a value of 86
    global $wpdb;
    $codes = $wpdb->get_results("SELECT code FROM code_check");
    foreach ($codes as $code) {
    if($_POST['input_1'] != $code->code ){

        // set the form validation to false
        $validation_result["is_valid"] = false;

        //finding Field with ID of 1 and marking it as failed validation
        foreach($validation_result["form"]["fields"] as &$field){

            //NOTE: replace 1 with the field you would like to validate
            if($field["id"] == "1"){
                $field["failed_validation"] = true;
                $field["validation_message"] = "Sorry, try again!";
                break;
            } //end if
        } //end foreach

    } //end if
    } // end foreach
    return $validation_result;

} //End Function

Whew. This seems to be working great now. Thanks for talking me through that.

add_filter('gform_validation', 'custom_validation');
function custom_validation($validation_result){

    //supposing we don't want input 1 to be a value of 86
    global $wpdb;
		$input = $_POST['input_1'];
		$code_check = $wpdb->get_results("SELECT code FROM code_check WHERE code ="$input"");
		foreach($code_check as $row){
			$code = $row->code;
		} //end foreach
			if($code != $input){

		        // set the form validation to false
		        $validation_result["is_valid"] = false;

		        //finding Field with ID of 1 and marking it as failed validation
		        foreach($validation_result["form"]["fields"] as &$field){

		            //NOTE: replace 1 with the field you would like to validate
		            if($field["id"] == "1"){
		                $field["failed_validation"] = true;
		                $field["validation_message"] = "Sorry, try again!";
		                break;
		            } //end if
		        } //end foreach

		    } //end if
		    return $validation_result;

} //End Function

If you notice anything wrong here let me know please. Otherwise it only allows the entries in the database table now.

Thanks!

If I remove those lines and only use this:

$code = $code_check->code;

It doesn't work. I am assuming it is because it is returning an array.