<?php session_start(); include_once "convenience_functions.php"; $page_number = 4; if (!isset($_GET['page']) || !is_numeric($_GET['page']) || $_GET['page'] >= $page_number) { header('Location:./'); exit; } else { $page = $_GET['page']; } if ($page == $page_number - 1) { saveToDB(); session_destroy(); } else { writePOSTtoSESSION(); } $nextpage = $page + (isset($_POST['previous']) ? -1 : +1) % $page_number; header('Location:./?page=' . $nextpage); exit; function saveToDB() { $db = openDB(); //Patient table $patientSQL = $db->prepare('INSERT INTO Patient ( patient_insee, patient_firstName, patient_lastName, patient_dateOfBirth, patient_sex, patient_size, patient_weight, patient_typeOfID, patient_insurancePlanIdentification, patient_countryOfResidence) VALUES ( :insee, :firstName, :lastName, :dateOfBirth, :sex, :size, :weight, \'INSEE\', \'INSEE\', :countryOfResidence) ON DUPLICATE KEY UPDATE
$kp_id = $_POST['ref_no']; //echo $product.$fieldID.$kp_id; $target_dir = '../uploadFile/' . $kp_id; $attach_loc = 'labs/uploadFile/' . $kp_id . '/'; if (file_exists($target_dir)) { echo ""; } else { mkdir($target_dir); } $target_dir = $target_dir . '/'; if ($fieldID == "sumofMethod" or $fieldID == "otherDoc") { if (isset($_FILES[$fieldID])) { $file_name = renameFile($product, basename($_FILES[$fieldID]["name"])); $target_file = $target_dir . $file_name; move_uploaded_file($_FILES[$fieldID]["tmp_name"], $target_file); saveToDB($kp_id, $fieldID, $file_name, $attach_loc, $target_dir, basename($_FILES[$fieldID]["name"])); } } else { if (isset($_FILES[$fieldID])) { $method = "Compendial"; if (strpos($fieldID, 'non') !== false) { $method = "NonCompendial"; } $cat = "Assay"; if (strpos($fieldID, 'DS') !== false) { $cat = "Dissolution"; } if (strpos($fieldID, 'RS') !== false) { $cat = "RelatedSubstance"; } if (strpos($fieldID, 'MCT') !== false) {