Hello, I'm trying to create a simple php blog thing, and I can't get the commenting to work..
blog.php?id=2
On that page, there is a form what is used to comment, it goes to send.php
That php has this query in it:
$yhteys = mysql_connect('10.5.49.32', '09A_user', 'pass');
mysql_select_db('09A_Jere', $yhteys);
mysql_query("INSERT INTO `Blog_kommentit` (`kayttajat` , `kommentti` , `kirjid` ) VALUES ('$kayttajat', '$kommentti', '$id')") or die(mysql_error())$sql = "SELECT * FROM Blog_kommentit WHERE kirjid='$id' ORDER BY id";;
mysql_close($yhteys);
header('Location: ' . $_SERVER['HTTP_REFERER']);
How can I make the $id to be previous pages id (2)? This shouldn't be anything hard and I'm kinda amazed why I am stuck in this, any help will be appreciated.
If I just put $id I get this error:
Cannot add or update a child row: a foreign key constraint fails (`09A_Jere/Blog_kommentit`, CONSTRAINT `kommentti_kirjoitus` FOREIGN KEY (`kirjid`) REFERENCES `Blog_kirjoitukset` (`id`))
Here is how my database works:
(Kayttajat = username, kommentti = comment)