I am trying to replace about 30 codes used in a field in one of my forms. I would prefer to bulk import or replace rather than copying and pasting 30 times.
When I go to functions.php I find relevant code:
function check_student_code_for_evaluation_form() {
global $wpdb;
$sql = "SELECT * FROM evaluation_forms_student_codes WHERE studentcode = '" . $_POST['studentcode'] . "'";
$rows = $wpdb->get_results($sql);
if(empty($rows)) {
echo "invalid";
die();
}
foreach ($rows as $row_data) {
if ($row_data->used) {
echo "used";
}
else {
echo "valid";
}
}
die();
}
add_action('wp_ajax_nopriv_ldr_check_student_code_for_evaluation_form', 'check_student_code_for_evaluation_form'); // for not logged in users
add_action('wp_ajax_ldr_check_student_code_for_evaluation_form', 'check_student_code_for_evaluation_form');
I then went over to phpmyadmin and while I see a table with the name from this code, I don’t see any entries to edit. I’m assuming these codes reside in a table somewhere on my site?