Unexpected T-String Error

jackthebookie

Hi,

I am following a beginners tutorial on php/msql and am encountering a t-string error on a line that is only html.

The code looks like this:

<?php
include("dbconnect.php");
if ($POST["submit"] == "Sign")
{
$query = "insert into guestbook
(name,location,email,url,comments)
values
($POST'$name', $POST'$location', $POST'$email', $POST'$url', $POST'$comments')
;
mysql_query($query) or
die (mysql_error());
?>

<h2>Thanks!</h2>

<h2><a href="view.php">View my guestbook.</a></h2>

<?php
}
else
{
include("sign.php");
}
?>

The error occurs on the "View my guestbook" line.

When I entirely remove that line I get the same error on the else statement's include line.

Any suggestions would be appreciated.

Thanks,

jack

Radon3k

Try this:

<?php 
include("dbconnect.php"); 
if ($_POST["submit"] == "Sign") 
{ 
$query = "INSERT INTO guestbook 
(name,location,email,url,comments) 
VALUES 
($_POST['$name'], $_POST['$location'], $_POST['$email'], $_POST['$url'], $_POST['$comments']);

mysql_query($query) or 
die (mysql_error()); 
?> 

<h2>Thanks!</h2> 

<h2><a href="view.php">View my guestbook.</a></h2> 

<?php 
} 
else 
{ 
include("sign.php"); 
} 
?>

jackthebookie

I cut and pasted your code and this time I got this error:

Parse error: parse error, unexpected T_VARIABLE, expecting ']' in C:\Program Files\Apache Group\Apache2\htdocs\create_entry.php on line 21

Line 21 referred to this line:

($POST['$name'], $POST['$location'], $POST['$email'], $POST['$url'], $_POST['$comments']);

Thanks again.

jpmoriarty

get rid of the $'s in the arrays:

$POST['name'], $POST['location'], $POST['email'], $POST['url'], $_POST['comments']

jackthebookie

JP,

I tried that and ended up back where I started:

Parse error: parse error, unexpected T_STRING in C:\Program Files\Apache Group\Apache2\htdocs\create_entry.php on line 29

Line 29 refers to the "View my guestbook." line.

I truly appreciate your assisitance and fast replies. I am willing to try any suggestions regarding this piece. I understand the logic and whatnot but I think the tutorials I have been using are outdated. I am leaving right now to walk to Quantum Books on MIT's campus to buy a better rerference - I will be back soon, and well armed!

Thanks

Radon3k

Thanks jpmoriarty, I forgot about those. jackthebookie, try this:

<?php 
include("dbconnect.php"); 
if ($_POST["submit"] == "Sign") {

$query = "INSERT INTO guestbook 
(name,location,email,url,comments) 
VALUES 
($_POST['name'], $_POST['location'], $_POST['email'], $_POST['url'], $_POST['comments']");

mysql_query($query) or 
die (mysql_error()); 

echo("<h2>Thanks!</h2>");
echo("<h2><a href='/view.php'>View my guestbook.</a></h2>");
} else {
include("sign.php"); 
} 
?>

jpmoriarty

your problem is you're not ending the insert quote way before: you have $query = ... and then you dont end the " (or at least it should be outside the parenthesis)

jackthebookie

Guys, I have scrapped that guestbook tutorial. (Even more errors, especially in the mysql queries.) It was originally written for older versions of both php and mysql. I picked up a couple updated books yesterday and am starting anew today. Surely I will be posting a bunch of new problems in the near future. Your responsiveness has been a nice relief. Thanks again.