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>