Need to write form data to Wordpress database?

Question

WordPress

How to write the data from the form and the data from the questionnaire into the Wordpress database,
you need to have a table with data about the person who passed the test and

try to add the test results

themselves in this way. load.php');
global $wpdb;
$table_name = $wpdb->prefix . "test_info";
$wpdb->insert( $table_name, array( 'name' => $_POST['name'],
'age' => $_POST['age'],
'sex' => $_POST['sex'],
'country' => $_POST['country'],
'city' => $_POST['city']));

covidtest.andygroove.com

Answer 1

Depending on how exactly you want to implement.
The simple solution is to
create an atomic record type.
Install the ACF plugin and add the required fields (name, age, sex, country, city) to the custom post type.
Then, using acf_form, submit the form and create a record in the database

Answer 2

you can use the contakt form 7 plugin to make forms and embed them and download the cf7database plugin and in the admin panel it will display all the data from the form
you can write to the options table in wp there is the possibility https://wp-kama.ru/function/get_option you can in the first column write the name and into another array with data and then take and iterate for output