prepare("SELECT id, username FROM app_users WHERE BINARY username = ?"); $query1->bind_param("s", $username); $query1->execute(); $queryres = $query1->get_result()->fetch_assoc(); $userID = $queryres['id']; $dateModified = date("Y-m-d H:i:s"); // Update the contact profile picture $query2 = $mysqli->prepare("UPDATE contacts SET profile_picture_c = ?, date_modified = ? WHERE user_id = ? AND contact_name = ?"); $query2->bind_param("ssis", $profilePicture, $dateModified, $userID, $contactName); if ($query2->execute()) { $messagetosend = 'success'; } else { $messagetosend = 'failure'; } $response = array('result' => $messagetosend); echo json_encode($response); } else { header("Location: ../login.php"); } ?>