$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'];
