<?php
  // COMMIT ADD AND EDITS
    $link\; =\; mysql\_connect("localhost",\; "bp5am",\; "bp5ampass")\; or\; die("Could\; not\; connect:\; "\; .\; mysql\_error());\; mysql\_select\_db(\text{'}moviesite\text{'},$link) 
      or die ( mysql_error()); 
    switch ($\_GET[\text{'}action\text{'}])\; \{\; case\; "edit":\; switch\; ($_GET['type']) {
          case "movie":
            $sql\; =\; "UPDATE\; movie\; SET\; movie\_name\; =\; \text{'}"\; .$_POST['movie_name'] . "',
                      movie_year = '" . $\_POST[\text{'}movie\_year\text{'}]\; .\; "\text{'},\; movie\_type\; =\; \text{'}"\; .$_POST['movie_type'] . "',
                      movie_leadactor = '" .$\_POST[\text{'}movie\_leadactor\text{'}]."\text{'},\; movie\_director\; =\; \text{'}"\; .$_POST['movie_director'] . "'
                    WHERE movie_id = '" . $\_GET[\text{'}id\text{'}]\; .\; "\text{'}";\; break;\; \}\; break;\; case\; "add":\; switch\; ($_GET['type']) {
          case "movie":
            $sql\; =\; "INSERT\; INTO\; movie\; (movie\_name,\; movie\_year,\; movie\_type,\; movie\_leadactor,\; movie\_director)\; VALUES\; (\text{'}"\; .$_POST['movie_name'] . "', 
                      '" . $\_POST[\text{'}movie\_year\text{'}]\; .\; "\text{'},\; \text{'}"\; .$_POST['movie_type'] . "', 
                      '" . $\_POST[\text{'}movie\_leadactor\text{'}]\; .\; "\text{'},\; \text{'}"\; .$_POST['movie_director'] . "')";
            break;
        }
        break;
    }
    if (isset(sql)) {
      echo "<!--" . $sql\; .\; "-->";$result = mysql_query($sql)\; or\; die("Invalid\; query:\; "\; .\; mysql\_error());\; ?>$<p align="center" style="color:#FF0000">
      Done. <a href=<index.php>>Index</a>
    </p>
  <?php
    }
  ?>