I have a session of variables that need to be input into a database. Here are all the fields I want input into a database.
[php]
<?php //let's start our session, so we have access to stored data session_start(); //let's create the query $insert_query = 'insert into subscriptions ( student_type, student_first_name, student_middle_name, student_last_name, canadian_name, passport_number, father_first_name, father_middle_name, father_last_name, mother_first_name, mother_middle_name, mother_last_name, language, date_of_birth, language_assistance, street_number, street_name, apartment_number, direction, town_city, country, overseas_phone_code, phone_area_code, phone_number, overseas_fax_code, fax_phone_number, fax_area_code, email, custodian_guardia, canadian_street_name, canadian_apartment_number, canadian_direction, canadian_town_city, canadian_country, canadian_postalcode_zipcode, homestay_provider, canadian_overseas_phone_code, canadian_phone_area_code, canadian_phone_number, canadian_overseas_fax_code, canadian_fax_phone_number, email, school_year_request, grade_request, semester_request, school_request, medical_insurance ) values ( ' . $_SESSION['student_type'] . ' ' . $_SESSION['student_first_name'] . ' ' . $_SESSION['student_middle_name'] . ' ' . $_SESSION['student_last_name'] . ' ' . $_SESSION['canadian_name'] . ' ' . $_SESSION['passport_number'] . ' ' . $_SESSION['father_first_name'] . ' ' . $_SESSION['father_middle_name'] . ' ' . $_SESSION['father_last_name'] . ' ' . $_SESSION['mother_first_name'] . ' ' . $_SESSION['mother_middle_name'] . ' ' . $_SESSION['mother_last_name'] . ' ' . $_SESSION['language'] . ' ' . $_SESSION['date_of_birth'] . ' ' . $_SESSION['language_assistance'] . ' ' . $_SESSION['street_number'] . ' ' . $_SESSION['street_name'] . ' ' . $_SESSION['apartment_number'] . ' ' . $_SESSION['direction'] . ' ' . $_SESSION['town_city'] . ' ' . $_SESSION['country'] . ' ' . $_SESSION['overseas_phone_code'] . ' ' . $_SESSION['phone_area_code'] . ' ' . $_SESSION['phone_number'] . ' ' . $_SESSION['overseas_fax_code'] . ' ' . $_SESSION['fax_area_code'] . ' ' . $_SESSION['fax_phone_number'] . ' ' . $_SESSION['custodian_guardia'] . ' ' . $_SESSION['canadian_street_name'] . ' ' . $_SESSION['canadian_apartment_number'] . ' ' . $_SESSION['canadian_direction'] . ' ' . $_SESSION['canadian_town_city'] . ' ' . $_SESSION['canadian_country'] . ' ' . $_SESSION['canadian_postalcode_zipcode'] . ' ' . $_SESSION['homestay_provider'] . ' ' . $_SESSION['canadian_overseas_phone_code'] . ' ' . $_SESSION['canadian_phone_area_code'] . ' ' . $_SESSION['canadian_phone_number'] . ' ' . $_SESSION['canadian_overseas_fax_code'] . ' ' . $_SESSION['canadian_fax_phone_number'] . ' ' . $_SESSION['email'] . ' ' . $_SESSION['school_year_request'] . ' ' . $_SESSION['grade_request'] . ' ' . $_SESSION['canadian_overseas_fax_code'] . ' ' . $_SESSION['semester_request'] . ' ' . $_SESSION['school_request'] . ' ' . $_POST['medical_insurance'] . ')' ; //let's run the query ?>[/php]
Where the query is to run, I don’t know how to insert the data into a database. The database I am trying to upload this into is Access. Can anyone help me?