Example #1
0
    } else {
        $date = $_POST['date'];
        $artist = $_POST['artist'];
        $band_pic_url = $_POST['band_pic_url'];
        $band_url = $_POST['band_url'];
        $venue = $_POST['venue'];
        $ticketinfo = $_POST['ticketinfo'];
        $ticketurl = $_POST['ticketurl'];
        $featured = $_POST['featured'];
        if (!$date || !$artist || !$venue || !$ticketinfo || !$ticketurl) {
            echo '<div class="top-spacer_20 center error">Error - missing required value(s)</div>';
        } else {
            $result = update_concert($id, $date, $artist, $band_pic_url, $band_url, $venue, $ticketinfo, $ticketurl, $featured);
            if ($result) {
                echo '<div class="top-spacer_20 center"><h1>Update was successful!</h1>';
                display_concert(get_concert($id));
                echo "</div>";
            }
        }
    }
    ?>
    <div class="top-spacer_20">
      <a href="concert_view_all.php">Vie wall Concerts</a>
      <p>
      <a href="cp.php">Control Panel</a>
    </div>
  </div>
</div> <!-- end of row div -->
<?php 
}
require "partials/_footer.php";
Example #2
0
function view_all_concerts()
{
    $query = "SELECT * FROM concerts WHERE deleted = 'n' AND date >= date(now()) ORDER BY date";
    $result = mysql_query($query);
    if (!$result) {
        echo "error: " . $query;
        die('Invalid');
    }
    echo '<ol>';
    for ($i = 1; $i <= mysql_num_rows($result); $i++) {
        $info = mysql_fetch_assoc($result);
        display_concert($info);
        echo '<br>[ <a href="concert_update.php?id=' . $info[id] . '">Edit</a> | <a href="concert_delete.php?id=' . $info[id] . '">Delete</a> ] <p>';
    }
    echo '</ol>';
}