$data[$key] = mysql_real_escape_string($data[$key]); } mysql_query("START TRANSACTION"); $ins = mysql_query("INSERT INTO `r_employee` (\r\n\t`emp_id`,\r\n\t`empno`,\r\n\t`name`,\r\n\t`nic`,\r\n\t`tel`,\r\n\t`gender`,\r\n\t`epfno`,\r\n\t`basic`,\r\n\t`reg_date`,\r\n\t`status`\r\n)\r\nVALUES" . "('{$data['emp_id']}', '{$data['empno']}', '{$data['name']}', '{$data['nic']}', '{$data['tel']}', '{$data['gender']}', '{$data['epfno']}', '{$data['basic']}','{$data['reg_date']}','1')") or die(mysql_error()); $trn = mysql_query("INSERT INTO `transaction` (`tr_type`, `tr_desc`, `tr_date`, `tr_user_id`) VALUES ('INSERT', 'employee-{$data['empno']}', '{$today}', '{$_SESSION['user_id']}')") or die(mysql_error()); if ($ins && $trn) { mysql_query("COMMIT"); echo json_encode(array(array("msgType" => 1, "msg" => "Employee saved"))); } else { mysql_query("ROLLBACK"); echo json_encode(array(array("msgType" => 2, "msg" => "Could not save"))); } MainConfig::closeDB(); } else { if ($_POST['action'] == 'next_ai_emp') { $A = $system->getNextAutoIncrementID("r_employee"); echo json_encode($A); // $system->prepareSelectQueryForJSONSingleData("SELECT `AUTO_INCREMENT` AS max_ai FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'carsale_db' AND TABLE_NAME = 'vehicle'"); } else { if ($_POST['action'] == 'update_employee') { $today = date('Y-m-d'); $data = $_POST['form_data']; if (empty($data['empno'])) { echo json_encode(array(array("msgType" => 2, "msg" => "Enter a supplier code"))); return; } foreach ($data as $key => $value) { $data[$key] = mysql_real_escape_string($data[$key]); } mysql_query("START TRANSACTION"); $ins = mysql_query("INSERT INTO `r_employee` (\r\n\t`emp_id`,\r\n\t`empno`,\r\n\t`name`,\r\n\t`nic`,\r\n\t`tel`,\r\n\t`gender`,\r\n\t`epfno`,\r\n\t`basic`,\r\n\t`reg_date`,\r\n\t`status`\r\n)\r\nVALUES" . "('{$data['emp_id']}', '{$data['empno']}', '{$data['name']}', '{$data['nic']}', '{$data['tel']}', '{$data['gender']}', '{$data['epfno']}', '{$data['basic']}','{$data['reg_date']}','1')") or die(mysql_error());