addslashes is rendering the slash in the browser

[bradgrafelman]

gwh;10944295 wrote:

There are a lot of items in my database with that title. Do you mean I have to go through and change every single title by putting a backslash before the apostrophe in the database?

No, that'd be silly.. unless you want people to say out loud "Man, I wish I could buy a men backslash single-quote 'S' shirt!"

The backslash, used to prevent invalid syntax/markup, should be added whenever appropriate (e.g. you're inserting the data into an HTML attribute or other entity where a single quote has special meaning).

EDIT: While this might be unrelated, sounds like you also have an un-normalized database.

[gwh]

But this is where it's getting inserted:

<li class="layout-full" onclick="openDMXzoneLightbox('../../../images/catalogue/business/corporate/Large/<?php echo $item['itemImage'] . '.jpg'; ?>', {title:'<?php echo addslashes($item['itemTitle']);?>', width:650, height:776, preset:'minimalistic'}, window);return document.MM_returnValue">

This line is outputting data from the database:

title:'<?php echo addslashes($item['itemTitle']);?>'

The backslash, used to prevent invalid syntax/markup, should be added whenever appropriate (e.g. you're inserting the data into an HTML attribute or other entity where a single quote has special meaning).

I can't add it where it's appropriate because the item title is coming from the database so I can't selectively add a backslash. I don't understand. Can you clarify?

[bradgrafelman]

You can selectively add a backslash wherever you need... just because you're retrieving data from a database doesn't mean you have to leave it in its original form before echo'ing it.

As Weedpacket pointed out, the backslash is present for the LI tag, but not for the A tag nested inside of it. Thus, you apparently don't have similar code for the A tag as the code you posted.

[gwh]

Got it - understand now. Thanks for the help.

[gwh]

Sorry to come back to this issue but I just noticed that even though it's working now, I looked in the source code of the page and I found that it was outputting an error:

<b>Warning</b>: Unexpected character in input: '\' (ASCII=92) state=1 in <b>/Applications/MAMP/htdocs/new_site/business/catalogue_business.php</b> on line <b>108</b><br />
<br />
<b>Warning</b>: Unexpected character in input: '\' (ASCII=92) state=1 in <b>/Applications/MAMP/htdocs/new_site/business/catalogue_business.php</b> on line <b>109</b><br />

Lines 108 and 109 refer to:

      <li class="layout-full" onclick="openDMXzoneLightbox('../../../images/catalogue/Large/<?php echo $item['itemImage'] . '.jpg'; ?>', {title:'<?php echo addslashes($item[\'itemTitle']);?>', width:650, height:776, preset:'minimalistic'}, window);return document.MM_returnValue">
        <a href="javascript:void(0);" onclick="openDMXzoneLightbox('../../../images/catalogue/Large/<?php echo $item['itemImage'] . '.jpg';?>', {title:'<?php echo addslashes($item[\'itemTitle']);?>', width:650, height:776, preset:'minimalistic'}, window);return document.MM_returnValue">

It must have something to do with the way I escaped the apostrophes, ie.

<?php echo addslashes($item[\'itemTitle']);?>

Do you know how to remove this warning?

[djjjozsi]

in this case the ' is a part of your variable name:
This should be:

<?php echo addslashes($item['itemTitle']);?>

[gwh]

I'm really confused now. Yes I removed the backslash so it's like this again:

<?php echo addslashes($item['itemTitle']);?>

But strangely enough even though the source code looks like this:

title:'Ladies and Men\'s Shirts ', width:650, height:776'

...it's not rendering the backslash in the browser. I mean this was the reason why I asked the question in the first place. What I mean is, the problem seems to have been fixed but I didn't do anything because since I removed that backslash the code is exactly as it was when I asked the question in the first place.

Any idea?

[djjjozsi]

after "shirts" is there a tabulator?

<?php echo addslashes(trim($item['itemTitle']));?>

but in your original code snipet there was no addslashes() applied on the itemtitle...

[gwh]

There could be some spaces at the end of the title name in my database (if that's what you mean by a tabulator?)

I showed the following in my first post:

<?php echo addslashes($item['itemTitle']);?>

...so yes it was there in my original code snippet.

[bradgrafelman]

I'm confused as to what your question is. You have this coming from your database: Men's Shirts.

Because there is a single quote in that data, and because the 'title' attribute is delimited by single quotes, you apply [man]addslashes/man to properly escape the single quote in the data, thus it is outputted as: Men\'s Shirts.

Your source code shows the backslash before the single quote, confirming what we expected to see.

What's the problem?

[gwh]

It seems to be ok now so I guess this is well and truly solved.