prepare("SELECT id, username, enabled FROM app_users WHERE BINARY username = ? AND enabled = ?"); $queryid->bind_param("si", $username, $enabled); $queryid->execute(); $queryres = $queryid->get_result()->fetch_assoc(); $userID = $queryres['id']; // Remove the contact from the 'contacts' table $querycont = $mysqli->prepare("DELETE FROM contacts WHERE user_id = ? AND contact_name = ?"); $querycont->bind_param("ss", $userID, $contactName); $querycont->execute(); if ($querycont) { $message = 'success'; } else { $message = 'failure'; } $delresult = ['removeresult' => $message]; echo json_encode($delresult); } else { header("Location: ../login.php"); } ?>