echo $endDate->format("H:i");
echo "</td>";
echo "</tr>";
}
echo "</table>";
echo "<br />";
$page->addURL("add.php", "Try again.");
echo "<br /><br />";
$page->addURL("index.php", "Return to event schedule.");
exit(0);
}
//no conflicts found. Put the event in the schedule!
$query = "\n\t\tINSERT INTO \n\t\t\tevents(\te_roomID, \n\t\t\t\t\te_dateStart, \n\t\t\t\t\te_dateEnd, \n\t\t\t\t\te_eventName, \n\t\t\t\t\te_color, \n\t\t\t\t\te_eventDesc, \n\t\t\t\t\te_panelist)\n\t\tVALUES \n\t\t\t({$roomID},\n\t\t\t'" . $start->format("Y-m-d H:i:s") . "',\n\t\t\t'" . $end->format("Y-m-d H:i:s") . "',\n\t\t\t'{$name}', \n\t\t\t'{$color}', \n\t\t\t'{$desc}', \n\t\t\t'{$panelist}')\n\t;";
$connection->query($query);
$row = $connection->get_insert_ID();
$eventID = $row[0];
$page->printError("Successfully created event!");
echo "<center>";
$page->addURL("view.php?event={$eventID}", "View Event");
echo "<br />";
$page->addURL("add.php", "Add another Event");
echo "<br />";
$page->addURL("index.php", "Return to main schedule");
echo "</center>";
} else {
$page->printError("Add an event");
echo "<center>";
echo "</center>";
echo "<hr /><hr />";
$page->createEventForm($connection);
}
