<p class="center-align">
<button class="btn btn-block waves-effect waves-light" type="submit" name="add">Add Venue</button>
</p>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<?php
}
}
if (isset($_POST['edit'])) {
editVenue($_POST['venuename'], $_POST['venuelocation'], $_GET['venueid']);
$_SESSION['edit-venue'] = 'success';
header("location:venue-page.php?page=" . $_GET['page']);
}
if (isset($_POST['delete'])) {
removeVenue($_POST['venuename']);
$_SESSION['delete-venue'] = 'success';
header("location:venue-page.php?page=" . $_GET['page']);
}
if (isset($_POST['add'])) {
addVenue($_POST['venuename'], $_POST['venuelocation']);
$_SESSION['add-venue'] = 'success';
header("location:venue-page.php?page=" . $_GET['page']);
}
?>
<script src="../js/jquery-2.1.1.min.js"></script>
<?php
/*
* To update database when necesary for different version
* Date: 27th March 2015.
*/
require_once '../../../../wp-load.php';
defined('ABSPATH') or die('No script kiddies please!');
require_once ABSPATH . '/wp-admin/includes/upgrade.php';
global $wpdb;
if (isset($_POST)) {
if ($_POST['action'] === "alter") {
switch ($_POST['column']) {
case 'venue':
addVenue();
}
}
}
function addVenue()
{
global $wpdb;
$sql = "ALTER TABLE " . $wpdb->prefix . "a3n_fixture ADD venue varchar(100)";
$wpdb->query($sql);
}
