<?php
  //connect to MySQL
  $connect\; =\; mysql\_connect("localhost",\; "bp5am",\; "bp5ampass")\; or\; die\; ("Hey\; loser,\; check\; your\; server\; connection.");$//make sure we're using the right database
  mysql_select_db("moviesite");
  
  //insert data into "movie" table
  insert = "INSERT INTO movie (movie_id, movie_name, movie_type, " .
            "movie_year, movie_leadactor, movie_director) " .
            "VALUES (1, 'Bruce Almighty', 5, 2003, 1, 2), " .
            "(2, 'Office Space', 5, 1999, 5, 6), " .
            "(3, 'Grand Canyon', 2, 1991, 4, 3)"; 
  $results\; =\; mysql\_query($insert)
    or die(mysql_error());
  
  //insert data into "movietype" table
  $type\; =\; "INSERT\; INTO\; movietype\; (movietype\_id,\; movietype\_label)\; "\; .\; "VALUES\; (1,\text{'}Sci\; Fi\text{'}),\; "\; .\; "(2,\; \text{'}Drama\text{'}),\; "\; .\; "(3,\; \text{'}Adventure\text{'}),\; "\; .\; "(4,\; \text{'}War\text{'}),\; "\; .\; "(5,\; \text{'}Comedy\text{'}),\; "\; .\; "(6,\; \text{'}Horror\text{'}),\; "\; .\; "(7,\; \text{'}Action\text{'}),\; "\; .\; "(8,\; \text{'}Kids\text{'})"\; ;$results = mysql_query($type)\; or\; die(mysql\_error());$//insert data into "people" table
  people = "INSERT INTO people (people_id, people_fullname, " .
            "people_isactor, people_isdirector) " .
            "VALUES (1, 'Jim Carrey', 1, 0), " .
            "(2, 'Tom Shadyac', 0, 1), " .
            "(3, 'Lawrence Kasdan', 0, 1), " .
            "(4, 'Kevin Kline', 1, 0), " .
            "(5, 'Ron Livingston', 1, 0), " .
            "(6, 'Mike Judge', 0, 1)";
  $results\; =\; mysql\_query($people)
    or die(mysql_error());
  
  echo "Data inserted successfully!";
  ?>