topical media & game development
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

talk show tell print

basic-php-06-commit-rev01.php / php



  <?php
  // COMMIT ADD
    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 "add":
        switch (_GET['type']) {
          case "movie":
            sql = "INSERT INTO movie
                      (movie_name,
                      movie_year,
                      movie_type,
                      movie_leadactor,
                      movie_director)
                    VALUES
                      ('" . _POST['movie_name'] . "',
                      '" . _POST['movie_year'] . "',
                      '" . _POST['movie_type'] . "',
                      '" . _POST['movie_leadactor'] . "',
                      '" . _POST['movie_director'] . "')";
            break;
        }
        break;
    }
  
    if (isset(sql) && !empty(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
    }
  ?>
[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

(C) Æliens 20/2/2008

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.