Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';

paulbray

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ',' or ';' in C:\xampp\htdocs\test\page2.php on line 28

1.<html>
2.<head>
3.</head>
4.<body>
5.<?php
6.
7.$conn = mysql_connect ('localhost','root','');
8.
9. if (!$conn) {
10.  die ("Can not connect to database); " . mysql_error());
}

mysql_select_db("prices",$conn);

$sql = "SELECT * FROM suppliers";

$mydata = mysql_query($sql,$conn);
echo "<TABLE BORDER=1>
<TR>
<TH>Name</TH>
<TH>VAT Registered</TH>
<TH>Cashback</TH>
</TR>";

while ($record = mysql_fetch_array($mydata)) {
echo "<FORM action=page2.php method=post>";
echo "<tr>";
echo "<TD>""<input type=text name=Name value="$record['Name']"</TD>";//this is line which flags up error?
echo "<TD>" "<input type=text name=VATReg value="$record['VATReg'] "</TD>";
echo "<TD>" "<input type=text name=Cashback value="$record['Cashback']"</TD>";
echo "</TR>";
}
echo "</TABLE>";
mysql_close($conn);
?>

</body>

</html>

bradgrafelman

You've got unescaped double quotes inside of a string delimited by double quotes. For a literal double quote to appear inside such a string, you must escape it (e.g. prepend it with a backslash). See the manual page for the [man]string[/man] type for more information/examples.

Derokorian

You can't put 2 strings next to each other and expect PHP to know what to do so this:

"<TD>""<input type=text name=Name value="$record['Name']"</TD>";

Is actually a series of strings that php can't work with because there is nothing connectin them (like the concatenation operator, or just leaving it in one string). Listen to brad as well, you need to escape quote to put them in strings. Also you are creating invalid HTML because you aren't closing a single one of those input tags.