query("SELECT id, username, enabled FROM app_users WHERE BINARY username = '$username' AND enabled = 1"); $queryres = $query1->fetch_array(); $userID = $queryres[0]; // Update the contact profile picture $query2 = $mysqli->prepare("UPDATE contacts SET profile_picture_c=? WHERE user_id=? AND contact_name=?"); $query2->bind_param("sis", $profilePicture, $userID, $contactName); if ($query2->execute()) { $messagetosend = 'success'; } else { $messagetosend = 'failure'; } $response = array('result' => $messagetosend); echo json_encode($response); } else { header("Location: roundpin-login.php"); } ?>