$data['isCreator'] = 0; if (isset($postData['code']) && !empty($postData['code']) && isset($postData['userCode']) && !empty($postData['userCode'])) { $code = $postData['code']; $userCode = $postData['userCode']; $query = "SELECT * FROM event WHERE code='" . mysqli_real_escape_string($connection, $code) . "'"; $result = mysqli_query($connection, $query); if ($result && mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_array($result)) { $users = getAllUsers($row['id']); if ($users) { $data['data'] = array(); foreach ($users as $user) { if ($user['code'] == $userCode && $user['is_creator'] == 1) { $data['isCreator'] = 1; } $datesByUser = getDatesByUser($user['id']); if ($datesByUser) { $data['data'][] = array('user' => array('id' => $user['id'], 'name' => $user['name'], 'email' => $user['email']), 'dates' => $datesByUser); } } } } $data['result'] = true; } } function getDatesByUser($userId) { global $connection; $dates = array(); $query = "SELECT \n\t\t\t\ted.*,\n\t\t\t\ted.id as dateId,\n\t\t\t\tduc.event_date_id,\n\t\t\t\tduc.user_id,\n\t\t\t\tduc.choice,\n\t\t\t\tduc.id as choiceId \n\t\t\tFROM \n\t\t\t\tevent_date as ed,\n\t\t\t\tdate_userchoice as duc\n\t\t\tWHERE \n\t\t\t\tduc.user_id = '" . mysqli_real_escape_string($connection, $userId) . "'\n\t\t\tAND\n\t\t\t\ted.id = duc.event_date_id"; $result = mysqli_query($connection, $query);
require_once 'connect.php'; $post = file_get_contents("php://input"); $postData = json_decode($post, true); $data['result'] = false; $data['postData'] = $postData; if (isset($postData['code']) && !empty($postData['code']) && isset($postData['userCode']) && !empty($postData['userCode'])) { $code = $postData['code']; $query = "SELECT * FROM event WHERE code='" . mysqli_real_escape_string($connection, $code) . "'"; $result = mysqli_query($connection, $query); if ($result && mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_array($result)) { $currentUser = getUser($postData['userCode']); $creator = getCreator($row['id']); if (count($currentUser) > 0) { $chosenDates = getDatesByUser($currentUser['id']); $data['data'][] = array('id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'location' => $row['location'], 'code' => $row['code'], 'creator_name' => $creator['name'], 'creator_email' => $creator['email'], 'creation_date' => translateMonth(date('d F Y', strtotime($row['creation_date']))), 'creation_time' => date('H:i', strtotime($row['creation_date'])), 'dates' => $chosenDates, 'isCreator' => $currentUser['is_creator'], 'users' => getAllUsers($row['id'])); } } $data['result'] = true; } } function getUser($userCode) { global $connection; $query = "SELECT * FROM event_user WHERE code='" . mysqli_real_escape_string($connection, $userCode) . "'"; $result = mysqli_query($connection, $query); $user = array(); if ($result && mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_array($result)) { $user['name'] = $row['name'];