I'm still missing something simple, I'm sure!

Carlo_Gambino

Hello again!

I took a break from this project because I was overlooking little things. Now that I've come back to it, I decided to play with the SQL databases available to me through a hosted site I bought in order to learn. I also was able to set up the tables for my project correctly (I think).

Now I am trying to understand how to populate my tables. So far, I have the following:

<?
//connect to MySQL
$con = mysql_connect('HOST','USER','PASSWORD') or
	die ("ERROR");

//Select Database
mysql_select_db('movie', $con)

//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)";
$result=mysql_query($insert)
	or die(mysql_error());

//insert data into "movietype" table
$type="INSERT INTO movietype (movietype_id, movietype_label)
	VALUES (1, 'SciFi'),
	(2, 'Drama'),
	(3, 'Adventure'),
	(4, 'War'),
	(5, 'Comedy'),
	(6, 'Horror'), 
	(7, 'Action'), 
	(8, 'Kids')";
$result=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 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)";
$result=mysql_query($people)
	or die(mysql_error());

echo "Data inserted successfully!"
?>

However, upon running this code in my browser I get the following error:

Parse error: parse error, unexpected T_STRING in /home/content/a/d/v/USER/html/moviedata.php on line 31

which is this line, if I am counting correctly:

$people="INSERT INTO people (...

Please help me understand what I'm doing wrong!

djjjozsi

mysql_select_db('movie', $con)

<------------- you missed a ;

echo "Data inserted successfully!"

<-------------you missed a ;

hello,jjozsi

Carlo_Gambino

djjjozsi,

thank you for your reply!

I changed the php tags as you suggested, as well as adding the ";" where indicated. However, I am still getting this same error:

Parse error: parse error, unexpected T_STRING in /home/content/a/d/v/USER/html/moviedata.php on line 31

I've looked over the syntax and I feel like I'm catching on, but apparently I'm still missing something. Any input is appreciated.

djjjozsi

Hy, this code is working,
(but change the database conncection from mine)

and here is how its made 🙂
http://phptool.extra.hu/tutorials/troubleshooting_113/troubleshooting_113.html

<?php
	//connect to MySQL
	$con = mysql_connect('localhost','test','test') or
		die ("ERROR");

//Select Database
mysql_select_db('test', $con);

//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)";
$result=mysql_query($insert)
	or die(mysql_error());

//insert data into "movietype" table
$type="INSERT INTO movietype (movietype_id, movietype_label)
VALUES (1, 'SciFi'),
(2, 'Drama'),
(3, 'Adventure'),
(4, 'War'),
(5, 'Comedy'),
(6, 'Horror'),
(7, 'Action'),
(8, 'Kids')";
$result=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 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)";
$result=mysql_query($people)
	or die(mysql_error());

echo "Data inserted successfully!"
?>

hello,

jjozsi

Carlo_Gambino

Wow!

Thanks for the reply. I have to admit, that was the most awesome reply I've ever gotten in any forum I've ever visited! That Camtasia program looks like a great product- I wish I could justify paying the price for a toy!

Anyway, I have to be honest and say my jaw dropped and I was simply stunned by the tutorial that I really didn't follow it closely. Unfortunately, I need to wrap some presents for the kids so it won't be until Friday or Sunday before I can actually play with this more.

A million thanks for your input, and even more for the beautiful tutorial- and extra bonus points for picking my favorite Christmas song for the background!

djjjozsi

"didn't follow it closely"

its not a full tutorial, it just shows the steps.

Yes, i really like this program , and song 🙂

Marry Christmas.

Carlo_Gambino

Hello!

I hope you've had a great holiday! I wanted to thank you again for your input this far. I took some time to play with this a bit today, and it's been quite an education! I started from the beginning and followed the steps, and I really thought I was on to something. It makes sense, from using that awesome code generator (although it would be nice to know what the radio buttons mean), to creating the tables in PHPMyAdmin, even to clearing the tables in order to run moviedata.php, but I continue to get this error:

Parse error: parse error, unexpected T_STRING in /home/content/a/d/v/adv0c4t3/html/moviedata.php on line 31

I continued to scrutinize the code, hoping not to have to ask for more help on this topic, but I don't see anything wrong with it. I compared my code to what you have in your last post, and I don't see any issues on or around this area. I even got a text editor that supports line numbers so I could be sure I was counting correctly. Here is a 7 line block copied from the text file I'm working with:

28  $result=mysql_query($type)
29        or die(mysql_error());
30
31  //insert data into "people" table
32  $people="INSERT INTO people (people_id, people_fullname, people_isactor, 33  people_isdirector)
34  VALUES (1, 'Jim Carey', 1,0),
35  (2, 'Tom Shadyac', 0, 1),

Seeing that line 31 is the error, I presume line 30 to contain the issue. Since this line is blank, I'm looking at line 29. This line looks fine to me. To be sure I compare this line to similar lines in the code (15-16 and 39-40), and those look the same to me as well.

What more can I be missing?!

bradgrafelman

Can you post the entire code you used that caused this error?

djjjozsi

That's interesting. As bradgrafelman asked its a good idea to post the code what you really used.

As you can see in the video, the posted code is working, somehow
your code editor create a wrong output (change the character code, or try to
save as with another php editor).
And make sure that your php editor does not leave the line's number in the php file.

And about the code generator:
i'm planning the translation of these radio buttons, but first i want to finish a complicated module for it
(search engine generator, and database table listing using ABC(style) links )
As a matter a fact, you can make database tables and generate its SQL code,
on the site you can find a video in "project admin", but more functions you can find it the actual state.

Hello,
jjozsi

Carlo_Gambino

Gentlemen,

Thank you both for your insight in this problem. As I woke, I saw your posts, and decided to try from scratch so I could emulate the tutorial from step one and go from there.

Creating and populating the tables via PHPAdmin works just fine, I was able to see the data by clicking on the "Browse" tab but continue to get the same error when calling moviedata.php from my browser! Here is my complete code:

<?php
    //connect to MySQL
    $con = mysql_connect('HOST','USER','PASSWORD') or
        die ("ERROR");

//Select Database
mysql_select_db('test', $con);

//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)";
$result=mysql_query($insert)
    or die(mysql_error());

//insert data into "movietype" table
$type="INSERT INTO movietype (movietype_id, movietype_label)
VALUES (1, 'SciFi'),
(2, 'Drama'),
(3, 'Adventure'),
(4, 'War'),
(5, 'Comedy'),
(6, 'Horror'),
(7, 'Action'),
(8, 'Kids')";
$result=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 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)";
$result=mysql_query($people)
    or die(mysql_error());

echo "Data inserted successfully!"
?>

After mine was not working, I decided to copy and try yours, still no luck- same exact error. Thanks in advance for your help!

djjjozsi

Hello,

once you run this .php, its not workint till you delete the data from the tables,
and that is true for the runned sql query in phpmyadmin.
As you can see, ID has set as primary key. So, that may cause duplicate entry error.

In the video, maybe its hard to see the "empty table", but its there.

So for that reason, if you hardcode the table create and data insert,
be sure you delete the existing entries ( truncate table_name ).

And the database name should change in the code to works.

Hello,
jjozsi.

Carlo_Gambino

I thought that was the issue, but I had no problem locating the "Empty" button, at which point I got the alert box asking if I was sure I wanted to truncate the table, and I clicked "OK".

Still no luck. The same error on line 31. I went one step further and moved the project from my home server to a site hosted by godaddy- in case there was a config conflict I was overlooking.

I don't know what else to do.