background-size: cover;
}*/
</style>
</head>
<body>
<?php
if (isset($_POST['submit'])) {
$ur = new Database();
$ur->db_connect();
$link = $_REQUEST['link'];
$link = !empty($link) ? '"' . $link . '"' : "NULL";
$timestamp = strtotime($_REQUEST['when']);
$datetime = "'" . date("Y-m-d H:i:s", $timestamp) . "'";
$insert_query = 'INSERT INTO free_food_events VALUES (DEFAULT, ' . $datetime . ', "' . $_REQUEST['where'] . '", "' . $_REQUEST['host'] . '", "' . $_REQUEST['description'] . '", ' . $link . ');';
$result = $ur->do_query($insert_query);
//print $insert_query;
print '<h1><center>Successfully Submitted!</center></h1><br><br>';
print '<a href="index.php">Calendar</a><br>';
print '<a href="event_submit_form.php">Submit another event</a>';
} else {
print '<h1><center>Free Food Event Form</center></h1>';
print '<form method="POST" name="event_form" onsubmit="return validateForm()">';
print ' <table class="DA">';
print ' <tr><td><span style="color:red;font-size:75%;">*Required Fields</span></td></tr>';
print ' <tr><td><span style="color:red;">*</span>Organization Name:<br>';
print ' <input type="text" name="host">';
print ' </td></tr>';
print ' <tr><td><span style="color:red;">*</span>Where:<br>';
print ' <input type="text" name="where">';
print ' </td></tr>';
function createTable($current_date)
{
print '<table cellspacing="0" class="food_table">';
$ur = new Database();
$ur->db_connect();
$dateformat = $current_date->format('Y-m-d');
$query = "SELECT * FROM free_food_events WHERE '{$dateformat}' = date(event_when) ORDER BY event_when;";
$result = $ur->do_query($query);
$counter = 0;
while ($row = mysqli_fetch_array($result)) {
print '<tr><td onclick="document.getElementById(\'detail_view' . $counter . '\').style.display=\'block\';document.getElementById(\'fade\').style.display=\'block\'">';
print '<table style="width:100%;">';
print '<tr><td class="event_time" rowspan="2">' . date('g:ia', strtotime($row['event_when'])) . '</td>';
print '<td class="event_detail">' . $row['event_host'] . '</td></tr>';
print '<tr><td class="event_detail">' . $row['event_where'] . '</td></tr>';
print '</table>';
//print $row['event_host'];
//print '<br>';
//print $row['event_where'];
//print '<br>';
//print date('g:i a', strtotime($row['event_when']));
print '</td></tr>';
createDetailView($counter, $row);
$counter++;
}
if ($counter == 0) {
print '<tr><td>No free food today :(</td></tr>';
}
print '</table>';
//return
}
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<?php
session_start();
require_once 'Database.php';
?>
<html>
<head>
<meta charset="UTF-8">
<title>UR Hungry</title>
</head>
<body>
<?php
echo "Hi! Blah blah!";
print '<a href="event_submit_form.php">click me!</a>';
echo '<br />';
$ur = new Database();
$ur->db_connect();
$result = $ur->do_query('SELECT * FROM free_food_events');
while ($row = mysqli_fetch_array($result)) {
print $row['event_where'];
print '<br />';
}
?>
</body>
</html>
