formatting echo statements

jkatcher

Here's my code:

echo
"<p><b>
Thank you, you've been added to the promotions database.</p></b>";

But what I really want is to format it into an html table. Each time i try to do it, I get a PHP error message.

echo
"<table width="500" cellpadding="0" cellspacing="0" border="0">
<td>Thank you, you've been added to the promotions database.</td>";

What am I doing wrong?

tserbis

echo 
'<table width="500" cellpadding="0" cellspacing="0" border="0"> 
<td>Thank you, youBACKSLASH_HERE've been added to the promotions database.</td>';

jkatcher

thank you!!

jkatcher

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in C:\Domains\seattlebandsonline.com\wwwroot\processFormPromo.php on line 62

That's the error I got after I put this code into my page:

echo

'<table width="500" cellpadding="0" cellspacing="0" border="0">
<td>Thank you, you/'ve
been added to the promotions database.</td>';

what do you think?

keith73

if you use ' to enclose your string then you need to escape any ' in the string with \'

if you use " to enclose your string then you need to escape any " with \"

keith

jkatcher

I'm not sure why it's not working then. This is all of my code. It's been working fine until I tried to put the table in the echo statement below. Do you see anything that looks wrong? I now that the code above the echo works...thanks.

<?php
include 'misc.inc';
include 'head.asp';

$name = $HTTP_POST_VARS['name'];

/ connect to server(mysql) with pconnect for persistent
connection, not to close then reconnect /
mysql_pconnect("$host","$user","$password")
or die ("Couldn't connect to the server.");

/ connect to db (seattlebands) /
mysql_select_db("seattlebands")
or die ("Couldn't connect to the database.");

/ add row to table 'promoters' and insert input values /
$query = "INSERT INTO promoters (
lname,
fname,
contact,
namePromoCo,
ownPromoCo,
diffThanName,
bandShowBooked,
bandTourBooked,
venueBook,
favGenre,
favBands,
favVenues,
rate,
workWithNew,
venueLikeNew,
bandDrawNeeded
)
VALUES (
'$lname',
'$fname',
'$contact',
'$namePromoCo',
'$ownPromoCo',
'$diffThanName',
'$bandShowBooked',
'$bandTourBooked',
'$venueBook',
'$favGenre',
'$favBands',
'$favVenues',
'$rate',
'$workWithNew',
'$venueLikeNew',
'$bandDrawNeeded'
)";

$result = mysql_query($query)

or die (mysql_error());

/ THIS IS WHERE THE PROBLEM IS /
echo

'<table width="500" cellpadding="0" cellspacing="0" border="0">
<td>Thank you, you/'ve
been added to the promotions database.</td>\';

include 'bottomnav.asp';
include 'footer.asp';
?>

</body>
</head>
</html>

keith73

echo
'<table width="500" cellpadding="0" cellspacing="0" border="0">
<td>Thank you, you/'ve
been added to the promotions database.</td>';

it's right there. you have an unescaped single quote in your string.

Thank you, you/'ve
should be:
Thank you, you\'ve

keith

jkatcher

I might be the dumbest person alive, but I'm still getting that same error. Might you be able to show me what the code is for that particular section?

echo

'<table width="500" cellpadding="0" cellspacing="0" border="0">
<td>Thank you, you've
been added to the promotions database.</td>\';

thank you so much.

keith73

hmm, i think the forum keeps removing my backslashes.

point is, you need a backslash before the ' in you've.

use double quotes to enclose your string but any double quotes that have to be part of the string should be escaped using a \ before the "

keith