Setting up createmovie.php, moviedata.php

ephemera · February 2nd, 2009, 02:57 PM

I finally got my MySQL to work with PHP, but anyway, I'm on the third chapter, setting up the movie database.

When I run createmovie.php I have success. However, when I go to moviedata.php, I get the error: Duplicate entry '1' for key 'PRIMARY'

Any clue what is causing this? The code looks like:

HTML Code:

<?php

$link = mysql_connect('localhost', 'root');
if (!$link) {
    die('Not connected : ' . mysql_error());
}
//select database
mysql_select_db("wiley");

//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, 'Sci Fi'),
    (2, 'Drama'),
    (3, 'Adventure'),
    (4, 'War'),
    (5, 'Comedy'),
    (6, 'Horror'),
    (7, 'Action'),
    (8, 'Kids')" ;
$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 Livington', 1, 0),
  (6, 'Mike Judge', 0, 1)";
$results=mysql_query($people)
    or die(mysql_error());
    
echo "Data inserted successfully!";
?>

goodboy · November 23rd, 2009, 03:11 PM

i have the same Problem did u figer out what was the problem
finally got my MySQL to work with PHP, but anyway, I'm on the third chapter, setting up the movie database.

When I run createmovie.php I have success. However, when I go to moviedata.php, I get the error: Duplicate entry '1' for key 'PRIMARY'

Any clue what is causing this? The code looks like:
HTML Code:
<?php

$link = mysql_connect('localhost', 'root');
if (!$link) {
die('Not connected : ' . mysql_error());
}
//select database
mysql_select_db("wiley");

//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, 'Sci Fi'),
(2, 'Drama'),
(3, 'Adventure'),
(4, 'War'),
(5, 'Comedy'),
(6, 'Horror'),
(7, 'Action'),
(8, 'Kids')" ;
$results=mysql_query($type)
or die(mysql_error());

//insert data into "people" table

Andrew M. · December 28th, 2009, 01:24 PM

ephemera-

at the top of your code where it reads:

Code:

$link = mysql_connect('localhost', 'root');

change it to this:

Code:

$link = mysql_connect('localhost', 'root', "");

when attempting to connect to a MySQL database you need to provide
3 things: [server][user][password] ( "" indicates no password)

goodboy-

when you get errors like " Duplicate entry '1' for key 'PRIMARY'"
that indicates that some of the code ran but with errors. You need to clear the tables that were created by delving into MySQL via the DOS prompt.
I used the xampp download from apachefriends so the following gets me to MySQL on my computer:

CHDIR C:\xampp
c:xampp>mysql\bin\mysql -h localhost -u root

This gets you to the mysql> prompt, once there enter the following:
SHOW DATABASES; (to see what's there)
USE moviesite; (the database for the first project in this book)
SHOW TABLES; (show all the tables made)
DROP TABLE movie;
DROP TABLE movietype;
DROP TABLE people; (drop these tables to clear them)

then run createmovie.php and moviedata.php again.