<?php
//connect to MySQL

$db = mysql_connect ('localhost', 'root', '') or
	die('Unable to connect. Check your connection parameters.');

//make sure our recently created datbase is the active one 
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//insert data into the movie table
$query = '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)';
mysql_query($query, $db) or die (mysql_error($db));

//insert data into movietype table
$query = 'INSERT INTO movietype
	(movietype_id, movietype_label)
	
	VALUES
	(1, "SCI FI"),
	(2, "Drama"),
	(3, "Adventure"),
	(4, "War"),
	(5, "Comedy"),
	(6, "Horror"),
	(7, "Action"),
	(8, "Kids"")';
mysql_query($query, $db) or die (mysql_error($db));

//insert data into people table
$query = 'INSERT INTO people
	(people_id, people_fullname, people_isactor, people_isdirector)
	VALUES
	(1, "Jim Carey", 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)';
mysql_query($query, $db) or die (mysql_error($db));

echo 'Data inserted succcessfully!';
?>