$user = "******" . $username . "'";
$eventListingQuery = 'SELECT pmkHostNetId, pmkDate, pmkTimeStart, fldTitle, fnkActivity,
fldHostName, fnkCity, fnkState, fldTimeEnd, fldMaxParticipants,
fldCurrParticipants, fldDescription
FROM tblEvents
WHERE fldViewable = true
';
// execute query
//$data = $thisDatabaseReader->testquery($eventListingQuery, "", 1, 0, 0, 0, false, false);
$eventListingData = $thisDatabaseReader->select($eventListingQuery, "", 1, 0, 0, 0, false, false);
print '<div class="listings">';
print '<div id="eventListings">';
// display query results
$i = 0;
foreach ($eventListingData as $entry) {
printEventListing($entry, $i, !userIsHost($user, false, $entry));
$numEventListings = $i;
$i++;
}
print '</div>';
/*
$i = 0;
for($i = 0; $i < $numEventListings; $i++) {
if(isset($_POST['delete'.$i])) {
print 'deleted event '.$i. ' in the list.';
$deleteQuery = 'DELETE ' . $eventListingData[$i]["pmkHostNetId"] . ''.
$eventListingData[$i]["pmkTimeStart"].
$eventListingData[$i]["pmkDate"];
}
$i++;
}
ORDER BY pmkDate';
//$userCreatedEventsQuery = $thisDatabaseReader->testquery($query, "", 1, 1, 4, 0, false, false);
$userCreatedEventsData = $thisDatabaseReader->select($query, "", 1, 1, 4, 0, false, false);
if ($userCreatedEventsData == null) {
print '<h2>You do not have any events currently planned</h2>';
} else {
print '<h2>Events you posted:</h2>';
$singleQuote = "'";
// displays users' created events
$i = 0;
foreach ($userCreatedEventsData as $eventListing) {
// for diagnosing delete event query ONLY.
$deleteEventQuery = 'SELECT * FROM tblEvents WHERE ' . 'pmkHostNetId LIKE ' . $singleQuote . '%' . trim($username, "'") . '%' . $singleQuote . ' AND ' . 'pmkDate LIKE ' . $singleQuote . '%' . $eventListing["pmkDate"] . '%' . $singleQuote . ' AND ' . 'pmkTimeStart LIKE ' . $singleQuote . '%' . trim($eventListing["pmkTimeStart"], "'") . '%' . $singleQuote . ' AND ' . 'fnkActivity LIKE ' . $singleQuote . '%' . trim($eventListing["fnkActivity"], "'") . '%' . $singleQuote . ' AND ' . 'fldTitle LIKE ' . $singleQuote . '%' . trim($eventListing["fldTitle"], "'") . '%' . $singleQuote;
//print_r($deleteEventQuery);
$thisDatabaseWriter->testquery($deleteEventQuery, "", 1, 4, 10, 0, false, false);
printEventListing($eventListing, $i, !userIsHost($user, false, $eventListing));
$numEventListings = $i;
$i++;
}
}
/*
$i = 0;
for($i = 0; $i < $numEventListings; $i++) {
if(isset($_POST['delete'.$i])) {
$deleteQuery = 'DELETE ' . $eventListingData[$i]["pmkHostNetId"] . ''.
$eventListingData[$i]["pmkTimeStart"].
$eventListingData[$i]["pmkDate"];
}
$i++;
}
*/
