Jump to content

Archived

This topic is now archived and is closed to further replies.

Inverno

Nothing will print..

Recommended Posts

I'm new to php (and coding in general), as my code should make apparent. However I'm pretty sure at least the code outside of my <?php tag should be working, but it's not. Also, the php isn't doing anything either; no die messages display, no changes to the database are made. Can someone tell me where I've messed up?
[code]<head>
<title>Movie Added</title>
</head>
<body>
<p>
test
</p>
<?php

//define variables
$mdesc = $_POST['mdescription'];
$mname = $_POST['mname'];
$genre = $_POST['genre'];
$rating = $_POST['rating'];
$dlast = $_POST['dlastname'];
$dfirst = $_POST['dfirstname'];
$alast = $_POST['alastname'];
$afirst = $_POST['afirstname'];


//connect to server
$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

//open database
mysql_select_db("dbname", $con) or die("no db found");

//the movie script

//add movie info to table
$query="INSERT INTO movie (name, genre, description) VALUES ("$mname", "$genre", "$mdesc")"
or die('Error!' . mysql_error());
mysql_query($query);

//the director script

//add director info to table
$query1="INSERT INTO director (lastname, firstname) VALUES ("$dlast", "$dfirst")" or die("Error!");

mysql_query($query1);

//the actor script

//add actor info to table
$check= if (mysql_query("SELECT actor.firstname, actor.lastname
FROM actor
WHERE actor.lastname="$alast"
AND  actor.firstname="$afirst"");
else mysql_query("INSERT INTO actor (lastname, firstname)
VALUES ("$alast", "$afirst")");

/* possibly improved on?
$query="INSERT INTO actor (lastname, firstname) VALUES (\"$_POST[alastname]\",\"$_POST[afirstname]\")"
*/

mysql_query($check);

//the rating script

//define movieid
$result = mysql_query("SELECT movies.movieid FROM movies WHERE movies.name = "$mname"") or die('Error!' . mysql_error());

//add rating info to table
$query2= mysql_query("INSERT INTO rating (rating, movieid) VALUES ("$rating", "$result")") or die('Error!' . mysql_error());

mysql_query($result);
mysql_query($query2);

//tie director to the movie

//find movieid
$mid = mysql_query("SELECT movies.movieid
FROM movies
WHERE movies.name = "$mname"") or die('Error!' . mysql_error());

//find dirid
$did = mysql_query("SELECT director.dirid
FROM director
WHERE director.lastname = "$dlast"
AND WHERE director.firstname = "$dfirst")" or die('Error!' . mysql_error());
//combine results
$add = mysql_query("INSERT INTO directormovie (directorid, movieid) VALUES ("$did", "$mid")") or die('Error!' . mysql_error());

mysql_query($mid);
mysql_query($did);
mysql_query($add);

//modify actor table


//find actor id
$aid = mysql_query("SELECT actor.actorid
FROM actor
WHERE actor.lastname = "$alast"
AND WHERE actor.firstname = "$afirst"") or die('Error!' . mysql_error());


//tie actor and movie together
$add1 = mysql_query("INSERT INTO actormovie (actorid, movieid) VALUES ("$aid", "$mid")") or die('Error!' . mysql_error());

mysql_query($aid);
mysql_query($add1);
mysql_close($con);
?>



<p>
test 2.
</p>
</body>
</html>
[/code]

Share this post


Link to post
Share on other sites
Well for one
[code]
it's supposed to be
$query="INSERT INTO movie (name, genre, description) VALUES ('$mname', '$genre', '$mdesc')";
$result = mysql_query($query)or die('Error!' . mysql_error());
[/code]
not
[quote]
$query ="INSERT INTO movie (name, genre, description) VALUES ("$mname", "$genre", "$mdesc")"
or die('Error!' . mysql_error());
mysql_query($query);
[/quote]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.