I have been trying to grasp the concepts involved in creating databases in MySQL with PHP. I have a written a script to create a database containing 2 tables. I know I'm new, but it looks like I'm doing everything correctly:
Code: Select all
<?php
//Connect to MySQL
$connect = mysql_connect("localhost", "root", "MyPaSsWoRd") or
die ("Access Denied- http://www.Digital-Syndicate.org")
//create main database.
mysql_create_db("wiley")
or die(mysql_error());
//make sure our recently created database is the active one
mysql_select_db ("wiley");
//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)
) TYPE=MyISAM AUTO_INCREMENT=4 ";
$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)
) TYPE=MyISAM AUTO_INCREMENT=7";
$results = mysql_query($people)
or die(mysql_error());
echo "Movie Database Successfully Created!";
?>Code: Select all
Parse error: syntax error, unexpected T_STRING in /var/www/createmovie.php on line 7