<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); }