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-03-createmovie.php / php



  <?php
  //connect to MySQL; note we’ve used our own parameters- you should use
  //your own for hostname, user, and password
  connect = mysql_connect("localhost", "bp5am", "bp5ampass") or 
       die ("Hey loser, check your server connection.");
  
  //create the main database if it doesn't already exist
  create = mysql_query("CREATE DATABASE IF NOT EXISTS moviesite")
    or die(mysql_error());
  
  //make sure our recently created database is the active one
  mysql_select_db("moviesite");
  
  //create "movie" table
  movie = "CREATE TABLE movie (
    movie_id int(11) NOT NULL auto_increment, 
    movie_name varchar(255) NOT NULL, 
    movie_type tinyint(2) NOT NULL default 0, 
    movie_year int(4) NOT NULL default 0, 
    movie_leadactor int(11) NOT NULL default 0, 
    movie_director int(11) NOT NULL default 0, 
    PRIMARY KEY  (movie_id), 
    KEY movie_type (movie_type,movie_year) 
  )";
  
  results = mysql_query(movie)
    or die (mysql_error());
  
  //create "movietype" table
  movietype = "CREATE TABLE movietype ( 
    movietype_id int(11) NOT NULL auto_increment, 
    movietype_label varchar(100) NOT NULL, 
    PRIMARY KEY  (movietype_id) 
  )"; 
  
  results = mysql_query(movietype)
    or die(mysql_error());
  
  //create "people" table
  people = "CREATE TABLE people ( 
    people_id int(11) NOT NULL auto_increment, 
    people_fullname varchar(255) NOT NULL, 
    people_isactor tinyint(1) NOT NULL default 0, 
    people_isdirector tinyint(1) NOT NULL default 0, 
    PRIMARY KEY  (people_id) 
  )"; 
  
  results = mysql_query(people)
    or die(mysql_error());
  
  echo "Movie Database successfully created!";
  
  ?>
[] 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.