} array_push($orgnumberlist, $orgrow['orgnumber']); $eventlist = array(); $eventrowarray = array(); $eventQuery = 'SELECT * FROM `event` WHERE `orgnumber`=' . $orgrow['orgnumber']; if ($eventresults = mysqli_query($link, $eventQuery, MYSQLI_USE_RESULT)) { while ($eventrow = mysqli_fetch_array($eventresults)) { array_push($eventrowarray, $eventrow); } } $eventlist = convertEventRows($eventrowarray); $tmporg = array('name' => $orgrow['orgname'], 'orgNumber' => (int) $orgrow['orgnumber'], 'subscribed' => $subscribed, 'description' => $orgrow['description'], 'contact' => $orgrow['contact'], 'eventList' => $eventlist); array_push($orglist, $tmporg); } mysqli_close($link); $json_to_send = $orglist; } elseif (strcmp($queryType, "myEvents") == 0) { $json_to_send = convertEventRows($results); } elseif (strcmp($queryType, "terms") == 0) { $termlist = array(); foreach ($results as $termrow) { $tmpterm = array('termID' => $termrow['termID']); array_push($termlist, $tmpterm); } $json_to_send = $termlist; } echo json_encode($json_to_send); } else { echo 'Error'; } }
if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit; } $query = 'INSERT INTO `event`(`eventname`, `orgnumber`, `location`, `days`, `description`, `startyear`, `startmonth`, `startdayofmonth`, `endyear`, `endmonth`, `enddayofmonth`, `starthour`, `startminute`, `endhour`, `endminute`) VALUES (\'' . $eventname . '\',' . $orgnumber . ', \'' . $location . '\', \'' . $days . '\', \'' . $description . '\',' . $startyear . ',' . $startmonth . ',' . $startdayofmonth . ',' . $endyear . ',' . $endmonth . ',' . $enddayofmonth . ',' . $starthour . ',' . $startminute . ',' . $endhour . ',' . $endminute . ')'; //Database query if (mysqli_query($link, $query)) { require_once 'sendAndroidNotification.php'; require_once 'queryDatabaseHelper.php'; $getEventQuery = 'SELECT * FROM `event` WHERE `eventname`=\'' . $eventname . '\' AND `orgnumber`=' . $orgnumber . ' AND `location`=\'' . $location . '\' AND `days`=\'' . $days . '\' AND `description`=\'' . $description . '\' AND `startyear`=' . $startyear . ' AND `startmonth`=' . $startmonth . ' AND `startdayofmonth`=' . $startdayofmonth . ' AND `endyear`=' . $endyear . ' AND `endmonth`=' . $endmonth . ' AND `enddayofmonth`=' . $enddayofmonth . ' AND `starthour`=' . $starthour . ' AND `startminute`=' . $startminute . ' AND `endhour`=' . $endhour . ' AND `endminute`=' . $endminute; if ($res = mysqli_query($link, $getEventQuery)) { $eventarr = array(); $tmprow = mysqli_fetch_array($res); $num = $tmprow['eventnumber']; array_push($eventarr, $tmprow); $convertedevents = convertEventRows($eventarr); $registrationIDs = array(); // $usernames = array(); $subquery = 'SELECT `username` FROM `subscription` WHERE `orgnumber`=' . $orgnumber; if ($subres = mysqli_query($link, $subquery)) { while ($subrow = mysqli_fetch_array($subres)) { $devicequery = 'SELECT * FROM `androiddevice` INNER JOIN `subscription` ON AndroidDevice.username=Subscription.username WHERE \'' . $subrow['username'] . '\'=Subscription.username AND ' . $orgnumber . '=Subscription.orgnumber'; if ($regres = mysqli_query($link, $devicequery)) { while ($regrow = mysqli_fetch_array($regres)) { array_push($registrationIDs, $regrow['device_id']); // array_push($usernames, $regrow['username']); $insquery = 'INSERT IGNORE INTO `rsvp`(`username`, `eventnumber`) VALUES (\'' . $regrow['username'] . '\',' . $num . ')'; echo $insquery;