示例#1
0
        require "partials/_mrm_band_form.php";
        echo "</form>\n        <div class=\"footnote\">** if any links are over 128 characters: use <a href=\"http://www.bit.ly\" target=_new>bit.ly</a> to shorten the url</div>";
    } else {
        $name = $_POST['name'];
        $url = $_POST['url'];
        $pic_url = $_POST['pic_url'];
        $placement = $_POST['placement'];
        $seed = $_POST['seed'];
        $abbr = $_POST['abbr'];
        if (!$name || !$url || !$pic_url || !$placement || !$seed || !$abbr) {
            echo '<div class="top-spacer_20 center error">Error - missing required value(s)</div>';
        } else {
            $result = update_mrm_band($id, $name, $url, $pic_url, $placement, $seed, $abbr);
            if ($result) {
                echo '<div class="top-spacer_20 center"><h1>Update was successful!</h1>';
                display_mrm_band(get_mrm_band($id));
                echo "</div>";
            }
        }
    }
    ?>
    <div class="top-spacer_20">
      <a href="mrm_view_all.php">View all Modern Rock Madness Bands</a>
      <p>
      <a href="cp.php">Control Panel</a>
    </div>
  </div>
</div> <!-- end of row div -->
<?php 
}
require "partials/_footer.php";
示例#2
0
function view_all_mrm_bands()
{
    $query = "SELECT * FROM mrm_bands ORDER BY Placement";
    $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_mrm_band($info);
        echo '<br>[ <a href="mrm_band_update.php?id=' . $info["id"] . '">Edit</a> | <a href="mrm_band_delete.php?id=' . $info["id"] . '">Delete</a> ] <p>';
    }
    echo '</ol>';
}