Hi
I am in chapter 5 of php, apache mysql web development book. I am in the sql coding part, I did as says in the book but I am getting error when connecting to the server. I created a database, user, pass in my server. I am getting error. please advise
Access denied for user 'user@'localhost' to database 'movie'
<?php
//connect to MYSQL; note we have used our wone parameters- you shoud used your own
// for hostname , user, pass.
$connect = mysql_connect("localhost", "user", "pass") or
die ("hey loser check your server information");
// create datebase if it doesn't alrady exist.
$create = mysql_query("CREATE DATABASE IF NOT EXISTS movie")
or die(mysql_error());
//make sure our recently created datbase is active one
mysql_select_db("movie");
//create "movie" table
$movie = "CREATE TABLE movie (
movie_id int(11) NOT NULL auto_increment,
movie_name verchar(255) NOT NULL,
movie_type tinyEint(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_table varchar(100) NOT NULL,
PRIMARY KEY (movietype_id)
)";
$results = mysql_query($movietype)
or die(mysql_error());
$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";
?>
