prepare("SELECT id, exten_for_external, exten_for_ext_pass, conf_extension FROM external_users WHERE exten_for_external = ? AND exten_for_ext_pass = ? AND conf_extension = ?"); $query->bind_param("sss", $vconfExtension, $extenPassEnc, $conferenceExt); $query->execute(); $extqueryres = $query->get_result()->fetch_array(); if (!$extqueryres) { http_response_code(400); exit(); } else { $date = date("Y-m-d H:i:s"); $updatequery = $mysqli->prepare("UPDATE external_users SET profile_name = ?, show_vconf_usernames = ?, display_vconf_user = ?, date_modified = ? WHERE exten_for_external = ? AND exten_for_ext_pass = ? AND conf_extension = ?"); $updatequery->bind_param("siissss", $vconfDisplayName, $showUsernames, $displayVConfUser, $date, $vconfExtension, $extenPassEnc, $conferenceExt); if ($updatequery->execute()) { $messagetosend = 'The data has been successfully saved to the database !'; } else { $messagetosend = 'Error while saving the data!'; } } $response = array('result' => $messagetosend); echo json_encode($response); } else { header("Location: ../login.php"); } ?>