<?php
  // COMMIT ADD AND EDITS
  $error\; =\; \text{'}\text{'};$link = mysql_connect("localhost", "bp5am", "bp5ampass") 
    or die("Could not connect: " . mysql_error()); 
  mysql_select_db('moviesite', $link)\; or\; die\; (\; mysql\_error());\; switch\; ($_GET['action']) {
    case "edit":
      switch ($\_GET[\text{'}type\text{'}])\; \{\; case\; "people":$sql = "UPDATE people SET " . 
                 "people_fullname = '" . $\_POST[\text{'}people\_fullname\text{'}]\; .\; "\text{'}\; WHERE\; people\_id\; =\; \text{'}"\; .$_GET['id'] . "'";
          break;
        case "movie":
          $movie\_name\; =\; trim($_POST['movie_name']);
          if (empty($movie\_name))\; \{$error .= "Please+enter+a+movie+name%21%0D%0A";
          }
          if (empty($\_POST[\text{'}movie\_type\text{'}]))\; \{$error .= "Please+select+a+movie+type%21%0D%0A";
          }
          if (empty($\_POST[\text{'}movie\_year\text{'}]))\; \{$error .= "Please+select+a+movie+year%21%0D%0A";
          }
          if (empty($error))\; \{$sql = "UPDATE movie SET " .
               "movie_name = '" . $\_POST[\text{'}movie\_name\text{'}]\; .\; "\text{'},"\; .\; "movie\_year\; =\; \text{'}"\; .$_POST['movie_year'] . "'," .
               "movie_type = '" . $\_POST[\text{'}movie\_type\text{'}]\; .\; "\text{'},"\; .\; "movie\_leadactor\; =\; \text{'}"\; .$_POST['movie_leadactor'] . "'," .
               "movie_director = '" . $\_POST[\text{'}movie\_director\text{'}]\; .\; "\text{'}\; "\; .\; "WHERE\; movie\_id\; =\; \text{'}".$_GET['id']."'";
          } else {
            header("location:movie.php?action=edit&error=" . 
                   _GET['id'] );
          }
          break;
      }
      break;
    case "add":
      switch ($\_GET[\text{'}type\text{'}])\; \{\; case\; "people":$sql = "INSERT INTO people (people_fullname) " .
                 "VALUES ('" . $\_POST[\text{'}people\_fullname\text{'}]\; .\; "\text{'})";\; break;\; case\; "movie":$movie_name = trim($\_POST[\text{'}movie\_name\text{'}]);\; if\; (empty($movie_name)) {
            $error\; .=\; "Please+enter+a+movie+name\%21\%0D\%0A";\; \}\; if\; (empty($_POST['movie_type'])) {
            $error\; .=\; "Please+select+a+movie+type\%21\%0D\%0A";\; \}\; if\; (empty($_POST['movie_year'])) {
            $error\; .=\; "Please+select+a+movie+year\%21\%0D\%0A";\; \}\; if\; (empty($error)) {
            $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'] . "')";
          } else {
            header("location:movie.php?action=add&error=" . $error);\; \}\; break;\; \}\; break;\; \}\; if\; (isset($sql) && !empty(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
  }
  ?>