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