insert("DELETE FROM bookings WHERE record_id = {$_POST['record_id']}"); if ($_POST['status'] == "APPROVED") { $db->insert("INSERT INTO `bookings` (`date_booked`,`date_approved`,`safesure_users_id`,`clients_id`,`client_employees`,`assesments`,`status`) VALUES ('$booking_date','$date','{$_POST['users']}','{$_POST['clients']}','B:{$_POST['amount']}','{$_POST['assesment']}','{$_POST['status']}')"); } else { $db->insert("INSERT INTO `bookings` (`date_booked`,`date_approved`,`safesure_users_id`,`clients_id`,`client_employees`,`assesments`,`status`) VALUES ('$booking_date','','{$_POST['users']}','{$_POST['clients']}','B:{$_POST['amount']}','{$_POST['assesment']}','{$_POST['status']}')"); } } else { $index = 1; $emp_ids = ''; $assesment_ids = ''; $contractors = ','; while ($index <= $_POST['row_count']) { if (strlen($_POST["emp_name_$index"]) > 1) { if ($_POST["is_emp_$index"] == 'n') { $record_id = $db->insert("INSERT INTO `client_employees` (`client_employees_name`,`surname`,`clients_id`,`i_doc_passport`,`occupation`) VALUES ('{$_POST["emp_name_$index"]}','{$_POST["emp_sur_$index"]}','{$_POST['clients']}','{$_POST["emp_id_$index"]}','{$_POST["emp_occ_$index"]}')"); } else { $record_id = $_POST["is_emp_$index"]; } $emp_ids = $emp_ids . "$record_id,"; $assesment_ids = $assesment_ids . "{$_POST["assesment_$index"]},"; $contractors .= "{$_POST["client_contractor_$index"]},"; } $index++; } echo $emp_ids; echo $assesment_ids; if ($_POST['status'] == "APPROVED") { $db->Update('bookings', ['date_booked', 'date_approved', 'safesure_users_id', 'clients_id', 'client_employees', 'assesments', 'status', 'client_sites_id'], [$booking_date, $date, $_POST['users'], $_POST['clients'], ",$emp_ids", ",$assesment_ids", $_POST['status'], $contractors], "record_id = {$_POST['record_id']}"); } else { $db->Update('bookings', ['date_booked', 'date_approved', 'safesure_users_id', 'clients_id', 'client_employees', 'assesments', 'status', 'client_sites_id'], [$booking_date, '', $_POST['users'], $_POST['clients'], ",$emp_ids", ",$assesment_ids", $_POST['status'], $contractors], "record_id = {$_POST['record_id']}"); } } echo "";