exec_query("certificates", ['*'], '', '', '', '', "1", "ORDER BY record_id DESC LIMIT 1"); $data = $res->fetch_assoc(); $cert_number = $data['certificate_number'] + 1; } else { $cert_number = $_POST['cert_number']; } $certificate = explode(" ~ ", $_POST['certificate']); // get_certificate prefix $course_res = $db->exec_query('courses', ['*'], '', '', '', '', "record_id = {$certificate['0']}"); $course = $course_res->fetch_assoc(); $prefix = $course['certificate_no_prefix']; $date_created = date('Y-m-d'); $date_of_certificate = $_POST['date_of_cert']; $expiry_date = $_POST['expiry_date']; // employee_details $employee_id = explode(" ~ ", $_POST['person']); $employee_id = $employee_id[4]; // employee_details $course_id = explode(" ~ ", $_POST['person']); $course_id = $course_id[4]; $record_id = $db->insert("INSERT INTO `certificates`( `certificate_number`, `prefix`, `courses_id`, `client_employees_id`, `date_time_created`, `date_time_of_certification`, `expiry_date`, `certification_template`, `nqf_level`, `credits`, `dol_ci_no`, `iso_no`, `unit_std_no`, `safesure_users_id` ) VALUES ( '$cert_number', '$prefix', '$course_id', '$employee_id', '$date_created', '$date_of_certificate', '$expiry_date', 'TEMP 1', '{$_POST['nql_level']}', '{$_POST['credits']}', '{$_POST['dol_ci_no']}', '{$_POST['iso_no']}', '{$_POST['unit_std_no']}', '{$_SESSION['user_id']}' )"); echo "";